I_MKT_INTERACTIONALLCUBE

CDS View

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)

ViewTypeJoinVDMDescription
C_MKT_InteractionAllQuery view_entity from CONSUMPTION Interaction: Consumption View

Fields (43)

KeyField CDS FieldsUsed 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)
);