Cross Category Analysis and Assessment
Technical
Name: 0RMP_MC01_Q0001
Use
This query
is used for cross category sales analysis and assessment. It takes into account
only actuals from the current year and previous year.
For more
detailed data, you can drill down into subcategories, segments,
seasons/rollouts and posting periods, which is the smallest time entity in the
cube.
Filter
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0FISCVARNT |
Fiscal
Year Variant |
|
0SALESORG |
Sales
Organization |
|
0DISTR_CHAN |
Distribution
Channel |
Free Characteristics
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0CM_MCATDIV |
Division |
|
0CM_CDT2 |
Subcategory |
|
0CM_CDT3 |
Segment |
|
0RT_SEASON |
Season |
|
0CM_CDT1__0RT_ROLE |
Role |
|
0CM_CDT1__0RT_STRAT |
Strategy |
|
0FISCPER3 |
Posting
Period |
Variables Used
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0P_GJVM |
Fiscal
Year Variant |
|
0P_SAORG |
Sales
Organization |
|
0P_DCHAN |
Distribution
Channel |
|
0P_DIVIS |
Division |
|
0P_GJAHRGJAHR |
Fiscal
year |
|
0P_VERS4 |
Version |
Rows
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0CM_CDT1 |
Category |
Columns
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0RTBAINSASV |
Sales at
Retail |
|
% of
Total Sales at Retail |
Sales
Contribution |
|
0CPBAINSAPV |
Sales at
Cost |
|
0CPBAINSABU |
Sales
(Base Unit of Measure) |
|
0RMP_MC01_CK002
|
Gross
Margin (Retail – Cost) |
|
0RMP_MC01_CK003
|
Gross
Margin % (Retail – Cost / Retail x 100) |
|
0RMP_MC01_CK004
|
Average
Retail (Retail / Quantity BUOM) |
|
0RMP_MC01_CK005
|
Average
Inventory (Inventory / Total Inventory) |
|
0RMP_MC01_CK006
|
Average
Sales at Retail (Sales at Retail / Total Sales at Retail) |
|
0RMP_MC01_CK007
|
Inventory
Turnover (Sales at Retail / Average Inventory) |
|
0RMP_MC01_CK008
|
Range of
Coverage (Inventory / Average Sales at Retail) |
|
0RMP_MC01_CK009
|
GMROI
(Gross Margin % x Inventory Turnover) |
|
0P_GJAHR
–1 and 0P_VERS4 |
Actuals
Last Year. Restriction: 0P_GJAHR –1
(Fiscal Year = Last Year) and 0P_VERS4 (Version = 0) |
|
0P_GJAHR
and 0P_VERS4 |
Actuals. Restriction: 0P_GJAHR (Fiscal Year = Current Year) and 0P_VERS4 (Version = 0) |
|
Actuals /
Actuals Last Year |
Deviation
% |