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