1. Home
  2. Resources
  3. SAP Tables
  4. BUT051 - BP Relationship: Contact Person Relationship

SAP Table BUT051

BP Relationship: Contact Person Relationship

BUT051 (BP Relationship: Contact Person Relationship) 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 BUT051 to other SAP tables.

BUT051 table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
RELNR BP Relationship Number BU_RELNR BUT050 CHAR 12 0
PARTNER1 Business Partner Number BU_PARTNER CHAR 10 0
PARTNER2 Business Partner Number BU_PARTNER CHAR 10 0
DATE_TO Validity Date (Valid To) BU_DATTO DATS 8 0
RELTYP Business Partner Relationship Category BU_RELTYP TBZ9 CHAR 6 0
XRF Business partner role definition instead of BP relationship BU_XRF CHAR 1 0
X Yes
NULL No
FNCTN Function name of partner BU_FNCTN CHAR 40 0
PAFKT Function of partner BU_PAFKT TB912 CHAR 4 0
DPRTMNT Department at business partner BU_DPRTMNT CHAR 40 0
ABTNR Department BU_ABTNR TB910 CHAR 4 0
PAAUTH Partner's Authority BU_PAAUTH TB914 CHAR 1 0
PAVIP VIP Partner BU_PAVIP TB916 CHAR 1 0
PAREM Notes for Partner BU_PAREM CHAR 40 0
TEL_NUMBER Telephone no.: dialling code+number AD_TLNMBR CHAR 30 0
TEL_EXTENS Telephone no.: Extension AD_TLXTNS CHAR 10 0
FAX_NUMBER Fax number: dialling code+number AD_FXNMBR CHAR 30 0
FAX_EXTENS Fax no.: Extension AD_FXXTNS CHAR 10 0
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 BU_CURRID CUKY 5 0
CALL_RULEID Identification Rule for Periodic Appointments: Calling Hours BU_RULEID_C CHAR 25 0
VISIT_RULEID Identification Rule for Periodic Appointments:Visiting Hours BU_RULEID_V CHAR 25 0
CALL_GUID SAP BP: Calendar Schema GUID, Calling Hours BU_CALENDAR_SCHEME_CALL_GUID RAW 16 0
VISIT_GUID SAP BP: Calendar Schema GUID, Visiting Hours BU_CALENDAR_SCHEME_VISIT_GUID RAW 16 0
BP_EEW_BUT051 Dummy function in length 1 DUMMY CHAR 1 0
BP_EEW_BUT051_SP Dummy function in length 1 DUMMY CHAR 1 0

BUT051 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BUT051 ABTNR BUT051 ABTNR TB910 Contact Person Departments ABTNR
BUT051 ABTNR BUT051 CLIENT TB910 Contact Person Departments CLIENT
BUT051 CLIENT BUT051 CLIENT T000 Clients MANDT
BUT051 PAAUTH BUT051 CLIENT TB914 Contact person authority CLIENT
BUT051 PAAUTH BUT051 PAAUTH TB914 Contact person authority PAAUTH
BUT051 PAFKT BUT051 CLIENT TB912 Positions of contact persons CLIENT
BUT051 PAFKT BUT051 PAFKT TB912 Positions of contact persons PAFKT
BUT051 PAVIP BUT051 CLIENT TB916 Contact person VIP indicator CLIENT
BUT051 PAVIP BUT051 PAVIP TB916 Contact person VIP indicator PAVIP
BUT051 RELNR BUT051 PARTNER1 BUT050 BP relationships/role definitions: General data PARTNER1
BUT051 RELNR BUT051 PARTNER2 BUT050 BP relationships/role definitions: General data PARTNER2
BUT051 RELNR BUT051 DATE_TO BUT050 BP relationships/role definitions: General data DATE_TO
BUT051 RELNR BUT051 CLIENT BUT050 BP relationships/role definitions: General data CLIENT
BUT051 RELNR BUT051 RELNR BUT050 BP relationships/role definitions: General data RELNR
BUT051 RELTYP BUT051 CLIENT TBZ9 BP relationship categories CLIENT
BUT051 RELTYP BUT051 RELTYP TBZ9 BP relationship categories RELTYP
BUT051 RELTYP BUT051 XRF TBZ9 BP relationship categories XRF