Sales and Receipts Exceptions 
Technical Name: 0RMP_MC21_Q0010
Use
This query is used trigger exceptions based on a plan/actual comparison. The analysis is independent of the business type (fashion or basics) and shows the sales and retail and the receipts at retail. Both key figures are shown at plan, actual TY, actual LY, and plan/actual deviation. Exceptions can be defined on both deviations in order to see whether or not the actuals meet the plan or not.
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 |
|
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_FYEAR and 0P_VERS4 |
Actuals Restriction: 0P_FYEAR (Fiscal Year Variant = Current Year) and 0P_VERS4 (Version = 0) |
|
0P_FYEAR –1 and 0P_VERS4 |
Actuals Last Year Restriction: 0P_FYEAR –1 (Fiscal Year Variant = Last Year) and 0P_VERS4 (Version = 0) |
|
Actuals / Actuals Last Year |
Actuals / Actuals Last Year |