SAP ABAP Table SADLSTRECB (Dynamic Part of Address List (Record Body))
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ VCA (Package) CAS - activities
Basic Data
Table Category TRANSP    Transparent table 
Transparent table SADLSTRECB   Table Relationship Diagram
Short Description Dynamic Part of Address List (Record Body)    
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 .INCLUDE       0   0   Address List: Key Fields for Static and Dynamic Parts  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 LISTNR KTANR KTANR CHAR 10   0   Number of the Address List SADLSTIAD
4 VERSION CASVERSION NUM04 NUMC 4   0   Version number SADLSTIAD
5 BLKNR CASBLKNR CHAR6 CHAR 6   0   CAS usage: Address interval number SADLSTIAD
6 COUNTER CASCOUNTER INT4 INT4 10   0   Use in CAS: Artificial key field  
7 .INCLUDE       0   0   Address List: Contact Person Data  
8 PARGE PARGE GESCH CHAR 1   0   Partner's gender  
9 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
10 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
11 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
12 ANRED_AP ANRED_AP TEXT30 CHAR 30   0   Form of address for contact person (Mr, Mrs...etc)  
13 NAMEV_AP NAMEV_VP NAME CHAR 35   0   First name  
14 NAME1_AP NAME1_GP NAME CHAR 35   0   Name 1  
15 SPNAM_AP SPNAM TEXT10 CHAR 10   0   Nickname  
16 TITEL_AP TITEL_AP TEXT35 CHAR 35   0   Title of contact person (description of function)  
17 SPRAS_AP SPRAS SPRAS LANG 1   0   Language Key T002
18 .INCLUDE       0   0   Address List: Business Partner Data  
19 ANRED ANRED TEXT15 CHAR 15   0   Title  
20 NAME1 NAME1_BAS NAME CHAR 35   0   Name 1  
21 NAME2 NAME2_BAS NAME CHAR 35   0   Name 2  
22 NAME3 NAME3_BAS NAME CHAR 35   0   Name 3  
23 NAME4 NAME4_BAS NAME CHAR 35   0   Name 4  
24 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
25 .INCLUDE       0   0   Postal part of an address (for address formatting)  
26 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
27 STREET AD_STREET TEXT60 CHAR 60   0   Street  
28 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
29 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
30 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
31 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
32 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
33 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
34 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
35 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
36 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
37 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
38 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
39 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
40 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
41 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
42 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
43 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
44 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
45 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) *
46 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country *
47 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
48 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
49 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
50 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
51 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service  
52 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
53 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
54 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
55 TELF1 TLFNR TEXT30 CHAR 30   0   Addresses: telephone no.  
56 TELFX TELFX_BAS TEXT31 CHAR 31   0   Fax number  
57 .INCLUDE       0   0   CAS: Address List Fields Relevant for LIS  
58 .INCLUDE       0   0   CAS: Fields Relevant to LIS - Address List From KNA1  
59 KTOKD KTOKD KTOKD CHAR 4   0   Customer Account Group *
60 DEAR1 DEAR1 XFELD CHAR 1   0   Indicator: Competitor  
61 DEAR2 DEAR2 XFELD CHAR 1   0   Indicator: Sales partner  
62 DEAR3 DEAR3 DEAR3 CHAR 1   0   Indicator: Sales prospect  
63 DEAR4 DEAR4 XFELD CHAR 1   0   Indicator for customer type 4  
64 BRSCH BRSCH BRSCH CHAR 4   0   Industry key *
65 BRAN1 BRAN1_D BRACO CHAR 10   0   Industry code 1 *
66 BRAN2 BRAN2 BRACO CHAR 10   0   Industry code 2 *
67 BRAN3 BRAN3 BRACO CHAR 10   0   Industry code 3 *
68 BRAN4 BRAN4 BRACO CHAR 10   0   Industry code 4 *
69 BRAN5 BRAN5 BRACO CHAR 10   0   Industry code 5 *
70 NIELS NIELS NIELS CHAR 2   0   Nielsen ID *
71 KUKLA KUKLA KUKLA CHAR 2   0   Customer classification *
72 GFORM GFORM GFORM CHAR 2   0   Legal status *
73 KATR1 KATR1 ATTR1 CHAR 2   0   Attribute 1 *
74 KATR2 KATR2 ATTR2 CHAR 2   0   Attribute 2 *
75 KATR3 KATR3 ATTR3 CHAR 2   0   Attribute 3 *
76 KATR4 KATR4 ATTR4 CHAR 2   0   Attribute 4 *
77 KATR5 KATR5 ATTR5 CHAR 2   0   Attribute 5 *
78 KATR6 KATR6 ATTR6 CHAR 3   0   Attribute 6 *
79 KATR7 KATR7 ATTR7 CHAR 3   0   Attribute 7 *
80 KATR8 KATR8 ATTR8 CHAR 3   0   Attribute 8 *
81 KATR9 KATR9 ATTR9 CHAR 3   0   Attribute 9 *
82 KATR10 KATR10 ATTR10 CHAR 3   0   Attribute 10 *
83 .INCLUDE       0   0   CAS: Fields Relevant to LIS - Address List From KNVK  
84 PAVIP PAVIP PAVIP CHAR 1   0   VIP Partner *
85 FAMST FAMST FAMST CHAR 1   0   Marital Status Key *
86 PARGE_LIS PARGE GESCH CHAR 1   0   Partner's gender  
87 ABTNR ABTNR ABTNR CHAR 4   0   Department number *
88 PAFKT PAFKT PAFKT CHAR 2   0   Contact person function *
89 PARVO PARVO PARVO CHAR 1   0   Partner's power of attorney *
90 AKVER AKVER AKVER CHAR 2   0   Buying habits *
91 PARH1 PAAT1 PARHO CHAR 2   0   Contact Partner: Attribute 1 *
92 PARH2 PAAT2 PAAT2 CHAR 2   0   Contact person: Attribute 2 *
93 PARH3 PAAT3 PAAT3 CHAR 2   0   Contact person: Attribute 3 *
94 PARH4 PAAT4 PAAT4 CHAR 2   0   Contact person: Attribute 4 *
95 PARH5 PAAT5 PAAT5 CHAR 2   0   Contact person: Attribute 5 *
96 PAKN1 PAAT6 PAAT6 CHAR 3   0   Contact person: Attribute 6 *
97 PAKN2 PAAT7 PAAT7 CHAR 3   0   Contact person: Attribute 7 *
98 PAKN3 PAAT8 PAAT8 CHAR 3   0   Contact person: Attribute 8 *
99 PAKN4 PAAT9 PAAT9 CHAR 3   0   Contact person: Attribute 9 *
100 PAKN5 PAAT0 PAAT0 CHAR 3   0   Contact person: Attribute 10 *
101 .INCLUDE       0   0   CAS: Fields Relevant to LIS - Address List From the Address  
102 PSTLZ_LIS PSTLZ PSTLZ CHAR 10   0   Postal Code  
103 PSTL2_LIS PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
104 PSTL_LIS PSTL_LIS PSTLZ CHAR 10   0   Postal code of city or PO box  
105 LAND1_LIS LAND1 LAND1 CHAR 3   0   Country Key *
106 REGIO_LIS REGIO REGIO CHAR 3   0   Region (State, Province, County) *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SADLSTRECB BLKNR SADLSTIAD BLKNR KEY 1 CN
2 SADLSTRECB LISTNR SADLSTIAD LISTNR KEY 1 CN
3 SADLSTRECB MANDT T000 MANDT KEY 1 CN
4 SADLSTRECB SPRAS T002 SPRAS    
5 SADLSTRECB SPRAS_AP T002 SPRAS REF 1 CN
6 SADLSTRECB VERSION SADLSTIAD VERSION KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in