I_IBCINTERACTION

CDS View
39 Fields 11 CDS Views

Interaction

I_IBCINTERACTION is a CDS View in S/4HANA. Interaction. It contains 39 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_IBCIntactnDetInteraction view_entity from CONSUMPTION Interaction root for interaction details
C_IBCInteractionSegmentation view_entity from CONSUMPTION Interaction for Segmentation
C_IBCOutbInteractionMessage view_entity from CONSUMPTION Outbound Interaction Message
I_IBCBouncedMessage view_entity from COMPOSITE Bounced Message
I_IBCClickThroughMessage view_entity from COMPOSITE Click Through Message
I_IBCComplaintMessage view_entity from COMPOSITE Complaint Message
I_IBCDeliveredMessage view_entity from COMPOSITE Delivered Message
I_IBCRejectedMessage view_entity from COMPOSITE Failed Message
I_IBCSentMessage view_entity from COMPOSITE Sent Message
P_IBCRELSHPPROJTNCNTCTINTACTN view_entity from CONSUMPTION
P_IBCRELSHPPROJTNCNTCTINTACTN view_entity inner CONSUMPTION

Fields (39)

KeyField CDS FieldsUsed in Views
KEY CommunicationFlow CommunicationFlow 7
KEY InteractionUUID InteractionUUID 2
BounceReason BounceReason 1
BounceReasonName BounceReasonName 1
CommunicationArea CommunicationArea 2
CommunicationMedium CommunicationMedium 1
CommunicationMessageLinkName CommunicationMessageLinkName 1
CommunicationMessageLinkURL CommunicationMessageLinkURL 1
CommunicationPattern CommunicationPattern 1
Currency InteractionCurrency 1
DeviceType DeviceType 1
InteractionAmount InteractionAmount 1
InteractionChannel InteractionChannel 1
InteractionContactId InteractionContactId 1
InteractionContactOrigin InteractionContactOrigin 1
InteractionContactUUID InteractionContactUUID,RelatedInteractionContactUUID 2
InteractionCreationUTCDateTime InteractionCreationUTCDateTime 1
InteractionDeviceName InteractionDeviceName 1
InteractionLastChangedByUser InteractionLastChangedByUser 1
InteractionLastChangedDateTime InteractionLastChangedDateTime 1
InteractionLatitude InteractionLatitude 1
InteractionLongitude InteractionLongitude 1
InteractionOperatingSystemName InteractionOperatingSystemName 1
InteractionReason InteractionReason 1
InteractionSoftwareClientName InteractionSoftwareClientName 1
InteractionSourceDataURL InteractionSourceDataURL 1
InteractionSourceObject InteractionSourceObject 1
InteractionSourceObjectAddlID InteractionSourceObjectAddlID 1
InteractionSourceObjectStatus InteractionSourceObjectStatus 1
InteractionSourceObjectType InteractionSourceObjectType 1
InteractionSourceTimeStampUTC InteractionSourceTimeStampUTC 1
InteractionTimeStampUTC InteractionTimeStampUTC 1
InteractionType InteractionType 1
InteractionWeightingFactor InteractionWeightingFactor 1
PrecedingInteractionUUID PrecedingInteractionUUID 1
ReferencedOrgStructure ReferencedOrgStructure 2
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
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_IBCINTERACTION (
    COMMUNICATIONFLOW,
    INTERACTIONUUID,
    BOUNCEREASON,
    BOUNCEREASONNAME,
    COMMUNICATIONAREA,
    COMMUNICATIONMEDIUM,
    COMMUNICATIONMESSAGELINKNAME,
    COMMUNICATIONMESSAGELINKURL,
    COMMUNICATIONPATTERN,
    CURRENCY,
    DEVICETYPE,
    INTERACTIONAMOUNT,
    INTERACTIONCHANNEL,
    INTERACTIONCONTACTID,
    INTERACTIONCONTACTORIGIN,
    INTERACTIONCONTACTUUID,
    INTERACTIONCREATIONUTCDATETIME,
    INTERACTIONDEVICENAME,
    INTERACTIONLASTCHANGEDBYUSER,
    INTERACTIONLASTCHANGEDDATETIME,
    INTERACTIONLATITUDE,
    INTERACTIONLONGITUDE,
    INTERACTIONOPERATINGSYSTEMNAME,
    INTERACTIONREASON,
    INTERACTIONSOFTWARECLIENTNAME,
    INTERACTIONSOURCEDATAURL,
    INTERACTIONSOURCEOBJECT,
    INTERACTIONSOURCEOBJECTADDLID,
    INTERACTIONSOURCEOBJECTSTATUS,
    INTERACTIONSOURCEOBJECTTYPE,
    INTERACTIONSOURCETIMESTAMPUTC,
    INTERACTIONTIMESTAMPUTC,
    INTERACTIONTYPE,
    INTERACTIONWEIGHTINGFACTOR,
    PRECEDINGINTERACTIONUUID,
    REFERENCEDORGSTRUCTURE,
    SOURCESYSTEM,
    SOURCESYSTEMTYPE,
    SPATIALREFERENCESYSTEM,
    PRIMARY KEY (COMMUNICATIONFLOW, INTERACTIONUUID)
);

Learn More