I_IBCINTERACTION
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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
- 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