Productivity Scorecard for Basics 
Technical Name: 0RMP_MC21_Q0009
Use
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 levels. In addition, you can evaluate seasonal trends within categories and segments.
This query is identical to the Productivity Scorecard for Fashion, except that color and seasonality are not considered.
Filter
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
Fiscal Year Variant |
0FISCVARNT |
|
Sales Organization |
0SALESORG |
|
Distribution Channel |
0DISTR_CHAN |
|
Request ID |
0REQUID |
|
Fiscal Year |
0FISCYEAR |
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_ASORT |
Assortment |
|
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_CATG |
Category |
|
0P_SCAT |
Subcategory |
|
0P_SEGM |
Segment |
|
0P_ASMT |
Assortment |
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) |
|
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 |
Productivity Scorecard for
Fashion
Technical Name: 0RMP_MC21_Q0008
Use
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.
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 |
|
0FISCPER |
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_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 % |