SAP Table BUT054
BP Relationship (not used yet)
BUT054 (BP Relationship (not used yet)) 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 BUT054 to other SAP tables.
Source: BUT054 (BP Relationship (not used yet))
BUT054 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| RELNR | BP Relationship Number | BU_RELNR | BUT050 | CHAR | 12 | 0 | ||||||
| PARTNER1 | Business Partner Number | BU_PARTNER | CHAR | 10 | 0 | |||||||
| PARTNER2 | Business Partner Number | BU_PARTNER | CHAR | 10 | 0 | |||||||
| DATE_TO | Validity Date (Valid To) | BU_DATTO | DATS | 8 | 0 | |||||||
| RELTYP | Business Partner Relationship Category | BU_RELTYP | TBZ9 | CHAR | 6 | 0 | ||||||
| XRF | Business partner role definition instead of BP relationship | BU_XRF | CHAR | 1 | 0 |
Possible values
|
||||||
| PRTSHP_PART_PER | Capital Interest Percentage in a Company | BU_PRTNRSHP_PART_PER | DEC | 10 | 7 | |||||||
| PRTSHP_PART_AMO | Capital Interest Amount in a Company | BU_PRTNRSHP_PART_AMO | CURR | 13 | 2 | |||||||
| PRTSHP_PART_CUR | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||||||
BUT054 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BUT054 | CLIENT | BUT054 | CLIENT | T000 | Clients | MANDT |
| BUT054 | PRTSHP_PART_CUR | SYST | MANDT | TCURC | Currency Codes | MANDT |
| BUT054 | PRTSHP_PART_CUR | BUT054 | PRTSHP_PART_CUR | TCURC | Currency Codes | WAERS |
| BUT054 | RELNR | BUT054 | CLIENT | BUT050 | BP relationships/role definitions: General data | CLIENT |
| BUT054 | RELNR | BUT054 | RELNR | BUT050 | BP relationships/role definitions: General data | RELNR |
| BUT054 | RELNR | BUT054 | PARTNER1 | BUT050 | BP relationships/role definitions: General data | PARTNER1 |
| BUT054 | RELNR | BUT054 | PARTNER2 | BUT050 | BP relationships/role definitions: General data | PARTNER2 |
| BUT054 | RELNR | BUT054 | DATE_TO | BUT050 | BP relationships/role definitions: General data | DATE_TO |
| BUT054 | RELTYP | SYST | MANDT | TBZ9 | BP relationship categories | CLIENT |
| BUT054 | RELTYP | BUT054 | RELTYP | TBZ9 | BP relationship categories | RELTYP |
| BUT054 | RELTYP | BUT054 | XRF | TBZ9 | BP relationship categories | XRF |
