I_ADDRESSEMAILADDRESS

CDS View
6 Fields 5 CDS Views

Email Address

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

CDS Views using this table (5)

ViewTypeJoinVDMDescription
/SCMTMS/CV_LocQuByPhysAdd view left_outer Obsolete: Use CDS View /SCMTMS/VE_LocQuByPhysAdd
A_AddressEmailAddress view from BASIC Email Address
A_BPContactPersonEmlAddr view_entity inner BASIC Contact Person 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 4
KEY Person Person 2
EmailAddress email_uri,EmailAddress 5
IsDefaultEmailAddress IsDefaultEmailAddress 3
SearchEmailAddress SearchEmailAddress 3

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