Cost Stock Ledger - Period Report: Merchandiser 
Query: 0RSL_MP01_Q0007
This query allows you to evaluate stock changes (by periods) based on the valuation of acquisition costs. All stock-based key figures are displayed in the column. The system displays the ratios in the rows. After calling the query, you have to enter a business variant and posting period 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/Period | 0FISCPER | Constraints: 0P_FPER (period/fiscal year) |
| Fiscal year variant | 0FISCVARNT | Constraints: 0P_GJVM (fiscal year variant) |
Object Type | Name | Technical Name |
|---|---|---|
| Site | 0PLANT |
| Sales Organization | 0SALESORG |
| Distribution Channel | 0DISTR_CHAN |
| Retail Location | 0RT_LOCATIO |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| 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 |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Ending Inventory at Cost | 0RSLINBINVPV | |
| Beginning Inventory in Base UoM | 0RSLINBINVBU | |
| Net Goods Receipt at Cost | 0RSLNTREPV | |
| Net Goods Receipt in Base UoM | 0RSLNTREBU | |
| Net Transfers at Cost | 0RSLNETRPV | |
| Net Transfers in Base UoM | 0RSLNETRBU | |
| Available for Sale at Cost | 0RSLAINVPV | |
| Available for Sale in Base UoM | 0RSLAINVBU | |
| Net Sales in Sales Value | 0RSLNETSLSV | |
| Net Sales in Base UoM | 0RSLNETSLBU | |
| Stock Adjustment Due to Inventory at Cost | 0RSLINCOPV | |
| Adjustment Due to Physical Inventory in Base UoM | 0RSLINCOBU | |
| Manual Adjustment at Cost | 0RSLINTCOPV | |
| Manual Adjustment in Base UoM | 0RSLINTCOBU | |
| Adjustment Due to Shrinkage at Cost | 0RSLINSHGPV | |
| Adjustment Due to Shrinkage in Base UoM | 0RSLINSHGBU | |
| Ending Inventory at Cost | 0RSLEINVPV | |
| Ending Inventory (BUoM) | 0RSLEINVBU | |
| 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 | |
| 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 | |
| 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 |