The BUPA_ID_D table in SAP ERP or S/4HANA stores I_BUSINESSPARTNERTP I_BUPAIDENTIFICATIONTP data. There are total 23 fields in BUPA_ID_D table. The I_BUSINESSPARTNERTP I_BUPAIDENTIFICATIONTP 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 BUPA_ID_D table. It is in VDM Master Data BP (VDM_MD_BP) ABAP package and is part of the Business Partners (LO-MD-BP) module.
SAP BUPA_ID_D Table Fields
Following is the list of fields that are available in SAP BUPA_ID_D table. The primary key fields of the table are MANDT (Client), DRAFTUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| BUSINESSPARTNER | Business Partner Number | BU_PARTNER | CHAR (10) | |
| BPIDENTIFICATIONNUMBER | Identification Number | BU_ID_NUMBER | CHAR (60) | |
| BPIDENTIFICATIONTYPE | Identification Type | BU_ID_TYPE | CHAR (6) | |
| BUSINESSPARTNERFOREDIT | Business Partner Number | BU_PARTNER | CHAR (10) | |
| BPIDENTIFICATIONNUMBERFOREDIT | Identification Number | BU_ID_NUMBER | CHAR (60) | |
| BPIDENTIFICATIONTYPEFOREDIT | Identification Type | BU_ID_TYPE | CHAR (6) | |
| AUTHORIZATIONGROUP | Authorization Group | BU_AUGRP | CHAR (4) | |
| BPIDENTIFICATIONENTRYDATE | Date of Entry for ID Number | BU_ID_ENTRY_DATE | DATS (8) | |
| BPIDNNMBRISSUINGINSTITUTE | Responsible Institution for ID Number | BU_ID_INSTITUTE | CHAR (40) | |
| COUNTRY | Country in Which ID Number is Valid or Was Assigned | BU_IDCOUNTRY | CHAR (3) | |
| REGION | Region (State, Province, County) | REGIO | CHAR (3) | |
| VALIDITYENDDATE | Validity End for ID Number | BU_ID_VALID_DATE_TO | DATS (8) | |
| VALIDITYSTARTDATE | Validity Start for ID Number | BU_ID_VALID_DATE_FROM | DATS (8) | |
| BUSINESSPARTNERCATEGORY | Business Partner Category | BU_TYPE | CHAR (1) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
