SAP Table S117
Receipt/article
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table S117 (Receipt/article) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S117 |
| Short Text | Receipt/article |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S117
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SPTAG | ✔ | Period to analyze - current date | SPTAG | DATS | 8 | |
| BONNR | ✔ | Transaction number (till receipt) | W_BONNR | NUMC | 15 | |
| WERKS | ✔ | Plant | WERKS_D | CHAR | 4 | T001W |
| MATKL | ✔ | Material Group | MATKL | CHAR | 9 | T023 |
| MATNR | ✔ | Material Number | MATNR | CHAR | 18 | MARA |
| AFLAG | ✔ | Promotion indicator | MCW_AFLAG | NUMC | 1 | |
| KALWOC | ✔ | Calendar week | MCW_KALWOC | NUMC | 2 | |
| WOCHTG | ✔ | Weekday | MCW_WOCHTG | NUMC | 1 | |
| TGZTKL | ✔ | Time of day class | MCW_TGZTKL | CHAR | 4 | TMCWW |
| VKSTD | ✔ | Hour of sale | W_VKSTD | NUMC | 2 | |
| VRSIO | ✔ | Version number in the information structure | VRSIO | CHAR | 3 | * |
| SPMON | ✔ | Period to analyze - month | SPMON | NUMC | 6 | |
| SPWOC | ✔ | Period to analyze - week | SPWOC | NUMC | 6 | |
| SPBUP | ✔ | Period to analyze - posting period | SPBUP | NUMC | 6 | |
| SSOUR | ✔ | Statistic(s) origin | SSOUR | CHAR | 4 | |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | |
| VRKME | Sales unit | VRKME | UNIT | 3 | T006 | |
| WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | |
| ATTYP | Material Category | ATTYP | CHAR | 2 | ||
| MTART | Material Type | MTART | CHAR | 4 | T134 | |
| PLGTP | Price Band Category | PLGTP | CHAR | 2 | TWPT | |
| SAISO | Season Category | SAISO | CHAR | 4 | T6WSP | |
| SAISJ | Season Year | SAISJ | CHAR | 4 | ||
| SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | |
| MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | ||
| AKTYP | Promotion Category | W_AKTYP | CHAR | 4 | TWTY | |
| AKTHE | Promotion theme | W_AKTHE | CHAR | 4 | TWAT | |
| WMINR | Product catalog number | WMINR | CHAR | 10 | WWMI | |
| KUNDK | Customer ID | W_KUNDK | CHAR | 1 | ||
| KUNNR | Customer number | KUND1 | CHAR | 10 | KNA1 | |
| CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | * | |
| UMSMNG | Transaction sales - quantity in base unit of measure | W_UMSMNG | QUAN | 15 | ||
| VKMNG | Transaction sales - quantity in sales unit | W_VKMNG | QUAN | 15 | ||
| UMSATZ | Sales POS | MCW_UMSATZ | CURR | 19 | ||
| PRSNLS | Price reduction from sales as per receipts/aggregated sales | W_PRSNLS | CURR | 19 | ||
| ANZPOS | Number of transaction items (till receipts) | MCW_ANZPOS | INT4 | 10 | ||
| ANZAAR | Number of promotion items | MCW_ANZAAR | INT4 | 10 | ||
| KMONAT | Calendar month | MCW_MONAT | NUMC | 2 | ||
| QUARTAL | Quarter | MCW_QUARTL | NUMC | 1 | ||
| JAHR | Year | MCJAHR | NUMC | 4 | ||
| UHZEIT | Time sale was entered | MCW_UHZEIT | TIMS | 6 |