Plan Analysis for Fashion 
Technical Name: 0RMP_MCC21_Q0003
Use
This query is used for fashion planning. It aggregates the color plan to several higher levels in order to show the totals and compare them to historical color plans. All planning levels for the CDT (Consumer Decision Tree), assortments, and seasonality are included.
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 |
Rollout |
|
0RT_ASORT |
Assortment |
|
0RT_COLOR |
Color |
|
0RT_SIZE |
Size |
|
0MATERIAL_VENDOR |
Vendor |
|
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) |
|
0RTBAINSASV |
Sales at Retail |
|
0RTBAINSAPV |
Sales at Cost |
|
0RMP_MC21_CK002 |
Gross Margin (Retail – Cost) |
|
0RMP_MC21_CK003 |
Gross Margin % (Retail – Cost / Retail x 100) |
|
0RMP_MC21_CK009 |
Inventory Turn |
|
0RMP_MC21_CK011 |
Range of Coverage |
|
0RMP_MC21_CK001 |
GMROI (Gross Margin % x Inventory Turnover) |
|
0RMP_MC21_CK017 |
Number of Colors |
|
0RMP_MC21_CK018 |
Number of Products |
|
0RMP_MC21_CK019 |
Number of Assortments |
|
0RMP_MC21_CK020 |
Number of Location in Assortments |
|
0P_GJAHR and 0P_VERS3 |
Plan Version Restriction: 0P_GJAHR (Fiscal Year) and 0P_VERS3 (Plan Version) |
|
0P_GJAHR and 0P_VERS4 |
Actuals Restriction: 0P_GJAHR – 1 (Fiscal Year) and 0P_VERS4 (Actuals Version = 0) |
|
Actuals / Planned |
Deviation % |