Sales Scorecard
Technical
Name: 0RMP_MC01_Q0002
Use
This query is
a plan/actual comparison and shows all sales-related key figures at one glance.
You can evaluate several levels of data, drilling down from categories to
subcategories and segments. In addition, you can evaluate seasonal trends
within categories and segments.
Filter
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0FISCVARNT |
Fiscal
Year Variant |
|
0SALESORG |
Sales
Organization |
|
0DISTR_CHAN |
Distribution
Channel |
|
0CM_0REQUID |
Request
ID |
Free Characteristics
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0CM_MCATDIV |
Division |
|
0RT_SEASON |
Season |
|
0RT_SEASYR |
Season
Year |
|
0RT_SKUROLL |
SKU
Rollout |
|
0CM_CDT1 |
Category |
|
0CM_CDT2 |
Subcategory |
|
0FISCPER3 |
Posting Period |
Variables Used
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0P_GJVM |
Fiscal
Year Variant |
|
0P_SAORG |
Sales
Organization |
|
0P_DCHAN |
Distribution
Channel |
|
0S_RQMRC |
Request
ID |
|
0P_GJAHRGJAHR |
Fiscal
year |
|
0P_VERS4 |
Version |
Rows
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0CM_CDT3 |
Segment |
|
0RMP_MC01_CK004
|
Average
Sales Price (Retail / Quantity BUOM) |
Columns
|
InfoObject |
Description
of the InfoObject (and restriction or calculation formula) |
|
0RTBAINSASV |
Sales at
Retail |
|
0CPBAINSAPV |
Sales at
Cost |
|
0CPBAINSABU |
Sales
(Base Unit of Measure) |
|
0RMP_MC01_CK002
|
Gross Margin
(Retail – Cost) |
|
0RMP_MC01_CK003
|
Gross
Margin % (Retail – Cost / Retail x 100) |
|
0RMP_MC01_CK004
|
Average
Retail (Retail / Quantity BUOM) |
|
% of
Total Sales at Retail |
Sales
Contribution |
|
0P_GJAHR0P_GJAHR
and 0P_VERS3 |
Plan
Version. Restriction:
0P_VERS3 (Plan Version ) and 0P_GJAHR0P_GJAHR (Fiscal Year ) |
|
0P_GJAHR0P_GJAHR
–1 and 0P_VERS4 |
Actuals
Last Year. Restriction:
0P_GJAHR0P_GJAHR –1 (Fiscal Year = Last Year) and 0P_VERS4 (Actuals Version =
0) |
|
0P_GJAHR0P_GJAHR
–1 and 0P_VERS4 |
Actuals. Restriction:
0P_GJAHR0P_GJAHR (Fiscal Year = Current Year) and 0P_VERS4 (Actuals Version =
0) |
|
Actuals /
Planned |
Deviation
% |