SAP table BUT050 (BP relationships/role definitions: General data)
SAP table BUT050 has 5 primary key fields being CLIENT,RELNR,PARTNER1,PARTNER2,DATE_TO.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| RELNR | BP Relationship Number | CHAR | 12 | 0 | BU_RELNR | ||
| PARTNER1 | Business Partner Number | CHAR | 10 | 0 | BUT000 | BU_PARTNER | |
| PARTNER2 | Business Partner Number | CHAR | 10 | 0 | BUT000 | BU_PARTNER | |
| DATE_TO | Validity Date (Valid To) | DATS | 8 | 0 | BU_DATTO | ||
| DATE_FROM | Validity Date (Valid From) | DATS | 8 | 0 | BU_DATFROM | ||
| RELTYP | Business Partner Relationship Category | CHAR | 6 | 0 | * | BU_RELTYP | |
| XRF | Business partner role definition instead of BP relationship | CHAR | 1 | 0 | BU_XRF | ||
| DFTVAL | BP: Differentiation type characteristic (change doc.-rel.) | CHAR | 20 | 0 | BU_DFTVAL | ||
| RLTYP | Business partner role (change doc.-relevant) | CHAR | 6 | 0 | * | BU_RLTYPE | |
| RELKIND | Business partner relationship type | CHAR | 4 | 0 | * | BU_RELKIND | |
| CRUSR | User who created the object | CHAR | 12 | 0 | BU_CRUSR | ||
| CRDAT | Date on which the object was created | DATS | 8 | 0 | BU_CRDAT | ||
| CRTIM | Time at which the object was created | TIMS | 6 | 0 | BU_CRTIM | ||
| CHUSR | Last user to change object | CHAR | 12 | 0 | BU_CHUSR | ||
| CHDAT | Date when object was last changed | DATS | 8 | 0 | BU_CHDAT | ||
| CHTIM | Time at which object was last changed | TIMS | 6 | 0 | BU_CHTIM | ||
| XDFREL | Standard Relationship | CHAR | 1 | 0 | BU_XDFREL | ||
| XDFREL2 | Standard Relationship | CHAR | 1 | 0 | BU_XDFREL | ||
| DB_KEY | GP: UUID for Identifying the Data Record (SETGUID) | RAW | 16 | 0 | BUP_SETGUID | ||
| DB_KEY_TD | GP: UUID for Identifying the Data Record (SETGUID) | RAW | 16 | 0 | BUP_SETGUID |
BUT050 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BUT050 | CLIENT | T000 | Clients | MANDT |
| 1 BUT050 | PARTNER1 | BUT000 | BP: General data I | PARTNER |
| 0 BUT050 | PARTNER2 | BUT000 | BP: General data I | PARTNER |