SAP ABAP Table BUS_ADDRESS_IN_VERSION_BW_INT (SAP BP: Extract Structure Standard Address Business Partner)

Hierarchy

☛ PI_BASIS (Software Component) Basis Plug-In
   ⤷ AP-MD-BP (Application Component) SAP Business Partner
     ⤷ BUPA_ADDRESS_BW (Package) SAP BP: Extraction BW Partner Address

Basic Data

Table Category	INTTAB	Structure
Structure	BUS_ADDRESS_IN_VERSION_BW_INT	Table Relationship Diagram
Short Description	SAP BP: Extract Structure Standard Address Business Partner

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	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
2	PARTNER_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
3	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
4	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
5	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	*
6	VALID_FROM	☐	BU_ADVW_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start of a Business Partner Address Usage
7	VALID_TO	☐	BU_ADVW_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End of a Business Partner Address Usage
8	ADDR_VALID_FROM	☐	BU_ADDR_VALID_FROM	TZNTSTMPS	DEC	15	0	Validity Start of a Business Partner Address
9	ADDR_VALID_TO	☐	BU_ADDR_VALID_TO	TZNTSTMPS	DEC	15	0	Validity End of a Business Partner Address
10	TITLE	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
11	NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
12	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
13	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
14	HOME_CITY	☐	PI_AD_CITY3	TEXT40	CHAR	40	0	City (Different from Postal City)
15	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
16	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
17	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
18	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
19	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
20	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
21	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
22	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
23	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
24	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
25	ADDR_SHORT	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
26	ADDR_SHORT_S	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
27	LINE0	☐	ADDR_LINE0_BW	LINES	CHAR	80	0	BP Address: Line 0
28	LINE1	☐	ADDR_LINE1_BW	LINES	CHAR	80	0	BP Address: Line 1
29	LINE2	☐	ADDR_LINE2_BW	LINES	CHAR	80	0	BP Address: Line 2
30	LINE3	☐	ADDR_LINE3_BW	LINES	CHAR	80	0	BP Address: Line 3
31	LINE4	☐	ADDR_LINE4_BW	LINES	CHAR	80	0	BP Address: Line 4
32	LINE5	☐	ADDR_LINE5_BW	LINES	CHAR	80	0	BP Address: Line 5
33	LINE6	☐	ADDR_LINE6_BW	LINES	CHAR	80	0	BP Address: Line 6
34	LINE7	☐	ADDR_LINE7_BW	LINES	CHAR	80	0	BP Address: Line 7
35	LINE8	☐	ADDR_LINE8_BW	LINES	CHAR	80	0	BP Address: Line 8
36	LINE9	☐	ADDR_LINE9_BW	LINES	CHAR	80	0	BP Address: Line 9
37	TXTSH	☐	RSTXTSH	TEXT20	CHAR	20	0	Short description
38	TXTMD	☐	RSTXTMD	TEXT40	CHAR	40	0	Medium description
39	TXTLG	☐	RSTXTLG	TEXT60	CHAR	60	0	Long description

History

Last changed by/on	SAP	20130604
SAP Release Created in	2005_1_700