Location Scorecard
Technical
Name: 0RMP_MC11_Q0002
Use
This query is
a plan/actual comparison and shows the sales-related key figures for a regional
analysis. This allows you to evaluate 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. There is also a level for
comparing locations.
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 |
|
0FISCPER3 |
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 |
|
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) |
|
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
% |