SAP ABAP Table BSBP_ADDR_VERS_PERS_ESA (International Address Version for Person with Change Info)

Hierarchy

☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ CA-FS-BP (Application Component) Business Partner Enhancements for Financial Services
     ⤷ FS_BP_BSFND_MAPPING (Package) FS Business Partner: Mapping for Enterprise Services

Basic Data

Table Category	INTTAB	Structure
Structure	BSBP_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)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BSBP_ADDR_VERS_PERS_ESA	ADDR_VERS	TSADV	NATION
2	BSBP_ADDR_VERS_PERS_ESA	NAMCOUNTRY	T005	LAND1
3	BSBP_ADDR_VERS_PERS_ESA	NAMEFORMAT	T005N	NAMEFORMAT
4	BSBP_ADDR_VERS_PERS_ESA	PREFIX1	TSAD4	PREFIX_KEY
5	BSBP_ADDR_VERS_PERS_ESA	PREFIX2	TSAD4	PREFIX_KEY
6	BSBP_ADDR_VERS_PERS_ESA	TITLE_ACA1	TSAD2	TITLE_KEY
7	BSBP_ADDR_VERS_PERS_ESA	TITLE_ACA2	TSAD2	TITLE_KEY
8	BSBP_ADDR_VERS_PERS_ESA	TITLE_P	TSAD3	TITLE
9	BSBP_ADDR_VERS_PERS_ESA	TITLE_SPPL	TSAD5	TITLE_KEY

History

Last changed by/on	SAP	20140117
SAP Release Created in	702