BUT0ID is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores BP: ID Numbers data. There are total 12 fields in the table. The BUT0ID table can be found in the SAP Business Partner: Basic Components (S_BUPA_GENERAL) package and is part of the Business Partner Foundation (BC-SRV-BP) module.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
BUT0ID Table Fields
The following is the list of fields that are available in SAP BUT0ID table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type | Length |
|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | * | CLNT | 3 |
| PARTNER | Business Partner Number | BU_PARTNER | BU_PARTNER | BUT000 | CHAR | 10 |
| TYPE | Identification Type | BU_ID_TYPE | BU_ID_TYPE | TB039A | CHAR | 6 |
| IDNUMBER | Identification Number | BU_ID_NUMBER | CHAR60 | CHAR | 60 | |
| INSTITUTE | Responsible Institution for ID Number | BU_ID_INSTITUTE | TEXT40 | CHAR | 40 | |
| ENTRY_DATE | Date of Entry for ID Number | BU_ID_ENTRY_DATE | DATUM | DATS | 8 | |
| VALID_DATE_FROM | Validity Start for ID Number | BU_ID_VALID_DATE_FROM | DATUM | DATS | 8 | |
| VALID_DATE_TO | Validity End for ID Number | BU_ID_VALID_DATE_TO | DATUM | DATS | 8 | |
| COUNTRY | Country in Which ID Number is Valid or Was Assigned | BU_IDCOUNTRY | LAND1 | T005 | CHAR | 3 |
| REGION | Region (State, Province, County) | REGIO | REGIO | T005S | CHAR | 3 |
| IDNUMBER_GUID | GUID of a Business Partner Identification Number | BU_ID_GUID | SYSUUID | RAW | 16 | |
| BP_EEW_BUT0ID | Dummy function in length 1 | DUMMY | DUMMY | CHAR | 1 |
Availability
The SAP HANA table BUT0ID is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Released |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for BUT0ID table
We’re updating the content all the time, so check back regularly.
