Average Price: SKU (SAP Library - Consumer Products)

Start of Content Area

Average Price: SKU

Technical Name: 0CMCP_C02_Q00128

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

Use

For price analysis purposes, the query shows a comparison of average prices in the market as a whole, at the retailer, and among 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: SKU (0P_CVRS1)

Free Characteristics

InfoObject	Description
Product Group Strategy	0CM_CDT6__ 0CM_STRAT
Hierarchy ID	0CM_HIEID restricted to the selection variable Hierarchy ID of the CDT (0CMHIEID)
Category	0CM_CDT1

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Product Group	0CM_CDT6
SKU	0CM_SKU

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
Average Sales Price	‘Retailer’s Revenue/‘Retailer’s Sales’
Retailer’s Sales	0CMCP_RESAL
Retailer’s Sales	0CMCP_RESAL2
Share of Retailer’s Sales	%GT ‘Retailer’s Sales’
Sales: Competitor 1	0CMCP_SALCP1
Sales: Competitor 1 (Equivalent Unit)	0CMCP_SALCP1B
Sales: Competitor 2	0CMCP_SALCP2
Sales: Competitor 2 (Equivalent Unit)	0CMCP_SALCP2B
Average Price: Competitor 1	‘Sales: Competitor 1’/‘Sales: Competitor 1 (equivalence unit)’
Average Price: Competitor 2	‘Sales: Competitor 2’/‘Sales: Competitor 2 (equivalence unit)’

End of Content Area