SAP Table CMS_STR_BP_BUT050
Business Partner details fetched from BUT050- BP Relations
CMS_STR_BP_BUT050 (Business Partner details fetched from BUT050- BP Relations) 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 CMS_STR_BP_BUT050 to other SAP tables.
CMS_STR_BP_BUT050 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | 0 | |||||||
| 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 | |||||||
CMS_STR_BP_BUT050 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| CMS_STR_BP_BUT050 | CLIENT | CMS_STR_BP_BUT050 | CLIENT | T000 | Clients | MANDT |
| CMS_STR_BP_BUT050 | PARTNER1 | CMS_STR_BP_BUT050 | CLIENT | BUT000 | BP: General data I | CLIENT |
| CMS_STR_BP_BUT050 | PARTNER1 | CMS_STR_BP_BUT050 | PARTNER1 | BUT000 | BP: General data I | PARTNER |
| CMS_STR_BP_BUT050 | PARTNER2 | CMS_STR_BP_BUT050 | CLIENT | BUT000 | BP: General data I | CLIENT |
| CMS_STR_BP_BUT050 | PARTNER2 | CMS_STR_BP_BUT050 | PARTNER2 | BUT000 | BP: General data I | PARTNER |
