SAP ABAP Table ISUCC_USER_ADDR (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure ISUCC_USER_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  
2 BNAME XUBNAME XUBNAME CHAR 12   0   User Name in User Master Record USR02
3 KOSTL XUKOSTL CHAR8 CHAR 8   0   Cost center  
4 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
5 NAME_FIRST AD_NAMEFIR TEXT40 CHAR 40   0   First name  
6 NAME_LAST AD_NAMELAS TEXT40 CHAR 40   0   Last name  
7 NAME2 AD_NAME2_P TEXT40 CHAR 40   0   Name of person at birth  
8 NAMEMIDDLE AD_NAMEMID TEXT40 CHAR 40   0   Middle name or second forename of a person  
9 NAME_LAST2 AD_NAMLAS2 TEXT40 CHAR 40   0   Second surname of a person  
10 NAME_TEXTC AD_NAMTEXT TEXT80 CHAR 80   0   Full Name of Person  
11 CONVERTED AD_NAMCONV AD_NAMCONV CHAR 1   0   Status of Field 'Full Name' NAME_TEXT  
12 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
13 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
14 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
15 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
16 TITLE_SPPL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
17 NICKNAME AD_NICKNAM TEXT40 CHAR 40   0   Nickname or name used  
18 MC_NAMEFIR AD_MC_NMFI CHAR25 CHAR 25   0   First name in upper case for search help  
19 MC_NAMELAS AD_MC_NMLA CHAR25 CHAR 25   0   Last name in upper-case for search help  
20 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
21 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
22 NAME_TEXT AD_NAMETXT TEXT50 CHAR 50   0   Converted name field (with form of address)  
23 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
24 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
25 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
26 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
27 MC_NAME1 AD_MC_NAME CHAR25 CHAR 25   0   Name (field NAME1) in upper case for matchcode  
28 MC_CITY1 AD_MC_CITY CHAR25 CHAR 25   0   City name in upper case for search help  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ISUCC_USER_ADDR BNAME USR02 BNAME    
2 ISUCC_USER_ADDR PREFIX1 TSAD4 PREFIX_KEY REF C CN
3 ISUCC_USER_ADDR PREFIX2 TSAD4 PREFIX_KEY REF C CN
4 ISUCC_USER_ADDR TITLE TSAD3 TITLE REF C CN
5 ISUCC_USER_ADDR TITLE_ACA1 TSAD2 TITLE_KEY REF C CN
6 ISUCC_USER_ADDR TITLE_ACA2 TSAD2 TITLE_KEY REF C CN
7 ISUCC_USER_ADDR TITLE_SPPL TSAD5 TITLE_KEY REF C CN
History
Last changed by/on SAP  20140121 
SAP Release Created in