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.