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

History

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