Sales Summary Report 
Query: 0LPA_MP01_Q0012
This summary report provides an overview of the sales figures for transactions. You can view these details at Company, Region, District, Store, Cashier, and Day levels. This allows you to compare sales figures based on different criteria, and to go through the most granular level of reporting.
Structure
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Company |
0RT_LOCATIO__0COMP_CODE |
— |
| Region |
0RT_LOCATIO__0REGION |
— |
| District |
0RT_LOCATIO__0SALES_DIST |
— |
| Store |
0RT_LOCATIO |
— |
| Cashier |
0RPA_OID |
— |
| Date |
0CALDAY |
— |
| Sales Item Category |
0RPA_RIC |
— |
| Sales Item Subcategory |
0RPA_RISC |
— |
CharacteristicObject Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Company |
0RT_LOCATIO__0COMP_CODE |
— |
| Region |
0RT_LOCATIO__0REGION |
— |
| Sales District |
0RT_LOCATIO__0SALES_DIST |
— |
| Store |
0RT_LOCATIO |
— |
| Cashier |
0RPA_OID |
— |
| Date |
0CALDAY |
— |
Object Type | Name | Technical Name | Value Restriction / Calculation |
|---|---|---|---|
| Amount |
0RPA_SAT |
— |
| Count |
0RPA_CNR |
— |
| Sales – Retail Value/No. of POS Receipts |
- |
Amount restricted by category A and subcategory B |
Key FigureName | Technical Name | Description |
|---|---|---|
Sales Summary Report – Company View |
0LPA_MP01_Q0012_V01 |
|
Sales Summary Report – Region View |
0LPA_MP01_Q0012_V02 |
|
Sales Summary Report – District View |
0LPA_MP01_Q0012_V03 |
|
Sales Summary Report – Store View |
0LPA_MP01_Q0012_V04 |
|
Sales Summary Report – Cashier View |
0LPA_MP01_Q0012_V05 |
|
Sales Summary Report – Day View |
0LPA_MP01_Q0012_V06 |