SAP ABAP Table /ISDFPS/V_ADDR (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure /ISDFPS/V_ADDR   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 PLVAR PLVAR PLVAR CHAR 2   0   Plan Version T778P
3 OTYPE OTYPE OTYPE CHAR 2   0   Object Type T778O
4 OBJID HROBJID HROBJID NUMC 8   0   Object ID PLOGI
5 SUBTY SUBTYP SUBTYP CHAR 4   0   Subtype  
6 ISTAT ISTAT_D ISTAT CHAR 1   0   Planning Status T778S
7 BEGDA BEGDATUM DATUM DATS 8   0   Start Date  
8 ENDDA ENDDATUM DATUM DATS 8   0   End Date  
9 VARYF VARYF CHAR10 CHAR 10   0   Variation Field for File PLOG  
10 SEQNR SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
11 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number  
12 DATE_FROM AD_DATE_FR DATUM DATS 8   0   Valid-from date - in current Release only 00010101 possible  
13 NATION AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses TSADV
14 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
15 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
16 NAME_TEXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
17 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
18 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
19 STREET AD_STREET TEXT60 CHAR 60   0   Street  
20 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
21 ADDR_GROUP AD_GROUP AD_GROUP CHAR 4   0   Address Group (Key) (Business Address Services) TSAD7
22 SORT1 AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
23 SORT2 AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
24 MC_NAME1 AD_MC_NAME CHAR25 CHAR 25   0   Name (field NAME1) in upper case for matchcode  
25 MC_CITY1 AD_MC_CITY CHAR25 CHAR 25   0   City name in upper case for search help  
26 MC_STREET AD_MC_STRT CHAR25 CHAR 25   0   Street name in upper case for search help  
27 K_BEGDA BEGDATUM DATUM DATS 8   0   Start Date  
28 K_ENDDA ENDDATUM DATUM DATS 8   0   End Date  
29 K_LANGU LANGU SPRAS LANG 1   0   Language Key T002
30 K_SEQNR SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
31 K_ISTAT ISTAT_D ISTAT CHAR 1   0   Planning Status T778S
32 SHORT SHORT_D TEXT12 CHAR 12   0   Object Abbreviation  
33 STEXT STEXT TEXT40 CHAR 40   0   Object Name  
34 MC_SHORT HR_MCSHORT CHAR12 CHAR 12   0   Object Abbreviation  
35 MC_STEXT HR_MCSTEXT CHAR40 CHAR 40   0   Name  
36 MC_SEARK HR_MCSEARK CHAR52 CHAR 52   0   Search Term  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /ISDFPS/V_ADDR ADDR_GROUP TSAD7 ADDR_GROUP REF C CN
2 /ISDFPS/V_ADDR ISTAT T778S ISTAT KEY 1 CN
3 /ISDFPS/V_ADDR K_ISTAT T778S ISTAT KEY 1 CN
4 /ISDFPS/V_ADDR K_LANGU T002 SPRAS KEY 1 CN
5 /ISDFPS/V_ADDR MANDT T000 MANDT KEY 1 CN
6 /ISDFPS/V_ADDR NATION TSADV NATION KEY 1 CN
7 /ISDFPS/V_ADDR OBJID PLOGI OBJID KEY 1 CN
8 /ISDFPS/V_ADDR OTYPE T778O OTYPE KEY 1 CN
9 /ISDFPS/V_ADDR PLVAR T778P PLVAR KEY 1 CN
History
Last changed by/on SAP  20140121 
SAP Release Created in