1. Home
  2. Resources
  3. SAP Tables
  4. BUS_BP_RELATIONS_BW_470 - BP: Partner Relationship Extraction Incl. Attributes for BW

SAP Table BUS_BP_RELATIONS_BW_470

BP: Partner Relationship Extraction Incl. Attributes for BW

BUS_BP_RELATIONS_BW_470 (BP: Partner Relationship Extraction Incl. Attributes for BW) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BUS_BP_RELATIONS_BW_470 to other SAP tables.

Source: BUS_BP_RELATIONS_BW_470 (BP: Partner Relationship Extraction Incl. Attributes for BW)

BUS_BP_RELATIONS_BW_470 table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT CLNT 3 0
RELNR BP Relationship Number BU_RELNR CHAR 12 0
PARTNER1 Business Partner Number BU_PARTNER CHAR 10 0
PARTNER2 Business Partner Number BU_PARTNER CHAR 10 0
PARTNER1_GUID Business Partner GUID BU_PARTNER_GUID RAW 16 0
PARTNER2_GUID Business Partner GUID BU_PARTNER_GUID RAW 16 0
RELDIR Direction of a Business Partner Relationship Category BUPA_RELDIR_BW CHAR 1 0
1 Is a Partner Of
2 Has the Partner
RELTYP Business Partner Relationship Category BU_RELTYP CHAR 6 0
DATE_TO Validity Date (Valid To) BU_DATTO DATS 8 0
DATE_FROM Validity Date (Valid From) BU_DATFROM DATS 8 0
PAFKT Function of partner BU_PAFKT CHAR 4 0
ABTNR Department BU_ABTNR CHAR 4 0
PAAUTH Partner's Authority BU_PAAUTH CHAR 1 0
PAVIP VIP Partner BU_PAVIP CHAR 1 0
COUNTRY Country Key LAND1 CHAR 3 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
CITY1 City AD_CITY1 CHAR 40 0
STREET Street AD_STREET CHAR 60 0
HOUSE_NUM1 House Number AD_HSNM1 CHAR 10 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
FAX_NUMBER First fax no.: dialling code+number AD_FXNMBR1 CHAR 30 0
SMTP_ADDR E-Mail Address AD_SMTPADR CHAR 241 0
CMPY_PART_PER Percentage of Capital Interest BU_COMPANY_PART_PER_BW DEC 13 7
CMPY_PART_AMO Amount of Capital Interest BU_COMPANY_PART_AMO CURR 13 2
CMPY_PART_CUR Currency Key WAERS CUKY 5 0
CMPY_CONTROL Indicator: Shareholder Controls Company/Partnership BU_COMPANY_CONTROL CHAR 1 0
NULL No
X Yes
ADDR_SHORT One-line short form of formatted address AD_LINE_S CHAR 80 0
ADDR_SHORT_S One-line short form of formatted address AD_LINE_S CHAR 80 0
LINE0 BP Address: Line 0 ADDR_LINE0_BW CHAR 80 0
LINE1 BP Address: Line 1 ADDR_LINE1_BW CHAR 80 0
LINE2 BP Address: Line 2 ADDR_LINE2_BW CHAR 80 0
LINE3 BP Address: Line 3 ADDR_LINE3_BW CHAR 80 0
LINE4 BP Address: Line 4 ADDR_LINE4_BW CHAR 80 0
LINE5 BP Address: Line 5 ADDR_LINE5_BW CHAR 80 0
LINE6 BP Address: Line 6 ADDR_LINE6_BW CHAR 80 0
LINE7 BP Address: Line 7 ADDR_LINE7_BW CHAR 80 0
LINE8 BP Address: Line 8 ADDR_LINE8_BW CHAR 80 0
LINE9 BP Address: Line 9 ADDR_LINE9_BW CHAR 80 0
FLG_DELETED Checkbox XFELD CHAR 1 0
X Yes
NULL No
DQ_ONLINE_UPDATE SAP BP: Delta Queue Update Online BU_DQ_ONLINE_UPD CHAR 1 0
X Yes
NULL No
DQ_OFFLINE_UPDATE SAP BP: Delta Queue Update Offline BU_DQ_OFFLINE_UPD CHAR 1 0
X Yes
NULL No
DQ_TIMESTAMP Delta Queue Update Time Stamp BU_DQ_TIMESTAMP DEC 15 0