Fashion Inventory Scorecard 
Technical Name: 0RMP_MC21_Q0006
Use
This query is a plan/actual comparison that gives you an overview of inventory-related key figures. For each key figure, the report shows planned, actuals (this year) and actuals (last year). Deviations of planned sales and actuals TY are calculated to see immediately whether the considered segment is performing as planned or not. You can drill down through the segments to the products and color/size levels.
Filter
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0FISCVARNT |
Fiscal Year Variant |
|
0SALESORG |
Sales Organization |
|
0DISTR_CHAN |
Distribution Channel |
|
0REQUID |
Request ID |
|
0FISCYEAR |
Fiscal Year |
Free Characteristics
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0CM_MCATDIV |
Division |
|
0CM_CDT1 |
Category |
|
0CM_CDT2 |
Subcategory |
|
0CM_CDT3 |
Segment |
|
0RT_SEASON |
Season |
|
0RT_SEASYR |
Season Year |
|
0RT_SKUROLL |
SKU Rollout |
|
0RT_ASORT |
Assortment |
|
0RT_COLOR |
Color |
|
0RT_SIZE |
Size |
|
0FISCPER3 |
Posting Period |
Variables Used
|
Variable |
Description |
|
0P_GJVM |
Fiscal Year Variant |
|
0P_SAORG |
Sales Organization |
|
0P_DCHAN |
Distribution Channel |
|
0S_RQMRC |
Request ID |
|
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 |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0CM_SKU |
Product |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0RMP_MC21_CK008 |
End of Period Inventory |
|
0RTGRPDVSV |
Goods Receipts at Retail |
|
0RMP_MC21_CK003 |
Gross margin % (Retail – Cost / Retail * 100) |
|
0RMP_MC21_CK009 |
Inventory Turnover (Sales at Retail / Average Inventory) |
|
0RMP_MC21_CK011 |
Range of Coverage (Inventory / Average Sales at Retail) |
|
0RMP_MC21_CK001 |
GMROI (Gross Margin % x Inventory Turnover) |
|
0RTINCOINSV |
Shrinkage |
|
0P_VERS |
Plan Version |
|
0P_GJAHR and 0P_VERS4 |
Actuals Restriction: 0P_GJAHR (Fiscal Year = Current Year) and 0P_VERS4 (Version = 0) |
|
0P_GJAHR and 0P_VERS4 |
Actuals Last Year Restriction: 0P_GJAHR –1 (Fiscal Year = Last Year) and 0P_VERS4 (Version = 0) |
|
Actuals / Actuals Last Year |
Deviation % |