SAP ABAP Table BAPIAD3VL (Address type 3 distribution BAPI structure)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-ADR (Application Component) Address Management/Business Address
     ⤷ SZAD (Package) SAP Technology - Business Services: Address Management

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIAD3VL	Table Relationship Diagram
Short Description	Address type 3 distribution BAPI structure

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	ADDR_VERS	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	TSADV
2	FROM_DATE	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
3	TO_DATE	☐	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
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	SEX	☐	AD_SEX	AD_SEX	CHAR	1	0	Gender key
24	LANGU_P	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
25	LANGUP_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
26	SORT1_P	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
27	SORT2_P	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
28	LANGU_CR_P	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language	T002
29	LANGUCPISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
30	DEPARTMENT	☐	AD_DPRTMNT	TEXT40	CHAR	40	0	Department
31	FUNCTION	☐	AD_FNCTN	TEXT40	CHAR	40	0	Function
32	BUILDING_P	☐	AD_BLDNG_P	TEXT10	CHAR	10	0	Building (number or code)
33	FLOOR_P	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
34	ROOM_NO_P	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
35	INITS_SIG	☐	AD_ID_CODE	TEXT10	CHAR	10	0	Short name for correspondence
36	INHOUSE_ML	☐	AD_IH_MAIL	TEXT10	CHAR	10	0	Int. mail postal code
37	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	TSAC
38	PERS_GROUP	☐	AD_GROUP_P	AD_GROUP_P	CHAR	4	0	Person Group (Key) (Business Address Services)	TSAD8

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIAD3VL	ADDR_VERS	TSADV	NATION	REF	C	CN
2	BAPIAD3VL	COMM_TYPE	TSAC	COMM_TYPE	REF	C	CN
3	BAPIAD3VL	LANGU_CR_P	T002	SPRAS	REF	C	CN
4	BAPIAD3VL	LANGU_P	T002	SPRAS	REF	C	CN
5	BAPIAD3VL	NAMCOUNTRY	T005	LAND1	REF	C	CN
6	BAPIAD3VL	NAMEFORMAT	T005N	NAMEFORMAT	REF	C	CN
7	BAPIAD3VL	PERS_GROUP	TSAD8	PERS_GROUP	REF	C	CN
8	BAPIAD3VL	PREFIX1	TSAD4	PREFIX_KEY	REF	C	CN
9	BAPIAD3VL	PREFIX2	TSAD4	PREFIX_KEY	REF	C	CN
10	BAPIAD3VL	TITLE_ACA1	TSAD2	TITLE_KEY	REF	C	CN
11	BAPIAD3VL	TITLE_ACA2	TSAD2	TITLE_KEY	REF	C	CN
12	BAPIAD3VL	TITLE_P	TSAD3	TITLE	REF	C	CN
13	BAPIAD3VL	TITLE_SPPL	TSAD5	TITLE_KEY	REF	C	CN

History

Last changed by/on	SAP	20140117
SAP Release Created in