The BUT100 table in SAP ERP or S/4HANA stores BP: Roles data. There are total 8 fields in BUT100 table. The BP: Roles 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 BUT100 table. It is in SAP Business Partner: Basic Components (S_BUPA_GENERAL) ABAP package and is part of the Business Partner Foundation (BC-SRV-BP) module.
SAP BUT100 Table Fields
Following is the list of fields that are available in SAP BUT100 table. The primary key fields of the table are MANDT (Client), PARTNER (Business Partner Number), RLTYP (BP Role), DFVAL (BP: Differentiation type value).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| PARTNER | Business Partner Number | BU_PARTNER | BUT000 | CHAR (10) |
| RLTYP | BP Role | BU_PARTNERROLE | TB003 | CHAR (6) |
| DFVAL | BP: Differentiation type value | BU_DFVAL | CHAR (20) | |
| VALID_FROM | Validity Start of a BP Role | BU_ROLE_VALID_FROM | DEC (15) | |
| VALID_TO | Validity End of a BP Role | BU_ROLE_VALID_TO | DEC (15) | |
| ROLE | Business Partner Role Type | BP_ROLE | TPZ6 | CHAR (4) |
| AUTHORITY | Authorization Group | BEGRU | CHAR (4) |
