SAP ABAP Table FSBP_ADDR_VERS_PERS_ESA (International Address Version for Person with Change Info)
Hierarchy
☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ FS-BP (Application Component) Business Partner
     ⤷ FS_BP_ESA_INTEGRATION (Package) SAP Business Partner for Financial Services ESA Adapter
Basic Data
Table Category INTTAB    Structure 
Structure FSBP_ADDR_VERS_PERS_ESA   Table Relationship Diagram
Short Description International Address Version for Person with Change Info    
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 CHANGE_INDICATOR XO_CHANGE_INDICATOR XO_CHANGE_INDICATOR CHAR 1   0   Change Indicator  
2 ADDR_VERS AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses TSADV
3 TITLE_P AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
4 FIRSTNAME AD_NAMEFIR TEXT40 CHAR 40   0   First name  
5 LASTNAME AD_NAMELAS TEXT40 CHAR 40   0   Last name  
6 BIRTH_NAME AD_NAME2_P TEXT40 CHAR 40   0   Name of person at birth  
7 MIDDLENAME AD_NAMEMID TEXT40 CHAR 40   0   Middle name or second forename of a person  
8 SECONDNAME AD_NAMLAS2 TEXT40 CHAR 40   0   Second surname of a person  
9 FULLNAME AD_NAMTEXT TEXT80 CHAR 80   0   Full Name of Person  
10 FULLNAME_X AD_NAMCONV AD_NAMCONV CHAR 1   0   Status of Field 'Full Name' NAME_TEXT  
11 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
12 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
13 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
14 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
15 TITLE_SPPL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
16 NICKNAME AD_NICKNAM TEXT40 CHAR 40   0   Nickname or name used  
17 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
18 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
19 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
20 NAMCTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
21 PROFESSION AD_PROFESS TEXT40 CHAR 40   0   Profession  
22 SORT1_P AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
23 SORT2_P AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
24 C_O_NAME AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
25 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
26 DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
27 PO_BOX_CIT AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
28 DELIV_DIS AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
29 STREET AD_STREET TEXT60 CHAR 60   0   Street  
30 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
31 HOUSE_NO2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
32 HOUSE_NO3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
33 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
34 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
35 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
36 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
37 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
38 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
39 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
40 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
41 PREVIOUS FSBP_ADDR_VERS_PERS_ESA_OLD   STRU 0   0    
42 ADDR_VERS AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses  
43 TITLE_P AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key  
44 FIRSTNAME AD_NAMEFIR TEXT40 CHAR 40   0   First name  
45 LASTNAME AD_NAMELAS TEXT40 CHAR 40   0   Last name  
46 BIRTH_NAME AD_NAME2_P TEXT40 CHAR 40   0   Name of person at birth  
47 MIDDLENAME AD_NAMEMID TEXT40 CHAR 40   0   Middle name or second forename of a person  
48 SECONDNAME AD_NAMLAS2 TEXT40 CHAR 40   0   Second surname of a person  
49 FULLNAME AD_NAMTEXT TEXT80 CHAR 80   0   Full Name of Person  
50 FULLNAME_X AD_NAMCONV AD_NAMCONV CHAR 1   0   Status of Field 'Full Name' NAME_TEXT  
51 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key  
52 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key)  
53 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key)  
54 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key)  
55 TITLE_SPPL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key)  
56 NICKNAME AD_NICKNAM TEXT40 CHAR 40   0   Nickname or name used  
57 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
58 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format  
59 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule  
60 NAMCTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
61 PROFESSION AD_PROFESS TEXT40 CHAR 40   0   Profession  
62 SORT1_P AD_SORT1 CHAR20 CHAR 20   0   Search Term 1  
63 SORT2_P AD_SORT2 CHAR20 CHAR 20   0   Search Term 2  
64 C_O_NAME AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
65 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
66 DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
67 PO_BOX_CIT AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
68 DELIV_DIS AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
69 STREET AD_STREET TEXT60 CHAR 60   0   Street  
70 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
71 HOUSE_NO2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
72 HOUSE_NO3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
73 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
74 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
75 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
76 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
77 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
78 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
79 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
80 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 FSBP_ADDR_VERS_PERS_ESA ADDR_VERS TSADV NATION REF C CN
2 FSBP_ADDR_VERS_PERS_ESA NAMCOUNTRY T005 LAND1 REF C CN
3 FSBP_ADDR_VERS_PERS_ESA NAMEFORMAT T005N NAMEFORMAT REF C CN
4 FSBP_ADDR_VERS_PERS_ESA PREFIX1 TSAD4 PREFIX_KEY REF C CN
5 FSBP_ADDR_VERS_PERS_ESA PREFIX2 TSAD4 PREFIX_KEY REF C CN
6 FSBP_ADDR_VERS_PERS_ESA TITLE_ACA1 TSAD2 TITLE_KEY REF C CN
7 FSBP_ADDR_VERS_PERS_ESA TITLE_ACA2 TSAD2 TITLE_KEY REF C CN
8 FSBP_ADDR_VERS_PERS_ESA TITLE_P TSAD3 TITLE REF C CN
9 FSBP_ADDR_VERS_PERS_ESA TITLE_SPPL TSAD5 TITLE_KEY REF C CN
History
Last changed by/on SAP  20140117 
SAP Release Created in 300