I_BPADDLCUSTEMAILADDRESSTP

CDS View
8 Fields 1 CDS Views

BO view for email for MLTAS customers

I_BPADDLCUSTEMAILADDRESSTP is a CDS View in S/4HANA. BO view for email for MLTAS customers. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BPAddlCustEmailAddress view from CONSUMPTION C view for email address of mlt customer

Fields (8)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY BusinessPartner BusinessPartner 1
KEY Customer Customer 1
KEY OrdinalNumber OrdinalNumber 1
AddressCommunicationRemarkText AddressCommunicationRemarkText 1
EmailAddress EmailAddress 1
IsDefaultEmailAddress IsDefaultEmailAddress 1
IsHomeEmailAddress IsHomeEmailAddress 1

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.

-- BO view for email for MLTAS customers
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPADDLCUSTEMAILADDRESSTP (
    ADDRESSID,
    BUSINESSPARTNER,
    CUSTOMER,
    ORDINALNUMBER,
    ADDRESSCOMMUNICATIONREMARKTEXT,
    EMAILADDRESS,
    ISDEFAULTEMAILADDRESS,
    ISHOMEEMAILADDRESS,
    PRIMARY KEY (ADDRESSID, BUSINESSPARTNER, CUSTOMER, ORDINALNUMBER)
);

Learn More