Stock (Values+Quantities) Merchandise Planning
Technical name: 0RT_C21_Q0003
Use
This Query enables you to monitor value-based (at cost value) and quantity-based stock planning at merchandise category level for the Merchandise Category 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, 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 |
0PURCH_ORG |
Purchasing Organization |
0MATL_GROUP |
Merchandise Category |
0CALMONTH |
Calendar Year/Month |
Rows
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0RT_C20_CK0012 |
Opening Stock (Cost) |
0RTPURCHSV |
Additional Purchase (Cost) |
0CPMBAINSPV |
Sales Quantity (Cost) |
0CPMINCINPV |
Shrinkage (Cost) |
0CPMTRETVPV |
Returns (Cost) |
0RT_C21_CK011 |
Other Stock Correction (Cost) |
0RT_C21_CK010 |
Closing Stock (Cost) |
0RT_C21_CK015 |
Range of Coverage (Cost) |
0RT_C21_CK019 |
Inventory Turn (Cost) |
0RT_C21_C021 |
Opening Stock (Qty) |
0RTPURCHBU |
Additional Purchase (Qty) |
0CPBAINSABU |
Sales Quantity (Qty) |
0CPINCOINBU |
Shrinkage (Qty) |
0CPTRETVBU |
Returns (Qty) |
0RT_C21_CK20 |
Other Stock Correction (qty) |
0RT_C21_C019 |
Closing Stock (Qty) |
0RT_C21_CK021 |
Range of Coverage(Qty) |
0RT_C21_CK025 2 |
Inventory Turn (Qty) |
0RTMISOTHBU |
Other Issues / BUn |
0RTMISOTHPV |
Other Issues in Cost Value |
0RTMREOTHBU |
Other Receipts/BUn |
0RTMREOTHPV |
Other Receipts in Cost Value |
0CPINCOONBU |
Other Stock Correction (Negative) / BUn |
0CPMINCONPV |
Other Stock Correction (Negative) in Cost Value |
0CPINCOOPBU |
Other Stock Correction (Positive) / BUn |
0CPMINCOPPV |
Other Stock Correction (Positive) in Cost Value |
0CPMTOSTPBU |
Planned Stock / BUn |
0RTMTOSTPPV |
Last Total Planned Stock in Cost Value |
0CPTOTSTOBU |
Last Total Valuated Stock / BUn |
0CPMTOSTPV |
Last Total Valuated Stock / Cost Value |
0RT_C21_CK014 |
Average Monthly Sales (Cost) |
0RT_C21_CK014 |
Average Monthly Sales (Cost) |
0RT_C21_CK020 |
Average Monthly Sales (Qty) |
0RT_C21_CK017 |
Average Planned Stock (Cost) |
0RT_C21_CK022 |
Average Planned Stock (Qty) |
0RT_C21_CK018 |
Average Actual Stock (Cost) |
0RT_C21_CK023 |
Average Actual Stock (Qty) |
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% |