Location Inventory Scorecard
Technical
Name:0RMP_MC11_Q0003
Use
This query
shows the inventory-related key figures for a regional analysis. This allows
you to evaluate seasonal trends within regions or locations. For more detailed
data, you can drill down into locations and posting periods, which is the
smallest time entity in the InfoCube.
Filter
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0FISCVARNT |
Fiscal
Year Variant |
|
0SALESORG |
Sales
Organization |
|
0DISTR_CHAN |
Distribution
Channel |
|
0REQUID |
Request
ID |
Free Characteristics
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0COUNTRY |
Country |
|
0REGION |
Region |
|
0COUNTY_CDE |
County
Code |
|
0FISCPER |
Posting
period |
Variables Used
|
Variable |
Description
|
|
0P_CTRY |
Country
code |
|
0P_REGN |
Region |
|
0P_GJVM |
Fiscal
Year Variant |
|
0P_SAORG |
Sales
Organization |
|
0P_DCHAN |
Distribution
Channel |
|
0S_RQMRC |
Request
ID |
|
0P_GJAHR |
Fiscal
year |
|
0P_VERS3 |
Version |
|
0P_VERS4 |
Version |
Rows
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0PLANT |
Location |
Columns
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0RTBAINSASV |
Sales at
Retail |
|
0RTBAINSAPV |
Sales at
Cost |
|
0RMP_MC11_CK008 |
Ending
Inventory at Retail |
|
0RTGRPDVSV |
Goods
Receipts at Retail |
|
0RMP_MC11_CK003
|
Gross
Margin % (Retail – Cost / Retail x 100) |
|
0RMP_MC11_CK009
|
Inventory
Turnover (Sales at Retail / Average Inventory) |
|
0RMP_MC11_CK010
|
Range of
Coverage (Inventory / Average Sales at Retail) |
|
0RMP_MC11_CK011
|
GMROI (Gross
Margin % x Inventory Turnover) |
|
0RTINCOINSV |
Shrinkage |
|
0P_GJAHR and
0P_VERS3 |
Plan
Version Restriction:
0P_VERS3 (Plan Version ) and 0P_GJAHR (Fiscal Year) |
|
0P_GJAHR and
0P_VERS4 |
Actuals Restriction:
0P_GJAHR (Fiscal Year = Current Year) and 0P_VERS4 (Actuals Version = 0) |
|
0P_GJAHR and
0P_VERS4 |
Actuals
Last Year Restriction:
0P_GJAHR –1 (Fiscal Year = Last Year) and 0P_VERS4 (Actuals Version = 0) |
|
Actuals /
Planned |
Deviation
% |