The BUT050 table in SAP ERP or S/4HANA stores BP relationships/role definitions: General data data. There are total 21 fields in BUT050 table. The BP relationships/role definitions: General data 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 BUT050 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 BUT050 Table Fields
Following is the list of fields that are available in SAP BUT050 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 | CHAR (12) | |
| PARTNER1 | Business Partner Number | BU_PARTNER | BUT000 | CHAR (10) |
| PARTNER2 | Business Partner Number | BU_PARTNER | BUT000 | CHAR (10) |
| DATE_TO | Validity Date (Valid To) | BU_DATTO | DATS (8) | |
| DATE_FROM | Validity Date (Valid From) | BU_DATFROM | DATS (8) | |
| RELTYP | Business Partner Relationship Category | BU_RELTYP | * | CHAR (6) |
| XRF | Business partner role definition instead of BP relationship | BU_XRF | CHAR (1) | |
| DFTVAL | BP: Differentiation type characteristic (change doc.-rel.) | BU_DFTVAL | CHAR (20) | |
| RLTYP | Business partner role (change doc.-relevant) | BU_RLTYPE | * | CHAR (6) |
| RELKIND | Business partner relationship type | BU_RELKIND | * | CHAR (4) |
| CRUSR | User who created the object | BU_CRUSR | CHAR (12) | |
| CRDAT | Date on which the object was created | BU_CRDAT | DATS (8) | |
| CRTIM | Time at which the object was created | BU_CRTIM | TIMS (6) | |
| CHUSR | Last user to change object | BU_CHUSR | CHAR (12) | |
| CHDAT | Date when object was last changed | BU_CHDAT | DATS (8) | |
| CHTIM | Time at which object was last changed | BU_CHTIM | TIMS (6) | |
| XDFREL | Standard Relationship | BU_XDFREL | CHAR (1) | |
| XDFREL2 | Standard Relationship | BU_XDFREL | CHAR (1) | |
| DB_KEY | GP: UUID for Identifying the Data Record (SETGUID) | BUP_SETGUID | RAW (16) | |
| DB_KEY_TD | GP: UUID for Identifying the Data Record (SETGUID) | BUP_SETGUID | RAW (16) |
