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 % |