The BUT0TP table in SAP ERP or S/4HANA stores SAP BP: Template Assignments data. There are total 6 fields in BUT0TP table. The SAP BP: Template Assignments table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of BUT0TP table. It is in Business Partner Templates (BUPA_TFW) ABAP package and is part of the SAP Business Partner (AP-MD-BP) module.
SAP BUT0TP Table Fields
Following is the list of fields that are available in SAP BUT0TP table. The primary key fields of the table are CLIENT (Client), PARTNERGUID (Business Partner GUID), TEMPL_TYPE (BP Template Type), VALID_TO (Validity End of a Template Assignment to the BP).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| PARTNERGUID | Business Partner GUID | BU_PARTNER_GUID | RAW (16) | |
| TEMPL_TYPE | BP Template Type | BU_TEMPL_TYPE | TFW_TPTYPE | CHAR (20) |
| VALID_TO | Validity End of a Template Assignment to the BP | BU_TEMPL_VALID_TO | DEC (15) | |
| VALID_FROM | Validity Start of a Template Assignment to the BP | BU_TEMPL_VALID_FROM | DEC (15) | |
| TEMPL_ID | BP Template ID | BU_TEMPL_ID | CHAR (10) |
