Top N% Sellers
Technical Name: 0RMP_MC21_Q0011
Use
This query quickly shows the top
N
% (where
N
is a variable) of products within a category or subcategory. It gives you an overview of plan deviations of products so that you can see which products that need to be given special attention in order to ensure their success; for example, by increasing the budget to buy additional stock.
The report is usually run on a daily basis.
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 |
|---|---|
0CM_MCATDIV |
Division |
0CM_CDT1 |
Category |
0CM_CDT2 |
Subcategory |
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 |
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 |
0RTGRPDVSV |
Goods Receipts at Retail |
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 % |