Assortment Analysis and Assessment
Technical Name: 0RMP_MC21_Q0001
Use
This query analyzes the performance of each product within an assortment, as well as the performance of the assortment as a whole. You can evaluate several levels of data, drilling down from categories to subcategories and segments. The raw data can be used for bar charts and bubble charts.
Filter
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|---|---|
0FISCVARNT |
Fiscal Year Variant |
0SALESORG |
Sales Organization |
0DISTR_CHAN |
Distribution Channel |
Free Characteristics
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|---|---|
0RT_SEASON |
Season |
0RT_SEASYR |
Season Year |
0RT_SKUROLL |
SKU Rollout |
0CM_MCATDIV |
Division |
0CM_CDT1 |
Category |
0CM_CDT2 |
Subcategory |
0CM_CDT3 |
Segment |
0RT_ASORT |
Assortment |
0CM_SKU |
Product |
0FISCPER |
Period |
Variables Used
Variable |
Description |
|---|---|
0P_GJVM |
Fiscal Year Variant |
0P_SAORG |
Sales Organization |
0P_DCHAN |
Distribution Channel |
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 |
0P_VERS4 |
Version |
Rows
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|---|---|
0RT_ASORT |
Assortment |
0RTBAINSASV |
Sales at Retail |
0CPBAINSAPV |
Sales at Cost |
0RMP_MC21_CK004 |
Average Retail Price (Retail / Quantity BUOM) |
0RMP_MC21_CK002 |
Gross Margin (Retail – Cost) |
0RMP_MC21_CK003 |
Gross Margin % (Retail – Cost / Retail x 100) |
% of Total Sales at Retail |
Sales Contribution |
0RMP_MC21_CK011 |
Range of Coverage (Inventory / Average Sales at Retail) |
0RMP_MC21_CK009 |
Inventory Turnover (Sales at Retail / Average Inventory) |
0RMP_MC21_CK001 |
GMROI (Gross Margin % x Inventory Turnover) |
Columns
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|---|---|
0RTBAINSASV |
Sales at Retail |
0CPBAINSAPV |
Sales at Cost |
0RMP_MC21_CK004 |
Average Retail Price (Retail / Quantity BUOM) |
0RMP_MC21_CK002 |
Gross Margin (Retail – Cost) |
0RMP_MC21_CK003 |
Gross Margin % (Retail – Cost / Retail x 100) |
% of Total Sales at Retail |
Sales Contribution |
0RTINCOINSV |
Shrinkage |
0RMP_MC21_CK011 |
Range of Coverage (Inventory / Average Sales at Retail) |
0RMP_MC21_CK009 |
Inventory Turnover (Sales at Retail / Average Inventory) |
0RMP_MC21_CK001 |
GMROI (Gross Margin % x Inventory Turnover) |
0P_GJAHR and 0P_VERS4 |
Actuals Restriction: 0P_GJAHR (Fiscal Year = Current Year) and 0P_VERS4 (Actuals Version = 0) |
0P_GJAHR –1 and 0P_VERS4 |
Actuals Last Year Restriction: 0P_GJAHR –1 (Fiscal Year = Last Year) and 0P_VERS4 (Actuals Version = 0) |
Actuals / Planned |
Deviation % |