I_BPEMAILADDRESS

CDS View

Business Partner Email Core View

I_BPEMAILADDRESS is a CDS View in S/4HANA. Business Partner Email Core View. It contains 5 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_BPAddlCustEmailAddressTP view from TRANSACTIONAL BO view for email for MLTAS customers
I_BPAddlSuplrEmailAddressTP view from TRANSACTIONAL BO view for email for MLTAS suppliers
I_BPEmailAddressTP view from TRANSACTIONAL Business Partner Email BO view
I_BusPartEmailAddressGov view_entity union_all BASIC BP Email Address
I_BusPartEmailAddressTP_2 view_entity from TRANSACTIONAL Transactional View For I_BusPartEmailAddress

Fields (5)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 2
KEY OrdinalNumber OrdinalNumber 2
EmailAddress EmailAddress 2
IsDefaultEmailAddress IsDefaultEmailAddress 2
IsHomeEmailAddress IsHomeEmailAddress 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Business Partner Email Core View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPEMAILADDRESS (
    ADDRESSID,
    ORDINALNUMBER,
    EMAILADDRESS,
    ISDEFAULTEMAILADDRESS,
    ISHOMEEMAILADDRESS,
    PRIMARY KEY (ADDRESSID, ORDINALNUMBER)
);