SAP ABAP Table SADLSTRECL (List structure for addresses)
Hierarchy
☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-CAS (Application Component) Sales Support
     ⤷ VCR (Package) CAS - reporting
Basic Data
Table Category INTTAB    Structure 
Structure SADLSTRECL   Table Relationship Diagram
Short Description List structure for addresses    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 *
2 LISTNR KTANR KTANR CHAR 10   0   Number of the Address List  
3 VERSION CASVERSION NUM04 NUMC 4   0   Version number  
4 BLKNR CASBLKNR CHAR6 CHAR 6   0   CAS usage: Address interval number  
5 COUNTER CASCOUNTER INT4 INT4 10   0   Use in CAS: Artificial key field  
6 PARGE PARGE GESCH CHAR 1   0   Partner's gender  
7 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
8 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number *
9 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor *
10 ANRED_AP ANRED_AP TEXT30 CHAR 30   0   Form of address for contact person (Mr, Mrs...etc)  
11 NAMEV_AP NAMEV_VP NAME CHAR 35   0   First name  
12 NAME1_AP NAME1_GP NAME CHAR 35   0   Name 1  
13 SPNAM_AP SPNAM TEXT10 CHAR 10   0   Nickname  
14 TITEL_AP TITEL_AP TEXT35 CHAR 35   0   Title of contact person (description of function)  
15 SPRAS_AP SPRAS SPRAS LANG 1   0   Language Key T002
16 ANRED ANRED TEXT15 CHAR 15   0   Title  
17 NAME1 NAME1_BAS NAME CHAR 35   0   Name 1  
18 NAME2 NAME2_BAS NAME CHAR 35   0   Name 2  
19 NAME3 NAME3_BAS NAME CHAR 35   0   Name 3  
20 NAME4 NAME4_BAS NAME CHAR 35   0   Name 4  
21 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
22 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
23 STREET AD_STREET TEXT60 CHAR 60   0   Street  
24 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
25 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
26 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
27 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
28 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
29 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
30 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
31 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
32 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
33 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
34 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
35 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
36 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
37 TELF1 TLFNR TEXT30 CHAR 30   0   Addresses: telephone no.  
38 TELFX TELFX_BAS TEXT31 CHAR 31   0   Fax number  
39 KTOKD KTOKD KTOKD CHAR 4   0   Customer Account Group *
40 DEAR1 DEAR1 XFELD CHAR 1   0   Indicator: Competitor  
41 DEAR2 DEAR2 XFELD CHAR 1   0   Indicator: Sales partner  
42 DEAR3 DEAR3 DEAR3 CHAR 1   0   Indicator: Sales prospect  
43 DEAR4 DEAR4 XFELD CHAR 1   0   Indicator for customer type 4  
44 BRSCH BRSCH BRSCH CHAR 4   0   Industry key *
45 BRAN1 BRAN1_D BRACO CHAR 10   0   Industry code 1 *
46 BRAN2 BRAN2 BRACO CHAR 10   0   Industry code 2 *
47 BRAN3 BRAN3 BRACO CHAR 10   0   Industry code 3 *
48 BRAN4 BRAN4 BRACO CHAR 10   0   Industry code 4 *
49 BRAN5 BRAN5 BRACO CHAR 10   0   Industry code 5 *
50 NIELS NIELS NIELS CHAR 2   0   Nielsen ID *
51 KUKLA KUKLA KUKLA CHAR 2   0   Customer classification *
52 GFORM GFORM GFORM CHAR 2   0   Legal status *
53 KATR1 KATR1 ATTR1 CHAR 2   0   Attribute 1 *
54 KATR2 KATR2 ATTR2 CHAR 2   0   Attribute 2 *
55 KATR3 KATR3 ATTR3 CHAR 2   0   Attribute 3 *
56 KATR4 KATR4 ATTR4 CHAR 2   0   Attribute 4 *
57 KATR5 KATR5 ATTR5 CHAR 2   0   Attribute 5 *
58 KATR6 KATR6 ATTR6 CHAR 3   0   Attribute 6 *
59 KATR7 KATR7 ATTR7 CHAR 3   0   Attribute 7 *
60 KATR8 KATR8 ATTR8 CHAR 3   0   Attribute 8 *
61 KATR9 KATR9 ATTR9 CHAR 3   0   Attribute 9 *
62 KATR10 KATR10 ATTR10 CHAR 3   0   Attribute 10 *
63 PAVIP PAVIP PAVIP CHAR 1   0   VIP Partner *
64 FAMST FAMST FAMST CHAR 1   0   Marital Status Key *
65 PARGE_LIS PARGE GESCH CHAR 1   0   Partner's gender  
66 ABTNR ABTNR ABTNR CHAR 4   0   Department number *
67 PAFKT PAFKT PAFKT CHAR 2   0   Contact person function *
68 PARVO PARVO PARVO CHAR 1   0   Partner's power of attorney *
69 AKVER AKVER AKVER CHAR 2   0   Buying habits *
70 PARH1 PAAT1 PARHO CHAR 2   0   Contact Partner: Attribute 1 *
71 PARH2 PAAT2 PAAT2 CHAR 2   0   Contact person: Attribute 2 *
72 PARH3 PAAT3 PAAT3 CHAR 2   0   Contact person: Attribute 3 *
73 PARH4 PAAT4 PAAT4 CHAR 2   0   Contact person: Attribute 4 *
74 PARH5 PAAT5 PAAT5 CHAR 2   0   Contact person: Attribute 5 *
75 PAKN1 PAAT6 PAAT6 CHAR 3   0   Contact person: Attribute 6 *
76 PAKN2 PAAT7 PAAT7 CHAR 3   0   Contact person: Attribute 7 *
77 PAKN3 PAAT8 PAAT8 CHAR 3   0   Contact person: Attribute 8 *
78 PAKN4 PAAT9 PAAT9 CHAR 3   0   Contact person: Attribute 9 *
79 PAKN5 PAAT0 PAAT0 CHAR 3   0   Contact person: Attribute 10 *
80 PSTLZ_LIS PSTLZ PSTLZ CHAR 10   0   Postal Code  
81 PSTL2_LIS PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
82 PSTL_LIS PSTL_LIS PSTLZ CHAR 10   0   Postal code of city or PO box  
83 LAND1_LIS LAND1 LAND1 CHAR 3   0   Country Key *
84 REGIO_LIS REGIO REGIO CHAR 3   0   Region (State, Province, County) *
85 SORTKEY1 CASSORTKEY CHAR35 CHAR 35   0   Sort key for addresses in a list  
86 SORTKEY2 CASSORTKEY CHAR35 CHAR 35   0   Sort key for addresses in a list  
87 SORTKEY3 CASSORTKEY CHAR35 CHAR 35   0   Sort key for addresses in a list  
88 BNRART NRART NRART CHAR 2   0   Type of partner number *
89 BPARNR KUNDE_D KUNDE CHAR 10   0   Partner number (KUNNR, LIFNR, or PERNR)  
90 BNRART2 NRART NRART CHAR 2   0   Type of partner number *
91 BPARNR2 KUNDE_D KUNDE CHAR 10   0   Partner number (KUNNR, LIFNR, or PERNR)  
92 ADRBPARNR ADRNR ADRNR CHAR 10   0   Address *
93 ADRBPARNR2 ADRNR ADRNR CHAR 10   0   Address *
94 ADR_MAN ADRNR ADRNR CHAR 10   0   Address *
95 ADRTYPE ADRTYPE ADRTYPE CHAR 1   0   Address Type  
96 STATUS CASASTATUS CASASTATUS CHAR 1   0   Application CAS: statusflag of an address of an address list  
97 SELKZ SELKZ SELKZ CHAR 1   0   Selection flag  
98 UPDKZ CAS_UPDKZ UPDKZ CHAR 1   0   Update indicator for addresses in an address list  
99 ALV_ROW_COLOR ALV_ROW_COLOR ALV_ROW_COLOR CHAR 3   0   Color of a row in ALV  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 SADLSTRECL SPRAS T002 SPRAS    
2 SADLSTRECL SPRAS_AP T002 SPRAS REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in