SAP Table S018
SIS: Address list for sales promotion
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 S018 (SIS: Address list for sales promotion) is a standard table in SAP ERP. It belongs to the package MCS.
Technical Information
| Table | S018 |
| Short Text | SIS: Address list for sales promotion |
| Package | MCS |
| Table Type | Transparent Table |
Fields for Table S018
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| SSOUR | ✔ | Statistic(s) origin | SSOUR | CHAR | 4 | |
| VRSIO | ✔ | Version number in the information structure | VRSIO | CHAR | 3 | * |
| SPMON | ✔ | Period to analyze - month | SPMON | NUMC | 6 | |
| SPTAG | ✔ | Period to analyze - current date | SPTAG | DATS | 8 | |
| SPWOC | ✔ | Period to analyze - week | SPWOC | NUMC | 6 | |
| SPBUP | ✔ | Period to analyze - posting period | SPBUP | NUMC | 6 | |
| VBELN | ✔ | SD document no. of a sales activity in sales support | CAS_VBELN | CHAR | 10 | VBUK |
| VERSION | ✔ | Version number | CASVERSION | NUMC | 4 | |
| NIELS | ✔ | Nielsen ID | NIELS | CHAR | 2 | TNLS |
| PSTL_LIS | ✔ | Postal code of city or PO box | PSTL_LIS | CHAR | 10 | |
| KTOKD | ✔ | Customer Account Group | KTOKD | CHAR | 4 | T077D |
| BRSCH | ✔ | Industry key | BRSCH | CHAR | 4 | T016 |
| BRAN1 | ✔ | Industry Code 1 | BRAN1_D | CHAR | 10 | TBRC |
| KUKLA | ✔ | Customer classification | KUKLA | CHAR | 2 | TKUKL |
| PAFKT | ✔ | Contact person function | PAFKT | CHAR | 2 | TPFK |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | ||
| CNT_ADR_TO | Counter: Total no. addresses in address list | CNT_ADR_TO | INT4 | 10 |