Technical Name: 0RMP_MC21_Q0005
This query is a plan/actual comparison used for basics planning. It gives you an overview of the sales-related key performance indicators (KPIs). For each key figure, the report shows planned, actuals (this year) and actuals (last year). Deviations for planned and actual sales show whether the segment is performing as planned or not. You can drill down through the segments to the product level.
This query is identical to the Fashion Sales 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) |
0RTBAINSASV |
Sales at Retail |
0RTBAINSAPV |
Sales at Cost |
0CPBAINSABU |
Sales (Base Unit of Measure) |
0RMP_MC21_CK002 |
Gross Margin (Retail – Cost) |
0RMP_MC21_CK003 |
Gross Margin % (Retail – Cost / Retail x 100) |
0RMP_MC21_CK004 |
Average Retail Price (Retail / Quantity BUOM) |
% of Total Sales at Retail |
Sales Contribution |
0P_VERS |
Plan Version |
0P_GJAHR and 0P_VERS4 |
Actuals Restriction: 0P_GJAHR – 1 (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 % |