Regional Analysis
Technical
Name: 0RMP_MC11_Q0001
Use
This query
shows the key performance indicators for a regional analysis. Initially, all
key figures are displayed in the columns, with various countries in the rows.
This is the raw view of the data and a starting point for drilldowns and
graphical analyses. For more detailed data, you can drill down into locations,
categories, 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 |
Free Characteristics
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0REGION |
Region |
|
0COUNTY_CDE |
County
Code |
|
0FISCPER3 |
Posting
period |
|
0PLANT |
Location |
Variables Used
|
Variable |
Description
|
|
0P_GJVM |
Fiscal
Year Variant |
|
0P_SAORG |
Sales
Organization |
|
0P_DCHAN |
Distribution
Channel |
|
0P_GJAHR |
Fiscal
year |
|
0P_VERS4 |
Version |
Rows
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0COUNTRY |
Country |
|
0RTBAINSASV |
Sales at
Retail |
|
0RMP_MC11_CK001 |
Comparable
Sales at Retail |
|
0RTBAINSAPV |
Sales at
Cost |
|
0CPBAINSABU |
Sales
(Base Unit of Measure) |
|
0RMP_MC11_CK012
|
Average
Price (Retail / Quantity BUOM) |
|
0RMP_MC11_CK002
|
Gross
Margin (Retail – Cost) |
|
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) |
Columns
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0RTBAINSASV |
Sales at
Retail |
|
0RTBAINSAPV |
Sales at
Cost |
|
0CPBAINSABU |
Sales
(Base Unit of Measure) |
|
0RMP_MC11_CK012
|
Average
Retail Price (Retail / Quantity BUOM) |
|
0RMP_MC11_CK002
|
Gross
Margin (Retail – Cost) |
|
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) |
|
0P_GJAHR and
0P_VERS4 |
Actuals Restriction:
0P_VERS4 (Actuals Version = 0) and 0P_GJAHR (Fiscal Year = 0P_GJAHR) |
|
0P_GJAHR and
0P_VERS4 |
Actuals Restriction:
0P_GJAHR (Fiscal Year = 0PGJAHR - 1) and 0P_VERS4 (Actuals Version = 0) |
|
Actuals
TY / Actuals LY |
Deviation
% |