The BUT051 table in SAP ERP or S/4HANA stores BP Relationship: Contact Person Relationship data. There are total 28 fields in BUT051 table. The BP Relationship: Contact Person Relationship table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BUT051 table. It is in SAP Business Partner: Basic Components (S_BUPA_GENERAL) ABAP package and is part of the Business Partner Foundation (BC-SRV-BP) module.
SAP BUT051 Table Fields
Following is the list of fields that are available in SAP BUT051 table. The primary key fields of the table are CLIENT (Client), RELNR (BP Relationship Number), PARTNER1 (Business Partner Number), PARTNER2 (Business Partner Number), DATE_TO (Validity Date (Valid To)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| RELNR | BP Relationship Number | BU_RELNR | BUT050 | CHAR (12) |
| PARTNER1 | Business Partner Number | BU_PARTNER | * | CHAR (10) |
| PARTNER2 | Business Partner Number | BU_PARTNER | * | CHAR (10) |
| DATE_TO | Validity Date (Valid To) | BU_DATTO | DATS (8) | |
| RELTYP | Business Partner Relationship Category | BU_RELTYP | TBZ9 | CHAR (6) |
| XRF | Business partner role definition instead of BP relationship | BU_XRF | CHAR (1) | |
| FNCTN | Function name of partner | BU_FNCTN | CHAR (40) | |
| PAFKT | Function of partner | BU_PAFKT | TB912 | CHAR (4) |
| DPRTMNT | Department at business partner | BU_DPRTMNT | CHAR (40) | |
| ABTNR | Department | BU_ABTNR | TB910 | CHAR (4) |
| PAAUTH | Partner’s Authority | BU_PAAUTH | TB914 | CHAR (1) |
| PAVIP | VIP Partner | BU_PAVIP | TB916 | CHAR (1) |
| PAREM | Notes for Partner | BU_PAREM | CHAR (40) | |
| TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR (30) | |
| TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR (10) | |
| FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR (30) | |
| FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR (10) | |
| SMTP_ADDRESS | E-Mail Address | AD_SMTPADR | CHAR (241) | |
| REL_PER | Obsolete: Percentage of Capital Interest | BU_REL_PER | DEC (10) | |
| REL_AMO | Obsolete: Amount of Capital Interest | BU_REL_AMO | CURR (13) | |
| REL_CUR | Currency Key | BU_CURRID | * | CUKY (5) |
| CALL_RULEID | Identification Rule for Periodic Appointments: Calling Hours | BU_RULEID_C | CHAR (25) | |
| VISIT_RULEID | Identification Rule for Periodic Appointments:Visiting Hours | BU_RULEID_V | CHAR (25) | |
| CALL_GUID | SAP BP: Calendar Schema GUID, Calling Hours | BU_CALENDAR_SCHEME_CALL_GUID | RAW (16) | |
| VISIT_GUID | SAP BP: Calendar Schema GUID, Visiting Hours | BU_CALENDAR_SCHEME_VISIT_GUID | RAW (16) | |
| BP_EEW_BUT051 | Dummy function in length 1 | DUMMY | CHAR (1) | |
| BP_EEW_BUT051_SP | Dummy function in length 1 | DUMMY | CHAR (1) |
