Location Productivity Scorecard
Technical
Name: 0RMP_MC11_Q0004
Use
This query is
used to evaluate sales efficiency for markdowns. It allows you to evaluate
seasonal trends and visualize price changes on a seasonal basis.
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_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) |
|
0RMP_MC11_CK013 |
Calculated
Sales |
|
0RTBAINSASV |
Sales at
Retail |
|
0RTBAINSAPV |
Sales at
Cost |
|
0RMP_MC11_CK002
|
Gross
Margin (Retail – Cost) |
|
0RTSPRENSV |
Markdown |
|
0RTINSADIST |
Price
Reduction |
|
0RTINCOINSV |
Shrinkage |
|
Markdown
/ Sales at Retail x 100 |
Markdown
Contribution to Sales |
|
Price
Reduction / Sales at Retail x 100 |
Price
Reduction Contribution to Sales |
|
Shrinkage
/ Sales at Retail x 100 |
Shrinkage
Contribution to Sales |
|
0P_GJAHR and
0P_VERS3 |
Plan
Version Restriction:
0P_VERS3 (Plan Version ) and 0P_GJAHR (Fiscal Year (Fiscal Year) |
|
0P_GJAHR and
0P_VERS4 |
Actuals Restriction:
0P_GJAHR (Fiscal Year = Current Year) and 0P_VERS4 (Actuals Version = 0) |
|
0P_GJAHR
–1 (and 0P_VERS4 |
Actuals
Last Year Restriction:
0P_GJAHR –1 (Fiscal Year = Last Year) and 0P_VERS4 (Actuals Version = 0) |
|
Actuals /
Planned |
Deviation
% |