SAP ABAP Table V_KNA1ADR1 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_KNA1ADR1   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster KNA1    
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 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number  
3 LAND1 LAND1_GP LAND1 CHAR 3   0   Country Key T005
4 NAME1 NAME1_GP NAME CHAR 35   0   Name 1  
5 NAME2 NAME2_GP NAME CHAR 35   0   Name 2  
6 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
7 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
8 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
9 SORTL SORTL CHAR10 CHAR 10   0   Sort field  
10 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
11 TELF1 TELF1 TEXT16 CHAR 16   0   First telephone number  
12 TELFX TELFX TEXT31 CHAR 31   0   Fax Number  
13 ADRNR ADRNR ADRNR CHAR 10   0   Address  
14 MCOD1 MCDD1 CHAR25 CHAR 25   0   Search term for matchcode search  
15 MCOD2 MCDD2 CHAR25 CHAR 25   0   Search Term for Matchcode Search  
16 MCOD3 MCDD3 CHAR25 CHAR 25   0   Search term for matchcode search  
17 ANRED ANRED TEXT15 CHAR 15   0   Title  
18 DATLT DATLT TEXT14 CHAR 14   0   Data communication line no.  
19 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
20 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
21 ORT02 ORT02_GP TEXT35 CHAR 35   0   District  
22 PFACH PFACH PFACH CHAR 10   0   PO Box  
23 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
24 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
25 TELBX TELBX TEXT15 CHAR 15   0   Telebox number  
26 TELF2 TELF2 TEXT16 CHAR 16   0   Second telephone number  
27 TELTX TELTX TEXT30 CHAR 30   0   Teletex number  
28 TELX1 TELX1 TEXT30 CHAR 30   0   Telex number  
29 LZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
30 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
31 PFORT PFORT_GP TEXT35 CHAR 35   0   PO Box city  
32 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
33 DUEFL DUEFL_BKPF DUEFL_BKPF CHAR 1   0   Status of Data Transfer into Subsequent Release  
34 KNURL URL TEXT132 CHAR 132   0   Uniform resource locator  
35 PSOHS PSOHS CHAR06 CHAR 6   0   House number: is no longer used from Release 4.6B  
36 PSOST PSOST PSOST CHAR 28   0   Street: No longer used from Release 4.6B  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_KNA1ADR1 LAND1 T005 LAND1 REF C CN
2 V_KNA1ADR1 LZONE TZONE ZONE1 REF C CN
3 V_KNA1ADR1 MANDT T000 MANDT KEY 1 CN
4 V_KNA1ADR1 REGIO T005S BLAND REF C CN
5 V_KNA1ADR1 SPRAS T002 SPRAS REF 1 CN
6 V_KNA1ADR1 TXJCD TTXJ TXJCD REF C CN
7 V_KNA1ADR1 WERKS T001W WERKS REF C CN
History
Last changed by/on SAP  20140122 
SAP Release Created in