Fields (21)
| Key | Field | CDS Fields | Used 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
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA