Promotion Share by Category Strategy (SAP Library - Industry-Specific Analyses)

Start of Content Area

Promotion Share by Category Strategy

Technical name: 0CMCP_C03_Q00041

Based on InfoCube: Retail POS Data (0CMCP_C03)

Use

This query shows the promotion sales for the strategy as part of the promotion analysis.

Filters

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Hierarchy ID	0CM_HIEID restricted to the selection variable Hierarchy ID of the CDT (0CMHIEID)
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
SKU	0CM_SKU

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Category Role	0CM_CDT1__ 0CM_ROLE

Columns

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

End of Content Area