CONTACT

CONTACT is an SAP database table in S/4HANA. It contains 10 fields.

Fields (10)

KeyField CDS FieldsUsed in Views
KEY BusinessPartnerPerson BusinessPartnerPerson 1
KEY SourcingProjectUUID SourcingProjectUUID 1
BusinessPartnerUUID BusinessPartnerUUID 1
EmailAddress EmailAddress 1
FirstName FirstName 1
LastName LastName 1
PhoneNumber PhoneNumber 1
UserID UserID 1
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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CONTACT (
    BUSINESSPARTNERPERSON,
    SOURCINGPROJECTUUID,
    BUSINESSPARTNERUUID,
    EMAILADDRESS,
    FIRSTNAME,
    LASTNAME,
    PHONENUMBER,
    USERID,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    PRIMARY KEY (BUSINESSPARTNERPERSON, SOURCINGPROJECTUUID)
);