SAP ABAP Table S018 (SIS: Address list for sales promotion)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S018   Table Relationship Diagram
Short Description SIS: Address list for sales promotion    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
3 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
4 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
5 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
6 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
7 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
8 VBELN CAS_VBELN VBELN CHAR 10   0   SD document no. of a sales activity in sales support VBUK
9 VERSION CASVERSION NUM04 NUMC 4   0   Version number  
10 NIELS NIELS NIELS CHAR 2   0   Nielsen ID TNLS
11 PSTL_LIS PSTL_LIS PSTLZ CHAR 10   0   Postal code of city or PO box  
12 KTOKD KTOKD KTOKD CHAR 4   0   Customer Account Group T077D
13 BRSCH BRSCH BRSCH CHAR 4   0   Industry key T016
14 BRAN1 BRAN1_D BRACO CHAR 10   0   Industry code 1 TBRC
15 KUKLA KUKLA KUKLA CHAR 2   0   Customer classification TKUKL
16 PAFKT PAFKT PAFKT CHAR 2   0   Contact person function TPFK
17 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
18 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
19 CNT_ADR_TO CNT_ADR_TO INT4 INT4 10   0   Counter: Total no. addresses in address list  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S018 BRAN1 TBRC BRACO    
2 S018 BRSCH T016 BRSCH    
3 S018 KTOKD T077D KTOKD    
4 S018 KUKLA TKUKL KUKLA    
5 S018 MANDT T000 MANDT    
6 S018 NIELS TNLS NIELS    
7 S018 PAFKT TPFK PAFKT    
8 S018 VBELN VBUK VBELN    
History
Last changed by/on SAP  20110901 
SAP Release Created in