SAP ABAP Table BAPIAD2VI (BAPI Structure Address Type 2 Fields Indep. of Int. Versions)

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	BAPIAD2VI	Table Relationship Diagram
Short Description	BAPI Structure Address Type 2 Fields Indep. of Int. Versions

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	FROM_DATE	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
2	TO_DATE	☐	AD_DATE_TO	DATUM	DATS	8	0	Valid-to date in current Release only 99991231 possible
3	SEX	☐	AD_SEX	AD_SEX	CHAR	1	0	Gender key
4	LANGU_P	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
5	LANGUP_ISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
6	LANGU_CR_P	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language	T002
7	LANGUCPISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
8	CITY_NO	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
9	DISTRCT_NO	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	ADRCITYPRT
10	CHCKSTATUS	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
11	REGIOGROUP	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
12	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
13	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
14	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
15	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
16	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
17	PO_W_O_NO	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
18	PBOXCIT_NO	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	ADRCITY
19	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
20	POBOX_CTRY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
21	PO_CTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
22	TRANSPZONE	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
23	STREET_NO	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
24	STR_ABBR	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	ADRSTRTYPE
25	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
26	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
27	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
28	EXTENS_1	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
29	EXTENS_2	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
30	TIME_ZONE	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
31	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
32	ADDRESS_ID	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
33	LANGU_CR	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language	T002
34	LANGUCRISO	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
35	COMM_TYPE	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	TSAC
36	PERS_GROUP	☐	AD_GROUP_P	AD_GROUP_P	CHAR	4	0	Person Group (Key) (Business Address Services)	TSAD8
37	ADDR_GROUP	☐	AD_GROUP	AD_GROUP	CHAR	4	0	Address Group (Key) (Business Address Services)	TSAD7
38	HOMECITYNO	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file	*
39	DONT_USE_S	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	*
40	DONT_USE_P	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag	*
41	COUNTY_NO	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county	*
42	TOWNSHIP_NO	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIAD2VI	ADDR_GROUP	TSAD7	ADDR_GROUP	REF	C	CN
2	BAPIAD2VI	CITY_NO	ADRCITY	CITY_CODE	REF	C	CN
3	BAPIAD2VI	COMM_TYPE	TSAC	COMM_TYPE	REF	C	CN
4	BAPIAD2VI	COUNTRY	T005	LAND1	REF	C	CN
5	BAPIAD2VI	DISTRCT_NO	ADRCITYPRT	CITYP_CODE	REF	C	CN
6	BAPIAD2VI	LANGU_CR	T002	SPRAS	REF	C	CN
7	BAPIAD2VI	LANGU_CR_P	T002	SPRAS	REF	C	CN
8	BAPIAD2VI	LANGU_P	T002	SPRAS	REF	C	CN
9	BAPIAD2VI	PBOXCIT_NO	ADRCITY	CITY_CODE	REF	C	CN
10	BAPIAD2VI	PERS_GROUP	TSAD8	PERS_GROUP	REF	C	CN
11	BAPIAD2VI	POBOX_CTRY	T005	LAND1	REF	C	CN
12	BAPIAD2VI	PO_BOX_REG	T005S	BLAND	REF	C	CN
13	BAPIAD2VI	REGIOGROUP	ADRREGGRP	REGIOGROUP	REF	C	CN
14	BAPIAD2VI	REGION	T005S	BLAND	REF	C	CN
15	BAPIAD2VI	STREET_NO	ADRSTREET	STRT_CODE	REF	C	CN
16	BAPIAD2VI	STR_ABBR	ADRSTRTYPE	STRTYPEAB	REF	C	CN
17	BAPIAD2VI	TIME_ZONE	TTZZ	TZONE	REF	C	CN
18	BAPIAD2VI	TRANSPZONE	TZONE	ZONE1	REF	C	CN

History

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