Table/Structure Field list used by SAP ABAP Program RMCSWARK (Copy Reference: Shopping Basket Analysis)
SAP ABAP Program 
RMCSWARK (Copy Reference: Shopping Basket Analysis) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Table/Structure Field |
EMARA - MATKL | Material Group | |
| 2 | Table/Structure Field |
EMARA - MTART | Material type | |
| 3 | Table/Structure Field |
EMARA - PLGTP | Price band category | |
| 4 | Table/Structure Field |
EMARA - SAISJ | Season Year | |
| 5 | Table/Structure Field |
EMARA - SAISO | Season Category | |
| 6 | Table/Structure Field |
EMARA - SATNR | Cross-Plant Configurable Material | |
| 7 | Table/Structure Field |
EMARA - ATTYP | Material Category | |
| 8 | Table/Structure Field |
MAKT - MAKTX | Material description | |
| 9 | Table/Structure Field |
MAKT - MATNR | Material Number | |
| 10 | Table/Structure Field |
MAKT - SPRAS | Language Key | |
| 11 | Table/Structure Field |
MARA - SATNR | Cross-Plant Configurable Material | |
| 12 | Table/Structure Field |
MARA - SAISO | Season Category | |
| 13 | Table/Structure Field |
MARA - SAISJ | Season Year | |
| 14 | Table/Structure Field |
MARA - PLGTP | Price band category | |
| 15 | Table/Structure Field |
MARA - MATNR | Material Number | |
| 16 | Table/Structure Field |
MARA - MATKL | Material Group | |
| 17 | Table/Structure Field |
MARA - MTART | Material type | |
| 18 | Table/Structure Field |
MARA - ATTYP | Material Category | |
| 19 | Table/Structure Field |
MCWTIMEW - JAHR | Year | |
| 20 | Table/Structure Field |
MCWTIMEW - KALWOC | Calendar week | |
| 21 | Table/Structure Field |
MCWTIMEW - KMONAT | Calendar month | |
| 22 | Table/Structure Field |
MCWTIMEW - QUARTAL | Quarter | |
| 23 | Table/Structure Field |
MCWTIMEW - WOCHTG | Weekday | |
| 24 | Table/Structure Field |
S117 - MTART | Material type | |
| 25 | Table/Structure Field |
S117 - PLGTP | Price band category | |
| 26 | Table/Structure Field |
S117 - SAISJ | Season Year | |
| 27 | Table/Structure Field |
S117 - SAISO | Season Category | |
| 28 | Table/Structure Field |
S117 - SATNR | Cross-Plant Configurable Material | |
| 29 | Table/Structure Field |
S117 - SPTAG | Period to analyze - current date | |
| 30 | Table/Structure Field |
S117 - TGZTKL | Time of day class | |
| 31 | Table/Structure Field |
S117 - UHZEIT | Time sale was entered | |
| 32 | Table/Structure Field |
S117 - UMSATZ | Sales POS | |
| 33 | Table/Structure Field |
S117 - VKSTD | Hour of sale | |
| 34 | Table/Structure Field |
S117 - WMINR | Product catalog number | |
| 35 | Table/Structure Field |
S117 - MATKL | Material Group | |
| 36 | Table/Structure Field |
S117 - AKTNR | Promotion | |
| 37 | Table/Structure Field |
S117 - MATNR | Material Number | |
| 38 | Table/Structure Field |
S117 - AFLAG | Promotion indicator | |
| 39 | Table/Structure Field |
S117 - AKTHE | Promotion theme | |
| 40 | Table/Structure Field |
S117 - AKTYP | Promotion Category | |
| 41 | Table/Structure Field |
S117 - ANZAAR | Number of promotion items | |
| 42 | Table/Structure Field |
S117 - ANZPOS | Number of transaction items (till receipts) | |
| 43 | Table/Structure Field |
S117 - ATTYP | Material Category | |
| 44 | Table/Structure Field |
S117 - BONNR | Transaction number (till receipt) | |
| 45 | Table/Structure Field |
S117 - CCNUM | Payment cards: Card number | |
| 46 | Table/Structure Field |
S117 - MAKTX | Material description | |
| 47 | Table/Structure Field |
S119 - ANZWGR | Number of material groups in transaction (till receipt) | |
| 48 | Table/Structure Field |
S119 - WERTUM | Sales value POS (exact value) | |
| 49 | Table/Structure Field |
S119 - UMSATZ | Sales POS | |
| 50 | Table/Structure Field |
S119 - KUNDK | Customer ID | |
| 51 | Table/Structure Field |
S119 - CCNUM | Payment cards: Card number | |
| 52 | Table/Structure Field |
S119 - BONNR | Transaction number (till receipt) | |
| 53 | Table/Structure Field |
S119 - ANZBON | Number of transactions (till receipts) | |
| 54 | Table/Structure Field |
S119 - ANZBKK | Number of known customers | |
| 55 | Table/Structure Field |
S119 - ANZAKO | Number of anonymous customers | |
| 56 | Table/Structure Field |
S119 - ANZAKM | Number of anonymous customers (with payment card) | |
| 57 | Table/Structure Field |
S119 - AFLAG | Promotion indicator | |
| 58 | Table/Structure Field |
S120 - EZEIT | Entry time | |
| 59 | Table/Structure Field |
S120 - SPTAG | Period to analyze - current date | |
| 60 | Table/Structure Field |
S120 - UMSGVP | Retail price w/tax from sales as per receipts/aggreg.sales | |
| 61 | Table/Structure Field |
SCAL - INDICATOR | Fatory calendar flag | |
| 62 | Table/Structure Field |
SCAL - WEEK | Factory calendar: Week | |
| 63 | Table/Structure Field |
SYST - LANGU | ABAP System Field: Language Key of Text Environment | |
| 64 | Table/Structure Field |
WAKH - AKTNR | Promotion | |
| 65 | Table/Structure Field |
WAKP - MEBME | Sales unit | |
| 66 | Table/Structure Field |
WWMI - WMINR | Product catalog number | |
| 67 | Table/Structure Field |
WWMI - WMTYP | Prod. catalog category |
