_MKT_CONTACT

_MKT_CONTACT is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
_Language _Language 1
_MKT_Country _MKT_Country 12
_MKT_Department _MKT_Department 1
_MKT_Function _MKT_Function 1
_MKT_Gender _MKT_Gender 5
_MKT_Industry _MKT_Industry 2
_MKT_Marital _MKT_Marital 1
_MKT_Region _MKT_Region 5
_MKT_ValidationStatus _MKT_ValidationStatus 1
AddressRegion AddressRegion 3
CompanyName CompanyName 1
Country Country 23
CountryFreeText CountryFreeText 1
FirstName FirstName 1
FullName FullName,Name 6
GenderCode GenderCode 2
Industry Industry 1
InteractionContactType InteractionContactType 8
LastName LastName 1
PersonFullName PersonFullName 1
ValidationStatus ValidationStatus 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 _MKT_CONTACT (
    _LANGUAGE,
    _MKT_COUNTRY,
    _MKT_DEPARTMENT,
    _MKT_FUNCTION,
    _MKT_GENDER,
    _MKT_INDUSTRY,
    _MKT_MARITAL,
    _MKT_REGION,
    _MKT_VALIDATIONSTATUS,
    ADDRESSREGION,
    COMPANYNAME,
    COUNTRY,
    COUNTRYFREETEXT,
    FIRSTNAME,
    FULLNAME,
    GENDERCODE,
    INDUSTRY,
    INTERACTIONCONTACTTYPE,
    LASTNAME,
    PERSONFULLNAME,
    VALIDATIONSTATUS
);