This query is used to display sales summary (gross, net, discounts and net returns).
This query displays the summary of gross sales, net sales, discounts and net returns of selected material groups for selected stores over specified time periods. For the selected stores and material groups, the query also provides the variance of gross sale, net sales, discounts and net returns during the specified time periods. Users can drill down to view results by store and/or material group.
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.
The query can be filtered by data status.
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 |
0RPM_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 | 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 | Material |
0RPM_MAT |
Characteristic | Trans. Type Code |
0RPM_TTC |
Characteristic | Retail Type Code |
0RPM_RTC |
Object Type | Name | Technical Name |
---|---|---|
Variable | POSDM Sales Analysis Stores List |
0P_RPM_STORES |
Variable | POSDM Sales Analysis Material Group |
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 Date Range 2 |
0I_RPM_DATE2 |
Variable | POSDM Sales Analysis Time Range 1 |
0I_RPM_TIME1 |
Variable | POSDM Sales Analysis Time Range 2 |
0I_RPM_TIME2 |
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 | Gross Sales Range 1 |
SEL_RPM_RK009 |
Gross Sales for a date range specified using variable 0I_RPM_DATE1 and time range specified using variable 0I_RPM_TIME1 (Restricted Key Figure). Gross Sales are calculated as follows: Gross Sales = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) + Distributed Discount (0RPM_DID) + Discount Value (0RPM_REA). |
Key Figure | Gross Sales Range 2 |
SEL_RPM_RK010 |
Gross Sales for a date range specified using variable 0I_RPM_DATE2 and time range specified using variable 0I_RPM_TIME2 (Restricted Key Figure). Gross Sales are calculated as follows: Gross Sales = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) + Distributed Discount (0RPM_DID) + Discount Value (0RPM_REA). |
Key Figure | Gross Sales Variance |
CKF_RPM_CK013 |
Variance between Gross Sales Range 1 and Gross Sales Range 2 (Calculated Key Figure). Gross Sales are calculated as follows: Gross Sales = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) + Distributed Discount (0RPM_DID) + Discount Value (0RPM_REA). |
Key Figure | Net Sales Range 1 |
SEL_RPM_RK005 |
Net Sales for a date range specified using variable 0I_RPM_DATE1 and time range specified using variable 0I_RPM_TIME1 (Restricted Key Figure). Net Sales are calculated as follows: Net Sales = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID). |
Key Figure | Net Sales Range 2 |
SEL_RPM_RK006 |
Net Sales for a date range specified using variable 0I_RPM_DATE2 and time range specified using variable 0I_RPM_TIME2 (Restricted Key Figure). Net Sales are calculated as follows: Net Sales = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID). |
Key Figure | Net Sales Variance |
CKF_RPM_CK005 |
Variance between Net Sales Range 1 and Net Sales Range 2 (Calculated Key Figure). Net Sales are calculated as follows: Net Sales = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID). |
Key Figure | Discounts Range 1 |
SEL_RPM_RK013 |
Discounts for a date range specified using variable 0I_RPM_DATE1 and time range specified using variable 0I_RPM_TIME1 (Restricted Key Figure). Discounts are calculated as follows: Discounts = Distributed Discount + (ORPM_DID) Discount Value (0RPM_REA). |
Key Figure | Discounts Range 2 |
SEL_RPM_RK015 |
Discounts for a date range specified using variable 0I_RPM_DATE2 and time range specified using variable 0I_RPM_TIME2 (Restricted Key Figure). Discounts are calculated as follows: Discounts = Distributed Discount + (ORPM_DID) Discount Value (0RPM_REA). |
Key Figure | Discounts Variance |
CKF_RPM_CK018 |
Variance between Discounts Range 1 and Discounts Range 2 (Calculated Key Figure). Discounts are calculated as follows: Discounts = Distributed Discount + (ORPM_DID) Discount Value (0RPM_REA). |
Key Figure | Net Returns Range 1 |
SEL_RPM_RK018 |
Net Returns for a date range specified using variable 0I_RPM_DATE1 and time range specified using variable 0I_RPM_TIME1 (Restricted Key Figure). Net Returns are calculated as follows: Net Returns = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID). |
Key Figure | Net Returns Range 2 |
SEL_RPM_RK019 |
Net Returns for a date range specified using variable 0I_RPM_DATE2 and time range specified using variable 0I_RPM_TIME2 (Restricted Key Figure). Net Returns are calculated as follows: Net Returns = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID). |
Key Figure | Net Returns Variance |
CKF_RPM_CK019 |
Variance between Net Returns Range 1 and Net Returns Range 2 (Calculated Key Figure). Net Returns are calculated as follows: Net Returns = Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID). |