Technical Name: 0RMP_MC21_Q0008
This query is a plan/actual comparison used to evaluate sales efficiency. It shows how much of the overall sales were based on temporary markdowns, permanent markdowns, and shrinkage, giving you an idea of the consumers’ price sensitivity. You can evaluate several levels of data, drilling down from categories to subcategories and segments and then to the product and color/size levels. In addition, you can evaluate seasonal trends within categories and segments.
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 |
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 |
0FISCPER |
Posting Period |
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 |
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
0CM_SKU |
Product |
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
Product KPIs |
0RMP_MC21_QT07 |
Calculated Sales at Retail |
0RMP_MC21_CK013 |
Sales at Retail |
0RTBAINSASV |
Price Reduction |
0RTINSADIST |
Markdown |
0RTSPRENSV |
Shrinkage at Retail |
0RTINCOINSV |
Price Reduction Contribution to Sales |
Price Reduction / Sales at Retail |
Markdown Contribution to Sales |
Markdown / Sales at Retail |
Shrinkage Contribution to Sales |
Shrinkage / Sales at Retail |
Technical Name: 0RMP_MC21_Q0007
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 product level.
This query is identical to the Basics Inventory Scorecard, except that color, size and seasonality are not considered.
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 |
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
0CM_MCATDIV |
Division |
0CM_CDT1 |
Category |
0CM_CDT2 |
Subcategory |
0CM_CDT3 |
Segment |
0RT_ASORT |
Assortment |
0FISCPER3 |
Posting Period |
Variable |
Description |
0P_GJVM |
Fiscal Year Variant |
0P_SAORG |
Sales Organization |
0P_DCHAN |
Distribution Channel |
0S_RQMRC |
Request ID |
0P_GJAHR |
Fiscal Year |
0P_DIVIS |
Division |
0P_CATG |
Category |
0P_SCAT |
Subcategory |
0P_SEGM |
Segment |
0P_ASMT |
Assortment |
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
0CM_SKU |
Product |
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
0RMP_MC21_CK013 |
Calculated Sales at Retail |
0RTBAINSASV |
Sales at Retail |
0RTINSADIST |
Price Reduction |
0RTSPRENSV |
Markdown |
0RTINCOINSV |
Shrinkage at Retail |
Price Reduction / Sales at Retail |
Price Reduction Contribution to Sales |
Markdown / Sales at Retail |
Markdown Contribution to Sales |
Shrinkage / Sales at Retail |
Shrinkage Contribution to Sales |
0P_VERS |
Plan Version |
0P_GJAHR and 0P_VERS4 |
Actuals Restriction: 0P_GJAHR (Fiscal Year = Current Year) and 0P_VERS4 (Version = 0) |
0P_GJAHR –1 and 0P_VERS4 |
Actuals Last Year Restriction: 0P_GJAHR –1 (Fiscal Year = Last Year) and 0P_VERS4 (Version = 0) |
Actuals / Actuals Last Year |
Deviation % |