Technical name: 0RT_C20_Q0002
Use
This Query enables you to monitor stock planning at store level for the Store Planning step in the
Best Practice Scenario 1_SAP.The Query shows planning and actual data and the variances between these and the Opening Stock, Additional Purchases, Price Reductions, Markdowns, Sales, Shrinkage, Returns, Stock Corrections, Closing Stock, Range of Coverage and Inventory Turn key figures.
Free Characteristics
InfoObject |
Description |
0RT_SEASON |
Season |
0SALESORG |
Sales Organization |
0DISTR_CHAN |
Distribution Channel |
0PLANT__0SALES_DIST |
Sales District |
0PLANT |
Plant |
0CALMONTH |
Calendar Year/Month |
Rows
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0RT_C20_CK0012 |
Opening Stock |
0RTPURCHSV |
Additional Purchases |
0RTMINSADST |
Price Reduction |
0RTMSPRENSV |
Markdowns |
0RTMBAINSSV |
Sales Quantity |
0RTMINCINSV |
Shrinkage |
0RTMTRETVSV |
Returns |
0RT_C20_CK010 |
Stock Corrections, Misc. |
0RT_C20_CK011 |
Closing Stock |
0RT_C20_CK014 |
Range of Coverage |
0RT_C20_CK017 |
Inventory Turn |
0RTMISOTHSV |
Other Issues at Retail Value |
0RTMREOTHSV |
Other Receipts in Retail Value |
0RTMINCONSV |
Other Stock Correction, Negative in Retail Value |
0RTMINCOPSV |
Other Stock Correction, Positive in Retail Value |
0RTMTOSTSV |
Last Total Valuated Stock in Retail Value |
0RTMTOSTPSV |
Last Total Planned Stock in Retail Value |
0RT_C20_CK013 |
Average Monthly Sales |
0RT_C20_CK018 |
Total Sales |
0RT_C20_CK015 |
Average Stock (Actual) |
0RT_C20_CK016 |
Average Stock (Planned) |
0RT_C20_CK019 |
Planned Stock with Exception Aggregation |
Columns
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0P_VERS4 |
Actual Version |
0P_VERS1 |
Plan Version &0T_VERS& |
Planned/Actual Difference | |
Variance% |