I_ADDRESSEMAILADDRESS

CDS View
6 Fields 4 CDS Views

Email Address

I_ADDRESSEMAILADDRESS is a CDS View in S/4HANA. Email Address. It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
/SCMTMS/CV_LocQuByPhysAdd view left_outer Helper View for Query By Phys. Address
A_AddressEmailAddress view from BASIC Email Address
A_BPContactWorkPlaceEmailAddr view inner BASIC BP Contact Work Place Email Address
I_ElectronicDocCockpitSuplrEml view inner COMPOSITE Electronic Document: Supplier and Email

Fields (6)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID 1
KEY OrdinalNumber OrdinalNumber 3
KEY Person Person 2
EmailAddress email_uri,EmailAddress 4
IsDefaultEmailAddress IsDefaultEmailAddress 2
SearchEmailAddress SearchEmailAddress 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.

-- Email Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDRESSEMAILADDRESS (
    ADDRESSID,
    ORDINALNUMBER,
    PERSON,
    EMAILADDRESS,
    ISDEFAULTEMAILADDRESS,
    SEARCHEMAILADDRESS,
    PRIMARY KEY (ADDRESSID, ORDINALNUMBER, PERSON)
);

Learn More