This query displays the trend of net markdown sales for selected material groups and selected stores over a specified time period. It also provides the trend of net markdown sales during the same time period for the previous year. Users can drill down to view the results by year, month, week, day, or hour.
The query can be filtered by data status.
Users can select the currency in which to display the data in order to more easily compare the results, for example, for stores located in different countries.
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Characteristic | Material |
0RPM_MAT |
Restricted by variable 0P_RPM_MAT |
Characteristic | Cust. No. of Plant |
0RPM_RSI |
Restricted by variable 0P_RPM_STORES |
Characteristic | Task Canceled |
0RPM_CANC |
Restricted by variable 0P_RPM_TASK_CANCELED |
Characteristic | Credit/Debit Indicat |
0RPM_TRD |
Excluding: X |
Characteristic | Business Transaction |
0RPM_BTY |
Including: 1 |
Characteristic | Classification of Sa |
0PM_RIC |
Restricted by variable 0P_RPM_CAT_MULTI |
Characteristic | Classification of Sa |
0RPM_RISC |
Restricted by variable 0P_RPM_SCAT |
Characteristic | Data Status |
0RPM_DAT |
Restricted by variable 0P_RPM_DATA_STATUS |
Characteristic | Material Group |
0RPM_MATGRP |
Restricted by variable 0P_RPM_MATGRP |
Characteristic | Markdown Sales Trans |
0RPM_MARK |
1 |
Characteristic | Document Currency |
0DOC_CURRCY |
Restricted by variable 0P_RPM_CURRCY |
Object Type | Name | Technical Name |
---|---|---|
Characteristic | Cust. No. of Plant |
0RPM_RSI |
Characteristic | Material Group |
0RPM_MATGRP |
Characteristic | Task Canceled |
0RPM_CANC |
Characteristic | Data Status |
0RPM_DAT |
Characteristic | Material |
0RPM_MAT |
Characteristic | Retail Type Code |
0RPM_RTC |
Characteristic | Trans. Type Code |
0RPM_TTC |
Characteristic | Calendar Day |
0RPM_DAY |
Characteristic | Calendar Month |
0RPM_MTH |
Characteristic | Calendar Week |
0RPM_WEK |
Characteristic | Calendar Year |
0RPM_YER |
Characteristic | Hour |
0RPM_HOR |
Object Type | Name | Technical Name |
---|---|---|
Variable | POSDM Sales Analysis Stores List |
0P_RPM_STORES |
Variable | POSDM Sales Analysis Material Group List |
0P_RPM_MATGRP |
Variable | POSDM Sales Analysis Material |
0P_RPM_MAT |
Variable | POSDM Sales Analysis Date Range 1 |
0I_RPM_DATE1 |
Variable | POSDM Sales Analysis Time Range 1 |
0I_RPM_TIME1 |
Variable | POSDM Sales Analysis Data Status |
0P_RPM_DATA_STATUS |
Variable | POSDM Sales Analysis Sub-Category |
0P_RPM_SCAT |
Variable | POSDM Sales Analysis Category |
0P_RPM_CAT_MULTI |
Variable | POSDM Sales Analysis Task Canceled |
0P_RPM_TASK_CANCELED |
Variable | POSDM Sales Analysis Currency |
0P_RPM_CURRCY |
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|
Object Type | Name | Technical Name | Value Restriction / Calculation |
---|---|---|---|
Key Figure | Net Markdown Sales Range 1 |
SEL_RPM_RK016 |
Net Markdown Sales for a date range specified using variable 0I_RPM_DATE1 and time range specified using variable 0I_RPM_TIME1 (Restricted Key Figure). Net Markdown Sales are calculated as follows: Net Markdown Sales = Normal Sales (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID) applied to items with a promotion ID, a distributed discount or a discount. |