I_ADDRESSEMAILADDRESS_2

CDS View
9 Fields 8 CDS Views

Email Address

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

CDS Views using this table (8)

ViewTypeJoinVDMDescription
/SCMTMS/VE_LocQuByPhysAdd view_entity left_outer BOPF: Location Query By Physical Address
I_AddrCurDefaultEmailAddress view_entity from BASIC Current Default Email Address
I_BPAddressIndependentEmail view from BASIC Root View for Address Independent Email for BP app
I_BPContactEmlAddrTP view inner TRANSACTIONAL TP View BP Contact Person Email Address
I_BPEmailAddress view from BASIC Business Partner Email Core View
I_BPRelshpCntctPersnEmlAddrTP view_entity inner TRANSACTIONAL RAP BO Contact Person Email Address
R_AddressEmailAddressTP view_entity from Email Address - TP
R_EmailAddressTP view_entity from TRANSACTIONAL Email Address - TP

Fields (9)

KeyField CDS FieldsUsed in Views
KEY AddressID AddressID,AddressIDForEdit 2
KEY AddressPersonID Person 2
KEY CommMediumSequenceNumber OrdinalNumber,OrdinalNumberForEdit 4
_AddressCommunicationRemark _AddressCommunicationRemark 1
CommLineNotForUnsolicitedCntct CommNumberIsNotUsed 2
EmailAddress email_uri,EmailAddress 5
EmailAddressIsCurrentDefault IsDefaultEmailAddress 4
ValidityEndDate ValidityEndDate 1
ValidityStartDate ValidityStartDate 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.

-- Email Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_ADDRESSEMAILADDRESS_2 (
    ADDRESSID,
    ADDRESSPERSONID,
    COMMMEDIUMSEQUENCENUMBER,
    _ADDRESSCOMMUNICATIONREMARK,
    COMMLINENOTFORUNSOLICITEDCNTCT,
    EMAILADDRESS,
    EMAILADDRESSISCURRENTDEFAULT,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (ADDRESSID, ADDRESSPERSONID, COMMMEDIUMSEQUENCENUMBER)
);

Learn More