Promotion Sales: Category (SAP Library - Industry-Specific Analyses)

Start of Content Area

Promotion Sales: Category

Technical Name: 0CMCP_C02_Q00051

Based on InfoCube: Syndicated Data: Retail Panel (0CMCP_C02)

Use

The query shows promotion sales and promotion quantities in the entire market for the retailer and for the competition.

Filters

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Calendar Year	0CALYEAR restricted to the selection variable Calendar Year (0P_CALYE)
Analysis Level	0CMVRSIO restricted to the selection variable Analysis Level: Category (0P_CVRS1)

Free Characteristics

InfoObject	Description
Hierarchy ID	0CM_HIEID restricted to the selection variable Hierarchy ID of the CDT (0CMHIEID)

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Category Role	0CM_CDT1__0CM_ROLE
Category	0CM_CDT1

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Promotion Sales: Retailer	0CMCP_PROSARET
Promotion Sales: Entire Market	0CMCP_PROSATOT
Promotion Sales: Competitor 1	0CMCP_PROSACP1
Promotion Sales: Competitor 2	0CMCP_PROSACP2
Promotion Sales: Competitor 3	0CMCP_PROSACP3
Promotion Sales: Competitor 4	0CMCP_PROSACP4

End of Content Area