SAP ABAP Table BAPIBUS1006_AD2VD (BP: Address Data National Version for Persons)

Hierarchy

☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ AP-MD-BP (Application Component) SAP Business Partner
     ⤷ BUPA (Package) SAP Business Partner

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIBUS1006_AD2VD	Table Relationship Diagram
Short Description	BP: Address Data National Version for Persons

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	ADDRESS_GUID	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
2	.INCLUDE	☐				0	0	BAPI Structure Address Type 2 Fields Dep. on Int. Versions
3	ADDR_VERS	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	TSADV
4	TITLE_P	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
5	FIRSTNAME	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
6	LASTNAME	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
7	BIRTH_NAME	☐	AD_NAME2_P	TEXT40	CHAR	40	0	Name of person at birth
8	MIDDLENAME	☐	AD_NAMEMID	TEXT40	CHAR	40	0	Middle name or second forename of a person
9	SECONDNAME	☐	AD_NAMLAS2	TEXT40	CHAR	40	0	Second surname of a person
10	FULLNAME	☐	AD_NAMTEXT	TEXT80	CHAR	80	0	Full Name of Person
11	FULLNAME_X	☐	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	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
19	NAMEFORMAT	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	T005N
20	NAMCOUNTRY	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	T005
21	NAMCTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
22	PROFESSION	☐	AD_PROFESS	TEXT40	CHAR	40	0	Profession
23	SORT1_P	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
24	SORT2_P	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
25	C_O_NAME	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
26	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
27	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
28	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
29	DELIV_DIS	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
30	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
31	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
32	HOUSE_NO2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
33	HOUSE_NO3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
34	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
35	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
36	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
37	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
38	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
39	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
40	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
41	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
42	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
43	COUNTY	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
44	TOWNSHIP	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township

Foreign Keys

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

History

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