SAP ABAP Table VIGW_V_SADR (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure VIGW_V_SADR   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 SADRNR SADRNR CHAR 10   0   Address number SANS1
3 OBJNR SOBJNR SOBJNR NUMC 10   0   Object number (virtual object)  
4 OBTYP SOBTYP SOBTYP NUMC 2   0   Object type for objects to which addresses are assigned TZV03
5 NAME3 NAME3_GP NAME CHAR 35   0   Name 3  
6 NAME4 NAME4_GP NAME CHAR 35   0   Name 4  
7 ADRZUS ADRZUS TEXT35 CHAR 35   0   Address addit. info. (e.g. storey)  
8 PSTL2 PSTL2 PSTLZ CHAR 10   0   P.O. Box Postal Code  
9 PFACH PFACH PFACH CHAR 10   0   PO Box  
10 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
11 PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
12 ORT01 ORT01_GP TEXT35 CHAR 35   0   City  
13 ORT02 ORT02_GP TEXT35 CHAR 35   0   District  
14 PSTBZ PSTBZ PSTBZ CHAR 15   0   Post delivery district  
15 STRAS STRAS_GP TEXT35 CHAR 35   0   House number and street  
16 STRA1 STRAS_GP TEXT35 CHAR 35   0   House number and street  
17 REGIO REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
18 ORT01_MC VVXORT01MC CHAR16 CHAR 16   0   IS-IS: City 1 in upper case characters for matchcode search  
19 STRAS_MC VVXSTRASMC CHAR16 CHAR 16   0   IS-IS: Street in upper case characters for matchcode search  
20 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 VIGW_V_SADR ADRNR SANS1 ADRNR KEY 1 1
2 VIGW_V_SADR LAND1 T005 LAND1 KEY 1 1
3 VIGW_V_SADR MANDT T000 MANDT KEY 1 1
4 VIGW_V_SADR OBTYP TZV03 OBTYP KEY 1 1
5 VIGW_V_SADR REGIO T005S BLAND KEY 1 1
History
Last changed by/on SAP  20130529 
SAP Release Created in