I_MKT_INTACTNCNTCTSCOREVAL
Scores of Interaction Contacts
I_MKT_INTACTNCNTCTSCOREVAL is a CDS View in S/4HANA. Scores of Interaction Contacts. It contains 17 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_MKT_CorpAcctMktgScoreCube | view | from | COMPOSITE | Mktg: Scores of Corporate Accnts - Cube |
| I_MKT_MarketingScoreCube | view | from | COMPOSITE | Mktg: Scores of Interaction Contacts - Cube |
Fields (17)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InteractionContact | InteractionContact | 1 |
| KEY | MarketingScoreUUID | MarketingScoreUUID | 1 |
| KEY | MktgScoreVersion | MktgScoreVersion | 2 |
| _MKT_CalendarDate | _MKT_CalendarDate | 2 | |
| _Mkt_Contact | _Mkt_Contact | 2 | |
| _MKT_CorporateAccount | _MKT_CorporateAccount | 1 | |
| _MKT_IntactnCntctMktgArea | _MKT_IntactnCntctMktgArea | 2 | |
| _MKT_MarketingScore | _MKT_MarketingScore | 2 | |
| _MKT_MarketingScoreModel | _MKT_MarketingScoreModel | 2 | |
| _MKT_MktgScoreValueCategory | _MKT_MktgScoreValueCategory | 1 | |
| InteractionContactOrigin | InteractionContactOrigin | 2 | |
| MarketingScoreValue | SumMarketingScoreValue | 2 | |
| MktgScoreIsCurrentVersion | MktgScoreIsCurrentVersion | 2 | |
| MktgScoreValueCategory | MktgScoreValueCategory | 2 | |
| MktgScoreVersionDate | MktgScoreVersionDate | 2 | |
| PredictiveModelUUID | PredictiveModelUUID | 2 | |
| PredictiveScenario | PredictiveScenario | 2 |
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.
-- Scores of Interaction Contacts
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MKT_INTACTNCNTCTSCOREVAL (
INTERACTIONCONTACT,
MARKETINGSCOREUUID,
MKTGSCOREVERSION,
_MKT_CALENDARDATE,
_MKT_CONTACT,
_MKT_CORPORATEACCOUNT,
_MKT_INTACTNCNTCTMKTGAREA,
_MKT_MARKETINGSCORE,
_MKT_MARKETINGSCOREMODEL,
_MKT_MKTGSCOREVALUECATEGORY,
INTERACTIONCONTACTORIGIN,
MARKETINGSCOREVALUE,
MKTGSCOREISCURRENTVERSION,
MKTGSCOREVALUECATEGORY,
MKTGSCOREVERSIONDATE,
PREDICTIVEMODELUUID,
PREDICTIVESCENARIO,
PRIMARY KEY (INTERACTIONCONTACT, MARKETINGSCOREUUID, MKTGSCOREVERSION)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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