I_MKT_INTERACTIONALLCUBE
Interaction (CUBE)
I_MKT_INTERACTIONALLCUBE is a CDS View in S/4HANA. Interaction (CUBE). It contains 43 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MKT_InteractionAllQuery | view_entity | from | CONSUMPTION | Interaction: Consumption View |
Fields (43)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InteractionUUID | InteractionUUID | 1 |
| BounceReason | BounceReason | 1 | |
| BounceReasonName | BounceReasonName | 1 | |
| CampaignContentLink | CampaignContentLink | 1 | |
| CampaignContentLinkName | CampaignContentLinkName | 1 | |
| CampaignExecutionRun | CampaignExecutionRun | 1 | |
| CampaignID | CampaignID | 1 | |
| CommunicationArea | CommunicationArea | 1 | |
| Currency | Currency | 1 | |
| DeviceType | DeviceType | 1 | |
| ImportHeaderUUID | ImportHeaderUUID | 1 | |
| InteractionAmount | InteractionAmount | 1 | |
| InteractionContactId | InteractionContactId | 1 | |
| InteractionContactType | InteractionContactType | 1 | |
| InteractionContactUUID | InteractionContactUUID | 1 | |
| InteractionContentSubject | InteractionContentSubject | 1 | |
| InteractionCreationUTCDateTime | InteractionCreationUTCDateTime | 1 | |
| InteractionDeviceName | InteractionDeviceName | 1 | |
| InteractionDirection | InteractionDirection | 1 | |
| InteractionLanguage | InteractionLanguage | 1 | |
| InteractionLastChangedByUser | InteractionLastChangedByUser | 1 | |
| InteractionLastChangedDateTime | InteractionLastChangedDateTime | 1 | |
| InteractionLatitude | InteractionLatitude | 1 | |
| InteractionLongitude | InteractionLongitude | 1 | |
| InteractionOperatingSystemName | InteractionOperatingSystemName | 1 | |
| InteractionReason | InteractionReason | 1 | |
| InteractionSoftwareClientName | InteractionSoftwareClientName | 1 | |
| InteractionSourceObject | InteractionSourceObject | 1 | |
| InteractionSourceObjectAddlID | InteractionSourceObjectAddlID | 1 | |
| InteractionSourceObjectStatus | InteractionSourceObjectStatus | 1 | |
| InteractionSourceObjectType | InteractionSourceObjectType | 1 | |
| InteractionSourceTimeStampUTC | InteractionSourceTimeStampUTC | 1 | |
| InteractionStatus | InteractionStatus | 1 | |
| InteractionTimeStampUTC | InteractionTimeStampUTC | 1 | |
| InteractionWeightingFactor | InteractionWeightingFactor | 1 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| MarketingOrchestrationID | MarketingOrchestrationID | 1 | |
| PrecedingInteractionUUID | PrecedingInteractionUUID | 1 | |
| ReferencedOrgStructure | ReferencedOrgStructure | 1 | |
| RootInteraction | RootInteraction | 1 | |
| SourceSystem | SourceSystem | 1 | |
| SourceSystemType | SourceSystemType | 1 | |
| SpatialReferenceSystem | SpatialReferenceSystem | 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.
-- Interaction (CUBE)
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MKT_INTERACTIONALLCUBE (
INTERACTIONUUID,
BOUNCEREASON,
BOUNCEREASONNAME,
CAMPAIGNCONTENTLINK,
CAMPAIGNCONTENTLINKNAME,
CAMPAIGNEXECUTIONRUN,
CAMPAIGNID,
COMMUNICATIONAREA,
CURRENCY,
DEVICETYPE,
IMPORTHEADERUUID,
INTERACTIONAMOUNT,
INTERACTIONCONTACTID,
INTERACTIONCONTACTTYPE,
INTERACTIONCONTACTUUID,
INTERACTIONCONTENTSUBJECT,
INTERACTIONCREATIONUTCDATETIME,
INTERACTIONDEVICENAME,
INTERACTIONDIRECTION,
INTERACTIONLANGUAGE,
INTERACTIONLASTCHANGEDBYUSER,
INTERACTIONLASTCHANGEDDATETIME,
INTERACTIONLATITUDE,
INTERACTIONLONGITUDE,
INTERACTIONOPERATINGSYSTEMNAME,
INTERACTIONREASON,
INTERACTIONSOFTWARECLIENTNAME,
INTERACTIONSOURCEOBJECT,
INTERACTIONSOURCEOBJECTADDLID,
INTERACTIONSOURCEOBJECTSTATUS,
INTERACTIONSOURCEOBJECTTYPE,
INTERACTIONSOURCETIMESTAMPUTC,
INTERACTIONSTATUS,
INTERACTIONTIMESTAMPUTC,
INTERACTIONWEIGHTINGFACTOR,
ISMARKEDFORDELETION,
MARKETINGORCHESTRATIONID,
PRECEDINGINTERACTIONUUID,
REFERENCEDORGSTRUCTURE,
ROOTINTERACTION,
SOURCESYSTEM,
SOURCESYSTEMTYPE,
SPATIALREFERENCESYSTEM,
PRIMARY KEY (INTERACTIONUUID)
);
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