Regular vs. Promotional Sales per Category Strategy (SAP Library - Industry-Specific Analyses)

Start of Content Area

Regular vs. Promotional Sales per Category Strategy

Technical Name: 0CMCP_C03_Q00061

Based on InfoCube: Retail POS Data (0CMCP_C03)

Use

The query shows the promotion sales in comparison to the total sales for a year.

Filters

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Calendar Year	0CALYEAR restricted to the selection variable Calendar Year (0P_CALYE)

Free Characteristics

InfoObject	Description
Category	0CM_CDT1
Subcategory	0CM_CDT2
Segment	0CM_CDT3
Sub-segment	0CM_CDT4
Sub-subsegment	0CM_CDT5
Product Group	0CM_CDT6
Brand	0CM_CDT7
Hierarchy ID	0CM_HIEID
SKU	0CM_SKU

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Category Strategy	0CM_CDT1__0CM_STRAT

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Promotion Sales/Retailer	0RTPRINSASV
Sales/Retail Value	0RTBAINSASV
Share of Promotion Sales	‘Promotion Sales/Retailer’ %A ‘Sales/Retail Value’
Share of Normal Sales	‘Difference’ %A ‘Sales/Retail Value’
Difference	‘Sales/Retail Value’ – ‘Promotion Sales/Retailer’

End of Content Area