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 % |