SAP ABAP Table JKSDVZSADR (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure JKSDVZSADR   Table Relationship Diagram
Short Description Generated Table for View    
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 T000
2 ADRNR JADRNR JADRNR CHAR 10   0   IS-M: Address Number  
3 HERK HERK HERK CHAR 1   0   IS-M: Use of Address  
4 XADRLOE XLOES XFELD CHAR 1   0   IS-M: Deletion Flag for Address  
5 NAME1 NAME1_ISP NAME CHAR 35   0   IS-M: Business Partner Name  
6 NAME2 NAME2_ISP NAME CHAR 35   0   IS-M: First Name of Business Partner  
7 NAME3 NAME3_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
8 NAME4 NAME4_ISP NAME CHAR 35   0   IS-M: Further Name Field for Business Partner  
9 PSTLZ PLZ_ISP PSTLZ CHAR 10   0   IS-M: Postal Code  
10 ORT01 ORT01_ISP TEXT35 CHAR 35   0   IS-M: City  
11 ORT02 ORT02_ISP TEXT35 CHAR 35   0   IS-M: City District  
12 PSTL2 PLZPF PSTLZ CHAR 10   0   IS-M: Postal Code for PO Box  
13 PSTL3 PSTL3 PSTLZ CHAR 10   0   IS-M: Company Postal Code  
14 PFACH PFACH_ISP PFACH_ISP CHAR 10   0   IS-M: Post Office Box  
15 ORTPF ORTPF TEXT35 CHAR 35   0   IS-M: City for PO Box  
16 STRAS STRAS_ISP TEXT35 CHAR 35   0   IS-M: Street Name  
17 HAUSN HSNMR1 HAUSNUMMER CHAR 10   0   IS-M: House Number  
18 HSNMR2 HSNMR2 CHAR8 CHAR 8   0   IS-M: House Number Affix  
19 ADRZUS2 ADRZUS2 ADRZUS CHAR 6   0   Classification Using a Further Address Affix  
20 STOCK STOCK STOCK CHAR 6   0   Floor  
21 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
22 PREDIRECTIONAL DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street TJS41
23 POSTDIRECTIONAL DIRECTIONAL DIRECTIONAL CHAR 10   0   IS-M: Direction for Street TJS41
24 ADDRSECABBREV ADDRSECABBREV ADDRSECABBREV CHAR 4   0   IS-M: Secondary Address Text TJS43
25 ADDRSECNUMBER ADDRSECNUMBER ADDRSECNUMBER CHAR 8   0   IS-M: Secondary Address Number  
26 STREET2 STREET2_ISM TEXT35 CHAR 35   0   IS-M: Second street line  
27 ALIASNAME ALIASNAME TEXT50 CHAR 50   0   IS-M: Alias Text (Street Name + Suffix)  
28 ERSTADR ERSTADR ERSTADR CHAR 1   0   IS-M: Address Proposal for Alternatives  
29 POSTEINSTR STRASSENNR STRASSENNR CHAR 10   0   IS-M: Street Number  
30 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
31 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
32 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
33 GP_REF GPNR GPNR CHAR 10   0   IS-M: Business Partner Key JGTGPNR
34 NAME1_MACO NAME1_ISPM NAME_MACO CHAR 35   0   IS-M: Business Partner Name (Upper Case for Matchcode)  
35 NAME2_MACO NAME2_ISPM NAME_MACO CHAR 35   0   IS-M: Bus.Partner's First Name (Upper Case for Matchcode)  
36 STRAS_MACO STRAS_ISPM STRAS_MACO CHAR 35   0   IS-M: Street Name  
37 ORT01_MACO ORT01_ISPM ORT01_MACO CHAR 35   0   IS-M/SD: City Name (Upper Case for Matchcode)  
38 ISPTELVWP ISPTELVWP ISPTELVW CHAR 10   0   IS-M: Area Code (Home)  
39 ISPTELP ISPTELP ISPTEL CHAR 20   0   IS-M: Telephone Number  
40 ISPTELVWD ISPTELVWD ISPTELVW CHAR 10   0   IS-M: Area Code - Work  
41 ISPTELD ISPTELD ISPTEL CHAR 20   0   IS-M: Telephone Number  
42 ISPHANDY ISPHANDY CHAR30 CHAR 30   0   IS-M: Mobile Phone Number  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 JKSDVZSADR ADDRSECABBREV TJS43 ADDRSECABBREV KEY 1 CN
2 JKSDVZSADR GP_REF JGTGPNR GPNR REF C CN
3 JKSDVZSADR LAND1 T005 LAND1 REF C CN
4 JKSDVZSADR MANDT T000 MANDT KEY 1 CN
5 JKSDVZSADR POSTDIRECTIONAL TJS41 DIRECTIONAL KEY 1 CN
6 JKSDVZSADR PREDIRECTIONAL TJS41 DIRECTIONAL KEY 1 CN
7 JKSDVZSADR REGIO T005S BLAND REF C CN
8 JKSDVZSADR SPRAS T002 SPRAS REF C CN
History
Last changed by/on SAP  20130529 
SAP Release Created in