Promotion Portfolio
Analysis (SU)
Technical Name: 0CP_SLSCA_Q0007
Based on the InfoCube Sales and Trade Promotions (Planned+Actual) in SU (0CP_SLSCA).
Use
For information on using the query, please see Promotion Portfolio Analysis.
If the analysis covers trade promotions from multiple currency areas, the currencies should be converted to one standard currency in the value key figures. The conversion can be set up individually for each value key figure.
Filters
Element |
InfoObject, Restriction, Formula |
Fiscal Year Variant |
0FISCVARNT restricted to the value K4 |
Fiscal Year/Period |
0FISCPER restricted to 0I_PRFY2 |
Request ID |
0REQUID restricted to 0S_RQMRC |
Promotion Phase |
0PERIOD_TYP restricted to the value 50 |
CRM Plan Version |
0CRMVERSION restricted to the value CP_FREE |
Life Cycle Status |
0CRM_MKTELM__0STAMKTSYS0 restricted to the value 30 |
CRM Marketing Element |
0CRM_MKTELM without those with value # |
Free Characteristics
Element |
InfoObject, Restriction, Formula |
Category |
0CP_CATEG |
Business Partner (Head Office) |
0BP_GRP restricted to 0S_BPGRP |
Sales Category |
0PR_CAT_SAL |
Rows
Element |
InfoObject, Restriction, Formula |
Tactic |
0CRM_TACTIC |
Columns
Key Figures Structure
Element |
InfoObject, Restriction, Formula |
Total Promotion Discounts |
0BUDGET restricted to the value type 10 (actual) |
Number of Promotions |
0CRM_CNTCPG |
Average Discount per Promotion |
Total promotion discounts / number of promotions |
Planned Base Sales Quantity |
0CP_SLSCA_RK002 |
Actual Billing Quantity SU |
0INV_QTY restricted to the value type 10 (actual) |
Actual Uplift Quantity |
Actual billing quantity SU - planned base sales quantity |
Uplift Costs per SU |
Total promotion discounts / actual uplift quantity |
Actual Revenue |
0COPAREVEN restricted to the value type 10 (actual) |
Regular Discounts (Actual) |
0REG_DISC restricted to the value type 10 (actual) |
Additional Sales |
NODIM (actual uplift quantity / actual billing quantity SU) * (actual revenue – regular discounts (actual)) – total promotion discounts |
ROI (Quantity) |
Actual uplift quantity / total promotion discounts |
ROI (Value) |
Additional sales / total promotion discounts |
Internal Value |
0INTVALUE restricted to the value type 10 (actual) |
Margin/SU |
(Revenue – internal value) / actual billing quantity (SU) |