ROI - Top 10 Promotions
Technical Name: 0CP_SLSC6_Q0008
Based on the InfoCube Sales and Trade Promotions (Planned+Actual) (0CP_SLSC6).
Use
You can use this query to get an overview of the most successful trade promotions. To determine the most successful promotions, you can compare the following key figures: actual uplift quantity, uplift costs per BUoM, sales increase, ROI, and margin/BUoM.
Filters
|
Element |
InfoObject, Restrictions, Formula |
|
Fiscal year variant |
0FISCVARNT restricted to the value ‘K4’ |
|
Fiscal year/period |
0FISCPER restricted to selection variable 0I_PRFY2 |
|
Request ID |
0REQUID restricted to the selection variable 0S_RQMRC |
|
Promotion phase |
0PERIOD_TYP restricted to the value ‘50’ |
|
Version |
0VERSION restricted to the value ‘000’ (planned/actual version) |
|
Life cycle status |
0CRM_MKTELM__0STAMKTSYS0 restricted to the value ‘30’ (complete) |
Free Characteristics
|
Element |
InfoObject, Restrictions, Formula |
|
Distribution channel |
0CP_CHANNEL |
|
Sales category |
0PR_CAT_SAL |
Rows
|
Element |
InfoObject, Restrictions, Formula |
|
CRM Marketing element |
0CRM_MKTELM without those with value ‘#’ |
|
Tactic |
0CRM_MKTELM__0CRM_TACTIC |
|
Category |
0CP_CATEG |
|
Business partner |
0BPARTNER |
Columns
|
Element |
InfoObject, Restrictions, Formula |
|
Total promotion discounts |
0BUDGET restricted to the value type (0VTYPE) ‘10’ |
|
Planned base sales quantity |
Base sales quantity for promotion (0CP_SLSC6_CK002) restricted to the value ‘20’ (planned) |
|
Billing quantity base UoM |
0BILL_QTY |
|
Actual uplift quantity |
‘Billing quantity base UoM’ – ‘planned base sales quantity’ |
|
Revenue |
0COPAREVEN restricted to the value ‘10’ |
|
Regular discounts |
0REG_DISC restricted to the value ‘10’ (actual) |
|
Uplift costs per BUoM |
‘Total promotion discounts’ / ‘actual uplift quantity’ |
|
Sales increase |
‘Revenue x actual uplift quantity’ / ‘(revenue’ – ‘regular discounts’) |
|
ROI (quantity) |
‘Actual uplift quantity’ / ‘total promotion discounts’ |
|
ROI (value) |
‘Sales increase’ / ‘total promotion discounts’ |
|
Internal value |
0INTVALUE restricted to the value ‘10’ (actual) |
|
Margin/BUoM |
(‘Revenue’ – ‘regular discounts’ – ‘total promotion discounts’) / ‘billing quantity base UoM’ |
Variables
You can use variables to make restrictions, for example, on the top 10 promotions in a distribution channel or the Top 10 promotions in a product category. To keep the query clear and user-friendly, the variables are not part of the delivery.