Average Sale per Transaction Summary 
Query: 0RPM_VP08_Q0080
This query displays the average sale per transaction summary of selected material groups from selected stores over specified time periods. For the selected stores and material groups, the query also provides the variance of average sale per transaction 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.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Material |
0RPM_MAT |
Restricted by variable 0P_RPM_MAT |
| Cust. No. of Plant |
0RPM_RSI |
Restricted by variable 0P_RPM_STORES |
| Task Canceled |
0RPM_CANC |
Restricted by variable 0P_RPM_TASK_CANCELED |
| Credit/Debit Indicat |
0RPM_TRD |
Excluding: X |
| Business Transaction |
0RPM_BTY |
Including: 1 |
| Classification of Sa |
0RPM_RIC |
Restricted by variable 0P_RPM_CAT_MULTI |
| Classification of Sa |
0RPM_RISC |
Restricted by variable 0P_RPM_SCAT |
| Data Status |
0RPM_DAT |
Restricted by variable 0P_RPM_DATA_STATUS |
| Material Group |
0RPM_MATGRP |
Restricted by variable 0P_RPM_MATGRP |
| Document Currency |
0DOC_CURRCY |
Restricted by variable 0P_RPM_CURRCY |
| Item ID |
0RPM_ITI |
Restricted by variable 0P_RPM_ITEMID |
| Item Qualifier |
0RPM_IQU |
Restricted by variable 0P_RPM_IQU |
CharacteristicObject Type | Name | Technical Name |
|---|---|---|
| Cust. No. of Plant |
0RPM_RSI |
| Material Group |
0RPM_MATGRP |
| Task Canceled |
0RPM_CANC |
| Data Status |
0RPM_DAT |
| Material |
0RPM_MAT |
| Trans. Type Code |
0RPM_TTC |
| Retail Type Code |
0RPM_RTC |
| Item ID |
0RPM_ITI |
| Item Qualifier |
0RPM_IQU |
Object Type | Name | Technical Name |
|---|---|---|
| POSDM Sales Analysis Stores List |
0P_RPM_STORES |
| POSDM Sales Analysis Material Group List |
0P_RPM_MATGRP |
| POSDM Sales Analysis Material |
0P_RPM_MAT |
| POSDM Sales Analysis Date Range 1 |
0I_RPM_DATE1 |
| POSDM Sales Analysis Date Range 2 |
0I_RPM_DATE2 |
| POSDM Sales Analysis Time Range 1 |
0I_RPM_TIME1 |
| POSDM Sales Analysis Time Range 2 |
0I_RPM_TIME2 |
| POSDM Sales Analysis Currency |
0P_RPM_CURRCY |
| POSDM Sales Analysis Data Status |
0P_RPM_DATA_STATUS |
| POSDM Sales Analysis Sub-Category |
0P_RPM_SCAT |
| POSDM Sales Analysis Category |
0P_RPM_CAT_MULTI |
| POSDM Sales Analysis Task Canceled |
0P_RPM_TASK_CANCELED |
| Item ID |
0P_RPM_ITEMID |
| Item Qualifier |
0P_RPM_IQU |
VariableObject Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Transaction Type Code |
0RPM_TTC |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Counter Range 1 |
SEL_RPM_RK011 |
Average Sale per Transaction for a date range specified using variable 0I_RPM_DATE1 and time range specified using variable 0I_RPM_TIME1 (Restricted Key Figure). The Average Sale per Transaction is calculated as follows: Average Sale per Transaction = [Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID)] / Number of Transactions (CKF_RPM_CKO21). |
| Counter Range 2 |
SEL_RPM_RK012 |
Average Sale per Transaction for a date range specified using variable 0I_RPM_DATE2 and time range specified using variable 0I_RPM_TIME2 (Restricted Key Figure). The Average Sale per Transaction is calculated as follows: Average Sale per Transaction = [Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID)] / Number of Transactions (CKF_RPM_CKO21). |
| Average Variance |
CKF_RPM_CK014 |
Variance between Average Sale per Transaction Range 1 and Average sale per transaction Range 2 (Calculated Key Figure). The Average Sale per Transaction is calculated as follows: Average Sale per Transaction = [Normal Sales Value (0RPM_NSA) — Tax Included (0RPM_TXI) — Distributed Included Transaction Tax (0RPM_DITXI) — Distributed Discount (0RPM_DID)] / Number of Transactions (CKF_RPM_CKO21). |
Key Figure