Preliminary Evaluation of a
Promotion
Technical Name: 0CP_SLSC6_Q0004
Based on the InfoCube Sales and Trade Promotions (Planned+Actual) (0CP_SLSC6).
Use
This query summarizes all key figures on a planned promotion. This provides you with a basis for deciding whether it makes sense economically to hold a planned trade promotion. Limit values for determining whether or not it makes sense to hold a promotion can be stored in exceptions for the query.
The query is used as a preliminary analysis for planning values that you have entered using the CRM marketing planner in the SEM layout 4TPM1551.
Filters
|
Element |
InfoObject, Restrictions, Formula |
|
Request ID |
0REQUID restricted to the selection variable 0S_RQMRC |
|
CRM Marketing element |
0CRM_MKTELM restricted to the selection variable 0S_CTELM |
|
CRM plan version |
0CRM_VERSION restricted to the selection variable 0P_PLVER |
|
Value type |
0VTYPE restricted to the value ‘20’ |
Rows
|
Element |
InfoObject, Restrictions, Formula |
|
Brand |
0CP_BRND |
|
Sales category |
0PR_CAT_SAL |
Free Characteristics
|
Element |
InfoObject, Restrictions, Formula |
|
GP: Group (hier.) |
0BP_GRP |
|
Business partner |
0BPARTNER |
Columns
|
Element |
InfoObject, Restrictions, Formula |
|
Billing quantity base UoM |
0BILL_QTY |
|
Net revenue |
0COPANETRV |
|
Average sales price/base UoM |
‘Net revenue’ / ‘billing quantity base UoM’ |
|
Predicted uplift quantity in base unit of measure |
|
|
Planned uplift quantity |
|
|
Fixed promotion discounts and costs |
|
|
Variable promotion discount |
|
|
Costs per base UoM |
(‘Variable promotion discounts’ + ‘fixed promotion discounts and costs’) / ‘billing quantity base UoM’ |
|
ROI |
‘Planned uplift quantity’ / (‘fixed promotion discounts and costs’ + ‘variable promotion discounts’ |