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

SAP Table BUS_BP_RELATIONS_BW_46BC

BP: Partner Relationship Extraction Incl. Attributes for BW

BUS_BP_RELATIONS_BW_46BC (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_46BC to other SAP tables.

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

BUS_BP_RELATIONS_BW_46BC 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
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
FLG_DELETED Checkbox XFELD CHAR 1 0
X Yes
NULL No
SMTP_ADDRESS E-Mail Address AD_SMTPADR CHAR 241 0
REL_PER Obsolete: Percentage of Capital Interest BU_REL_PER DEC 10 7
REL_AMO Obsolete: Amount of Capital Interest BU_REL_AMO CURR 13 2
REL_CUR Currency Key WAERS CUKY 5 0