SAP Table BUT0ID
BP: ID Numbers
BUT0ID (BP: ID Numbers) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link BUT0ID to other SAP tables.
BUT0ID table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT | 3 | 0 | |||
| PARTNER | Business Partner Number | BU_PARTNER | BUT000 | CHAR | 10 | 0 | ||
| TYPE | Identification Type | BU_ID_TYPE | TB039A | CHAR | 6 | 0 | ||
| IDNUMBER | Identification Number | BU_ID_NUMBER | CHAR | 60 | 0 | |||
| INSTITUTE | Responsible Institution for ID Number | BU_ID_INSTITUTE | CHAR | 40 | 0 | |||
| ENTRY_DATE | Date of Entry for ID Number | BU_ID_ENTRY_DATE | DATS | 8 | 0 | |||
| VALID_DATE_FROM | Validity Start for ID Number | BU_ID_VALID_DATE_FROM | DATS | 8 | 0 | |||
| VALID_DATE_TO | Validity End for ID Number | BU_ID_VALID_DATE_TO | DATS | 8 | 0 | |||
| COUNTRY | Country in Which ID Number is Valid or Was Assigned | BU_IDCOUNTRY | T005 | CHAR | 3 | 0 | ||
| REGION | Region (State, Province, County) | REGIO | T005S | CHAR | 3 | 0 | ||
| IDNUMBER_GUID | GUID of a Business Partner Identification Number | BU_ID_GUID | RAW | 16 | 0 | |||
| BP_EEW_BUT0ID | Dummy function in length 1 | DUMMY | CHAR | 1 | 0 | |||
BUT0ID foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| BUT0ID | COUNTRY | SYST | MANDT | T005 | Countries | MANDT |
| BUT0ID | COUNTRY | BUT0ID | COUNTRY | T005 | Countries | LAND1 |
| BUT0ID | PARTNER | BUT0ID | CLIENT | BUT000 | BP: General data I | CLIENT |
| BUT0ID | PARTNER | BUT0ID | PARTNER | BUT000 | BP: General data I | PARTNER |
| BUT0ID | REGION | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
| BUT0ID | REGION | GT_BUT0ID | COUNTRY | T005S | Taxes: Region (Province) Key | LAND1 |
| BUT0ID | REGION | BUT0ID | REGION | T005S | Taxes: Region (Province) Key | BLAND |
| BUT0ID | TYPE | BUT0ID | CLIENT | TB039A | BP ID Types | CLIENT |
| BUT0ID | TYPE | BUT0ID | TYPE | TB039A | BP ID Types | TYPE |
