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

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