SAP table BUT0ID (BP: ID Numbers)
SAP table BUT0ID has 4 primary key fields being CLIENT,PARTNER,TYPE,IDNUMBER.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | MANDT | ||
| PARTNER | Business Partner Number | CHAR | 10 | 0 | BUT000 | BU_PARTNER | |
| TYPE | Identification Type | CHAR | 6 | 0 | TB039A | BU_ID_TYPE | |
| IDNUMBER | Identification Number | CHAR | 60 | 0 | BU_ID_NUMBER | ||
| INSTITUTE | Responsible Institution for ID Number | CHAR | 40 | 0 | BU_ID_INSTITUTE | ||
| ENTRY_DATE | Date of Entry for ID Number | DATS | 8 | 0 | BU_ID_ENTRY_DATE | ||
| VALID_DATE_FROM | Validity Start for ID Number | DATS | 8 | 0 | BU_ID_VALID_DATE_FROM | ||
| VALID_DATE_TO | Validity End for ID Number | DATS | 8 | 0 | BU_ID_VALID_DATE_TO | ||
| COUNTRY | Country/Region in Which ID Number is Valid or Was Assigned | CHAR | 3 | 0 | T005 | BU_IDCOUNTRY | |
| REGION | Region (State, Province, County) | CHAR | 3 | 0 | T005S | REGIO | |
| IDNUMBER_GUID | GUID of a Business Partner Identification Number | RAW | 16 | 0 | BU_ID_GUID | ||
| BP_EEW_BUT0ID | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY |
BUT0ID foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 BUT0ID | COUNTRY | T005 | Countries | MANDT |
| 0 BUT0ID | COUNTRY | T005 | Countries | LAND1 |
| 1 BUT0ID | PARTNER | BUT000 | BP: General data I | PARTNER |
| 0 BUT0ID | REGION | T005S | Taxes: Region (Province) Key | LAND1 |
| 1 BUT0ID | TYPE | TB039A | BP ID Types | TYPE |