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