The BUT0ID table in SAP ERP or S/4HANA stores BP: ID Numbers data. There are total 12 fields in BUT0ID table. The BP: ID Numbers 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 BUT0ID 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 BUT0ID Table Fields
Following is the list of fields that are available in SAP BUT0ID table. The primary key fields of the table are CLIENT (Client), PARTNER (Business Partner Number), TYPE (Identification Type), IDNUMBER (Identification Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | * | CLNT (3) |
| PARTNER | Business Partner Number | BU_PARTNER | BUT000 | CHAR (10) |
| TYPE | Identification Type | BU_ID_TYPE | TB039A | CHAR (6) |
| IDNUMBER | Identification Number | BU_ID_NUMBER | CHAR (60) | |
| INSTITUTE | Responsible Institution for ID Number | BU_ID_INSTITUTE | CHAR (40) | |
| ENTRY_DATE | Date of Entry for ID Number | BU_ID_ENTRY_DATE | DATS (8) | |
| VALID_DATE_FROM | Validity Start for ID Number | BU_ID_VALID_DATE_FROM | DATS (8) | |
| VALID_DATE_TO | Validity End for ID Number | BU_ID_VALID_DATE_TO | DATS (8) | |
| COUNTRY | Country in Which ID Number is Valid or Was Assigned | BU_IDCOUNTRY | T005 | CHAR (3) |
| REGION | Region (State, Province, County) | REGIO | T005S | CHAR (3) |
| IDNUMBER_GUID | GUID of a Business Partner Identification Number | BU_ID_GUID | RAW (16) | |
| BP_EEW_BUT0ID | Dummy function in length 1 | DUMMY | CHAR (1) |
