ERMA Stock Ledger - Cumulated Period Report: Merchandiser/Organizational Hierarchy 
Query: 0RSL_MP01_Q0003
This query allows you to perform a period-based analysis of changes in stock using the Extended Retail Method of Accounting. 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 |
|---|---|---|---|
| Retail | ||
| Beginning Inventory at Retail | 0RSLINBINVSV | |
| Net Goods Receipt at Retail | 0RSLNTRESV | |
| Net Transfers at Retail | 0RSLNETRSV | |
| Markup | 0RTSPREPSV | |
| Available for Sale at Retail | 0RSLAINVSV | |
| Net Sales in Sales Value | 0RSLNETSLSV | |
| Markdown | 0RTSPRENSV | |
| Local Markdown at Retail | 0RSLSRENSV | |
| Promotional Markdown at Retail | 0RSLSPRRNSV | |
| Stock Adjustment Due to Inventory in Sales Value | 0RSLINCOSV | |
| Adjustment Due to Shrinkage at Retail | 0RSLINSHGSV | 0RSLACCOUNT=61 |
| Ending Inventory at Retail | 0RSLEINVSV | |
| Cost | ||
| Ending Inventory at Cost | 0RSLINBINVPV | |
| Net Goods Receipt at Cost | 0RSLNTREPV | |
| Net Transfers at Cost | 0RSLNETRPV | |
| Available for Sale at Cost | 0RSLAINVPV | |
| Net Sales in Purchase Value | 0RSLNETSLPV | |
| Markdown | 0RTSPRENPV | |
| Local Markdown at Cost | 0RSLSRENPV | |
| Promotional Markdown at Cost | 0RSLSPRRNPV | |
| 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 | ||
| 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 | |
| Local Markdown in Base UoM | 0RSLSRENBU | |
| Adjustment Due to Physical Inventory in Base UoM | 0RSLINCOBU | |
| Manual Adjustment in Base UoM | 0RSLINTCOBU | |
| Adjustment Due to Shrinkage in Base UoM | 0RSLINSHGBU | |
| Ending Inventory (BUoM) | 0RSLEINVBU | |
| Ratio | ||
| Average Ending Inventory at Retail/Base UoM | 0RSL_C01_CK_RSLAUINVSV | |
| 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 | |
| Gross Margin by Cost in Percent | 0RSL_C02_CK_RSLGMPPV | |
| Stock Margin, Previous Period by Retail | 0RSL_C01_CK_RSLBMRG | |
| Stock Margin, Previous Period by Retail in Percent | 0RSL_C01_CK_RSLBMRGP | |
| Stock Margin, Previous Period by Cost | 0RSL_C01_CK_RSLBPREP | |
| Stock Margin, Previous Period by Cost in Percent | 0RSL_C01_CK_RSLBREPP | |
| Goods Receipt Margin by Retail | 0RSL_C01_CK_RSLIMRG | |
| Goods Receipt Margin by Retail in Percent | 0RSL_C01_CK_RSLIMRGP | |
| Goods Receipt Margin by Cost | 0RSL_C01_CK_RSLIPREP | |
| Goods Receipt Margin by Cost in Percent | 0RSL_C01_CK_RSLIREPP | |
| Cumulative Margin by Retail | 0RSL_MP01_CK_RSLCMMRG | |
| Cumulative Margin by Retail in Percent | 0RSL_MP01_CK_RSLCMMRGP | |
| Cumulative Margin by Cost | 0RSL_MP01_CK_RSLCMPREP | |
| Cumulative Margin by Cost in Percent | 0RSL_MP01_CK_RSLCMPREPP | |
| Stock Margin by Retail | 0RSL_C01_CK_RSLCUMRG | |
| Stock Margin by Retail in Percent | 0RSL_C01_CK_RSLCUMRGP | |
| Stock Margin by Cost | 0RSL_C01_CK_RSLCUPREP | |
| Stock Margin by Cost in Percent | 0RSL_C01_CK_RSLCUPREPP | |
| Inventory Turnover by Retail | 0RSL_MP01_CK_RSLINVTOSV | |
| Inventory Turnover at 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 | |
| Permanent Markdowns in Percent of Sales | 0RSL_C02_CK_RSLPRENSA | |
| Local Markdowns in Percent of Sales | 0RSL_C02_CK_RSLRENSA | |
| Promotion Markdowns in Percent of Sales | 0RSL_C02_CK_RSLPRRNSA | |
| 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 |