S117 - Receipt/article
Receipt/article information is stored in SAP table S117.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S117
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| BONNR | Transaction number (till receipt) | X | W_BONNR | NUMC | 30 | |
| WERKS | Plant | X | WERKS_D | CHAR | 8 | T001W |
| MATKL | Material Group | X | MATKL | CHAR | 18 | T023 |
| MATNR | Material Number | X | MATNR | CHAR | 80 | MARA |
| AFLAG | Promotion indicator | X | MCW_AFLAG | NUMC | 2 | |
| KALWOC | Calendar week | X | MCW_KALWOC | NUMC | 4 | |
| WOCHTG | Weekday | X | MCW_WOCHTG | NUMC | 2 | |
| TGZTKL | Time of day class | X | MCW_TGZTKL | CHAR | 8 | TMCWW |
| VKSTD | Hour of sale | X | W_VKSTD | NUMC | 4 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| BASME | Base Unit of Measure | MEINS | UNIT | 6 | T006 | |
| VRKME | Sales unit | VRKME | UNIT | 6 | T006 | |
| WAERK | SD Document Currency | WAERK | CUKY | 10 | TCURC | |
| ATTYP | Material Category | ATTYP | CHAR | 4 | ||
| MTART | Material type | MTART | CHAR | 8 | T134 | |
| PLGTP | Price Band Category | PLGTP | CHAR | 4 | TWPT | |
| SAISO | Season Category | SAISO | CHAR | 8 | T6WSP | |
| SAISJ | Season Year | SAISJ | CHAR | 8 | ||
| SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 80 | MARA | |
| MAKTX | Material Description | MAKTX | CHAR | 80 | ||
| AKTNR | Promotion | WAKTION | CHAR | 20 | WAKH | |
| AKTYP | Promotion Category | W_AKTYP | CHAR | 8 | TWTY | |
| AKTHE | Promotion theme | W_AKTHE | CHAR | 8 | TWAT | |
| WMINR | Product catalog number | WMINR | CHAR | 20 | WWMI | |
| KUNDK | Customer ID | W_KUNDK | CHAR | 2 | ||
| KUNNR | Customer number | KUND1 | CHAR | 20 | KNA1 | |
| CCNUM | Payment cards: Card number | CCNUM | CHAR | 50 | * | |
| UMSMNG | Transaction sales - quantity in base unit of measure | W_UMSMNG | QUAN | 8 | ||
| VKMNG | Transaction sales - quantity in sales unit | W_VKMNG | QUAN | 8 | ||
| UMSATZ | Sales POS | MCW_UMSATZ | CURR | 10 | ||
| PRSNLS | Price reduction from sales as per receipts/aggregated sales | W_PRSNLS | CURR | 10 | ||
| ANZPOS | Number of transaction items (till receipts) | MCW_ANZPOS | INT4 | 4 | ||
| ANZAAR | Number of promotion items | MCW_ANZAAR | INT4 | 4 | ||
| KMONAT | Calendar month | MCW_MONAT | NUMC | 4 | ||
| QUARTAL | Quarter | MCW_QUARTL | NUMC | 2 | ||
| JAHR | Year | MCJAHR | NUMC | 8 | ||
| UHZEIT | Time sale was entered | MCW_UHZEIT | TIMS | 12 |