Technical
Name: 0RMP_MC21_Q0001
This query
analyzes the performance of each product within an assortment, as well as the
performance of the assortment as a whole. You can evaluate several levels of
data, drilling down from categories to subcategories and segments. The raw data
can be used for bar charts and bubble charts.
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
0FISCVARNT |
Fiscal
Year Variant |
0SALESORG |
Sales
Organization |
0DISTR_CHAN |
Distribution
Channel |
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
0RT_SEASON |
Season |
0RT_SEASYR |
Season
Year |
0RT_SKUROLL |
SKU
Rollout |
0CM_MCATDIV |
Division |
0CM_CDT1 |
Category |
0CM_CDT2 |
Subcategory |
0CM_CDT3 |
Segment |
0RT_ASORT |
Assortment |
0CM_SKU |
Product |
0FISCPER |
Period |
Variable |
Description
|
0P_GJVM |
Fiscal
Year Variant |
0P_SAORG |
Sales
Organization |
0P_DCHAN |
Distribution
Channel |
0P_GJAHR |
Fiscal
Year |
0P_OSAIS |
Season |
0P_SEASY |
Season
Year |
0P_SKUR |
Rollout |
0P_DIVIS |
Division |
0P_CATG |
Category |
0P_SCAT |
Subcategory |
0P_SEGM |
Segment |
0P_VERS4 |
Version |
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
0RT_ASORT |
Assortment |
0RTBAINSASV |
Sales at
Retail |
0CPBAINSAPV |
Sales at
Cost |
0RMP_MC21_CK004
|
Average
Retail Price (Retail / Quantity BUOM) |
0RMP_MC21_CK002
|
Gross
Margin (Retail – Cost) |
0RMP_MC21_CK003
|
Gross
Margin % (Retail – Cost / Retail x 100) |
% of
Total Sales at Retail |
Sales
Contribution |
0RMP_MC21_CK011
|
Range of
Coverage (Inventory / Average Sales at Retail) |
0RMP_MC21_CK009
|
Inventory
Turnover (Sales at Retail / Average Inventory) |
0RMP_MC21_CK001
|
GMROI
(Gross Margin % x Inventory Turnover) |
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
0RTBAINSASV |
Sales at
Retail |
0CPBAINSAPV |
Sales at
Cost |
0RMP_MC21_CK004
|
Average
Retail Price (Retail / Quantity BUOM) |
0RMP_MC21_CK002
|
Gross
Margin (Retail – Cost) |
0RMP_MC21_CK003
|
Gross
Margin % (Retail – Cost / Retail x 100) |
% of
Total Sales at Retail |
Sales
Contribution |
0RTINCOINSV |
Shrinkage |
0RMP_MC21_CK011
|
Range of
Coverage (Inventory / Average Sales at Retail) |
0RMP_MC21_CK009
|
Inventory
Turnover (Sales at Retail / Average Inventory) |
0RMP_MC21_CK001
|
GMROI
(Gross Margin % x Inventory Turnover) |
0P_GJAHR
and 0P_VERS4 |
Actuals Restriction:
0P_GJAHR (Fiscal Year = Current Year) and 0P_VERS4 (Actuals Version = 0) |
0P_GJAHR
–1 and 0P_VERS4 |
Actuals
Last Year Restriction:
0P_GJAHR –1 (Fiscal Year = Last Year) and 0P_VERS4 (Actuals Version = 0) |
Actuals /
Planned |
Deviation
% |