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