SAP ABAP Table BUS_BP_RELATIONS_BW_470 (BP: Partner Relationship Extraction Incl. Attributes for BW)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	BUS_BP_RELATIONS_BW_470	Table Relationship Diagram
Short Description	BP: Partner Relationship Extraction Incl. Attributes for BW

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	RELNR	☐	BU_RELNR	BU_RELNR	CHAR	12	0	BP Relationship Number	*
3	PARTNER1	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
4	PARTNER2	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
5	PARTNER1_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
6	PARTNER2_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
7	RELDIR	☐	BUPA_RELDIR_BW	BUPA_RELDIR_BW	CHAR	1	0	Direction of a Business Partner Relationship Category
8	RELTYP	☐	BU_RELTYP	BU_RELTYP	CHAR	6	0	Business Partner Relationship Category	*
9	DATE_TO	☐	BU_DATTO	DATUM	DATS	8	0	Validity Date (Valid To)
10	DATE_FROM	☐	BU_DATFROM	DATUM	DATS	8	0	Validity Date (Valid From)
11	PAFKT	☐	BU_PAFKT	BU_PAFKT	CHAR	4	0	Function of partner	*
12	ABTNR	☐	BU_ABTNR	BU_ABTNR	CHAR	4	0	Department	*
13	PAAUTH	☐	BU_PAAUTH	BU_PAAUTH	CHAR	1	0	Partner's Authority	*
14	PAVIP	☐	BU_PAVIP	BU_PAVIP	CHAR	1	0	VIP Partner	*
15	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
16	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
17	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
18	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
19	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
20	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
21	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
22	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
23	CMPY_PART_PER	☐	BU_COMPANY_PART_PER_BW		DEC	13	7	Percentage of Capital Interest
24	CMPY_PART_AMO	☐	BU_COMPANY_PART_AMO	WERTV7	CURR	13	2	Amount of Capital Interest
25	CMPY_PART_CUR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
26	CMPY_CONTROL	☐	BU_COMPANY_CONTROL	BU_COMPANY_CONTROL	CHAR	1	0	Indicator: Shareholder Controls Company/Partnership
27	ADDR_SHORT	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
28	ADDR_SHORT_S	☐	AD_LINE_S	CHAR80	CHAR	80	0	One-line short form of formatted address
29	LINE0	☐	ADDR_LINE0_BW	LINES	CHAR	80	0	BP Address: Line 0
30	LINE1	☐	ADDR_LINE1_BW	LINES	CHAR	80	0	BP Address: Line 1
31	LINE2	☐	ADDR_LINE2_BW	LINES	CHAR	80	0	BP Address: Line 2
32	LINE3	☐	ADDR_LINE3_BW	LINES	CHAR	80	0	BP Address: Line 3
33	LINE4	☐	ADDR_LINE4_BW	LINES	CHAR	80	0	BP Address: Line 4
34	LINE5	☐	ADDR_LINE5_BW	LINES	CHAR	80	0	BP Address: Line 5
35	LINE6	☐	ADDR_LINE6_BW	LINES	CHAR	80	0	BP Address: Line 6
36	LINE7	☐	ADDR_LINE7_BW	LINES	CHAR	80	0	BP Address: Line 7
37	LINE8	☐	ADDR_LINE8_BW	LINES	CHAR	80	0	BP Address: Line 8
38	LINE9	☐	ADDR_LINE9_BW	LINES	CHAR	80	0	BP Address: Line 9
39	FLG_DELETED	☐	XFELD	XFELD	CHAR	1	0	Checkbox
40	.INCLUDE	☐				0	0	SAP BP: SAP BW Administration Data
41	DQ_ONLINE_UPDATE	☐	BU_DQ_ONLINE_UPD	XFELD	CHAR	1	0	SAP BP: Delta Queue Update Online
42	DQ_OFFLINE_UPDATE	☐	BU_DQ_OFFLINE_UPD	XFELD	CHAR	1	0	SAP BP: Delta Queue Update Offline
43	DQ_TIMESTAMP	☐	BU_DQ_TIMESTAMP	TZNTSTMPS	DEC	15	0	Delta Queue Update Time Stamp

History

Last changed by/on	SAP	20130604
SAP Release Created in	2002_1_470