Cost Stock Ledger - Cumulated Period Report: Merchandiser/Organizational Hierarchy 
Query: 0RSL_MP01_Q0010
This query allows you to evaluate stock changes by period based on the valuation of acquisition costs. All stock-based key figures are displayed in a matrix with week, month, quarter, and fiscal year columns. After calling the query, you have to enter a business variant on the variable screen. You can evaluate the data at different material group hierarchy levels and perform drill downs and graphical analyses.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Fiscal Year Variant | 0FISCVARNT | Constraints: 0P_GJVM (fiscal year variant) |
Object Type | Name | Technical Name |
|---|---|---|
| Article | 0MATERIAL |
| Material Group | 0MATL_GROUP |
| Material Group Hierarchy Level 1 | 0RPA_WGH1 |
| Material Group Hierarchy Level 2 | 0RPA_WGH2 |
| Material Group Hierarchy Level 3 | 0RPA_WGH3 |
| Material Group Hierarchy Level 4 | 0RPA_WGH4 |
| Site | 0PLANT |
| Sales Organization | 0SALESORG |
| Distribution Channel | 0DISTR_CHAN |
| Retail Location | 0RT_LOCATIO |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Cost | 0RSL_MP01_RSLPV | |
| Ending Inventory at Cost | 0RSLINBINVPV | |
| Net Goods Receipt at Cost | 0RSLNTREPV | |
| Net Transfers at Cost | 0RSLNETRPV | |
| Available for Sale at Cost | 0RSLAINVPV | |
| Net Sales at Retail | 0RSLNETSLSV | |
| Net Sales at Cost | 0RSLNETSLPV | |
| Stock Adjustment Due to Inventory at Cost | 0RSLINCOPV | |
| Manual Adjustment at Cost | 0RSLINTCOPV | |
| Adjustment Due to Shrinkage at Cost | 0RSLINSHGPV | |
| Ending Inventory at Cost | 0RSLEINVPV | |
| Quantity | 0RSL_MP01_RSLQUABU | |
| Beginning Inventory in Base UoM | 0RSLINBINVBU | |
| Net Goods Receipt in Base UoM | 0RSLNTREBU | |
| Net Transfers in Base UoM | 0RSLNETRBU | |
| Available for Sale in Base UoM | 0RSLAINVBU | |
| Net Sales in Base UoM | 0RSLNETSLBU | |
| Adjustment Due to Physical Inventory in Base UoM | 0RSLINCOBU | |
| Adjustment Due to Shrinkage in Base UoM | 0RSLINSHGBU | |
| Ending Inventory (BUoM) | 0RSLEINVBU | |
| Ratio | 0RSL_MP01_RATIO | |
| Average Ending Inventory at Cost/Base UoM | 0RSL_C01_CK_RSLAUINVPV | |
| Cost of Goods Sold | 0RSL_C02_CK_RSLCOGS | |
| Gross Margin | 0RSL_C02_CK_RSLGMSV | |
| Gross Margin in Percent | 0RSL_C02_CK_RSLGMPSV | |
| Gross Margin by Cost | 0RSL_C02_CK_RSLGMPV | |
| Cumulative Margin by Retail in Percent | 0RSL_MP01_CK_RSLCMMRGP | |
| Inventory Turnover by Cost | 0RSL_MP01_CK_RSLINVTOPV | |
| GMROI in Percent | 0RSL_MP01_CK_RSLGMROI | |
| Sell Through in Percent | 0RSL_MP01_CK_RSLROTSPESA | |
| Range of Coverage (in Percent) | 0RSL_MP01_CK_RSLREACHSA | |
| Returns to Vendor in Percent of Goods Receipt | 0RSL_C02_CK_RSLRTVREC | |
| Returns to Vendor in Percent of Sales | 0RSL_C02_CK_RSLRTVSA | |
| Returns to Customer in Percent of Sales | 0RSL_C02_CK_RSLRECUSSA | |
| Stock Adjustment Due to Inventory in Percent of Sales | 0RSL_C01_CK_RSLINCOSA | |
| Manual Stock Adjustment in Percent of Sales | 0RSL_C02_CK_RSLINCOOSA | |
| Stock Adjustment Due to Shrinkage in Percent of Sales | 0RSL_C01_CK_RSLINSRGSA |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Virtual Hierarchy for Fiscal Year Variant (Week) | 0H_RTFVW | 0N_RTFPW (current week of the fiscal year) |
| Virtual Hierarchy for Fiscal Year Variant (Month) | 0H_RTFVM | 0N_RTFPM (current month of the fiscal year) |
| Virtual Hierarchy for Fiscal Year Variant (Quarter or Season) | 0H_RFVQ | 0N_RFPQ (current quarter of the fiscal year) |
| Current Fiscal Year (SAP Exit) | 0FYEAR |