The BUPA_EMAIL_D table in SAP ERP or S/4HANA stores I_BUSINESSPARTNERTP I_BPEMAILADDRESSTP data. There are total 17 fields in BUPA_EMAIL_D table. The I_BUSINESSPARTNERTP I_BPEMAILADDRESSTP 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_EMAIL_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_EMAIL_D Table Fields
Following is the list of fields that are available in SAP BUPA_EMAIL_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) | |
| ROOTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| BUSINESSPARTNER | Business Partner Number | BU_PARTNER | CHAR (10) | |
| ADDRESSID | Address Number | AD_ADDRNUM | CHAR (10) | |
| ORDINALNUMBER | Sequence Number | AD_CONSNUM | NUMC (3) | |
| ISDEFAULTEMAILADDRESS | Flag: this address is the default address | AD_FLGDFAD | CHAR (1) | |
| EMAILADDRESS | E-Mail Address | AD_SMTPADR | CHAR (241) | |
| ISHOMEEMAILADDRESS | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | CHAR (1) | |
| ADDRESSCOMMUNICATIONREMARKTEXT | Communication link notes | AD_REMARK2 | CHAR (50) | |
| 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) |
