C_IBCInteractionSegmentation

DDL: C_IBCINTERACTIONSEGMENTATION Type: view_entity CONSUMPTION
48 Fields 1 Data Sources 3 Associations

Interaction for Segmentation

C_IBCInteractionSegmentation (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_IBCInteractionSegmentation is a Consumption CDS View that provides data about "Interaction for Segmentation" in SAP S/4HANA. It reads from 1 data source (I_IBCInteraction) and exposes 48 fields with key field InteractionUUID. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentCA-IBC-PRF
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_IBCInteraction Interaction from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_IBCInteractionType _InteractonType $projection.InteractionType = _InteractonType.InteractionType
[0..1] I_Language _Language Interaction.InteractionLanguage = _Language.Language
[1..1] E_IBCInteraction _Extension Interaction.InteractionUUID = _Extension.InteractionUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Interaction for Segmentation view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY InteractionUUID I_IBCInteraction InteractionUUID Interaction for CDS Views
InteractionContactOrigin I_IBCInteraction InteractionContactOrigin Origin of Interaction Contact Data
InteractionContactId I_IBCInteraction InteractionContactId External ID of Interaction Contact Data
CommunicationMedium I_IBCInteraction CommunicationMedium Communication Medium
InteractionType I_IBCInteraction InteractionType Interaction Type
InteractionTimeStampUTC I_IBCInteraction InteractionTimeStampUTC UTC Timestamp for API-Services
InteractionSourceObjectType I_IBCInteraction InteractionSourceObjectType Source Object Type
InteractionSourceObject I_IBCInteraction InteractionSourceObject Source Object ID for API-Service
CommunicationArea I_IBCInteraction CommunicationArea Communication Area ID
ReferencedOrgStructure I_IBCInteraction ReferencedOrgStructure Source Organization
CommunicationFlow I_IBCInteraction CommunicationFlow Communication Flow ID
InteractionWeightingFactor I_IBCInteraction InteractionWeightingFactor Interaction Quantifier
InteractionReason I_IBCInteraction InteractionReason Interaction Reason
BounceReason I_IBCInteraction BounceReason Bounce Reason
BounceReasonName I_IBCInteraction BounceReasonName Description of Bounce Reason
InteractionLanguageISO _Language LanguageISOCode 2-Character SAP Language Code
InteractionAmount I_IBCInteraction InteractionAmount Value Amount
InteractionCurrency I_IBCInteraction Currency Valuation Crcy
GeoCoordinatesUnit Unit of Measure
InteractionLatitude I_IBCInteraction InteractionLatitude Latitude
InteractionLongitude I_IBCInteraction InteractionLongitude Longitude
SpatialReferenceSystem I_IBCInteraction SpatialReferenceSystem Spatial Reference Identifier
DeviceType I_IBCInteraction DeviceType Device Type
InteractionDeviceName I_IBCInteraction InteractionDeviceName Device
InteractionSoftwareClientName I_IBCInteraction InteractionSoftwareClientName Software Client
InteractionOperatingSystemName I_IBCInteraction InteractionOperatingSystemName Operating System
PrecedingInteractionUUID I_IBCInteraction PrecedingInteractionUUID Preceding Interaction for CDS Views
SourceSystemType I_IBCInteraction SourceSystemType Interaction Source System Type
SourceSystem I_IBCInteraction SourceSystem Interaction Source System ID
InteractionSourceObjectAddlID I_IBCInteraction InteractionSourceObjectAddlID Additional Source Object ID for API-Service
InteractionSourceObjectStatus I_IBCInteraction InteractionSourceObjectStatus Business Document Status Code
InteractionSourceDataURL I_IBCInteraction InteractionSourceDataURL
InteractionSourceTimeStampUTC I_IBCInteraction InteractionSourceTimeStampUTC Source UTC Timestamp in Long Form
CommunicationMessageLinkURL I_IBCInteraction CommunicationMessageLinkURL
CommunicationMessageLinkName I_IBCInteraction CommunicationMessageLinkName Message Link Name
InteractionContactUUID I_IBCInteraction InteractionContactUUID Interaction Contact DB Key
CommunicationPattern I_IBCInteraction CommunicationPattern Communication Pattern ID
InteractionCreationUTCDateTime I_IBCInteraction InteractionCreationUTCDateTime Date and Time of Interaction Creation
InteractionLastChangedDateTime I_IBCInteraction InteractionLastChangedDateTime Last Change Date Time for API-Service
InteractionLastChangedByUser I_IBCInteraction InteractionLastChangedByUser User Name
InteractionChannel I_IBCInteraction InteractionChannel Interaction Channel
InteractionTypeName Description of Interaction Type
InteractionReasonName Description of Interaction Reason
InteractionChannelName Description of Interaction Channel
InteractionContactOriginName Description for Origin of Interaction Contact Data
CommunicationMediumName Description of Communication Medium
CommunicationFlowName Communication Flow Name
_AuthCommArea _AuthCommArea

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_IBCInteractionSegmentation.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_IBCInteractionSegmentation AS
SELECT
  Interaction.InteractionUUID AS InteractionUUID,
  Interaction.InteractionContactOrigin AS InteractionContactOrigin,
  Interaction.InteractionContactId AS InteractionContactId,
  Interaction.CommunicationMedium AS CommunicationMedium,
  Interaction.InteractionType AS InteractionType,
  Interaction.InteractionTimeStampUTC AS InteractionTimeStampUTC,
  Interaction.InteractionSourceObjectType AS InteractionSourceObjectType,
  Interaction.InteractionSourceObject AS InteractionSourceObject,
  Interaction.CommunicationArea AS CommunicationArea,
  Interaction.ReferencedOrgStructure AS ReferencedOrgStructure,
  Interaction.CommunicationFlow AS CommunicationFlow,
  Interaction.InteractionWeightingFactor AS InteractionWeightingFactor,
  Interaction.InteractionReason AS InteractionReason,
  Interaction.BounceReason AS BounceReason,
  Interaction.BounceReasonName AS BounceReasonName,
  _Language.LanguageISOCode AS InteractionLanguageISO,
  Interaction.InteractionAmount AS InteractionAmount,
  Interaction.Currency AS InteractionCurrency,
  cast('DEG' as msehiunit) AS GeoCoordinatesUnit,
  Interaction.InteractionLatitude AS InteractionLatitude,
  Interaction.InteractionLongitude AS InteractionLongitude,
  Interaction.SpatialReferenceSystem AS SpatialReferenceSystem,
  Interaction.DeviceType AS DeviceType,
  Interaction.InteractionDeviceName AS InteractionDeviceName,
  Interaction.InteractionSoftwareClientName AS InteractionSoftwareClientName,
  Interaction.InteractionOperatingSystemName AS InteractionOperatingSystemName,
  Interaction.PrecedingInteractionUUID AS PrecedingInteractionUUID,
  Interaction.SourceSystemType AS SourceSystemType,
  Interaction.SourceSystem AS SourceSystem,
  Interaction.InteractionSourceObjectAddlID AS InteractionSourceObjectAddlID,
  Interaction.InteractionSourceObjectStatus AS InteractionSourceObjectStatus,
  Interaction.InteractionSourceDataURL AS InteractionSourceDataURL,
  Interaction.InteractionSourceTimeStampUTC AS InteractionSourceTimeStampUTC,
  Interaction.CommunicationMessageLinkURL AS CommunicationMessageLinkURL,
  Interaction.CommunicationMessageLinkName AS CommunicationMessageLinkName,
  Interaction.InteractionContactUUID AS InteractionContactUUID,
  Interaction.CommunicationPattern AS CommunicationPattern,
  Interaction.InteractionCreationUTCDateTime AS InteractionCreationUTCDateTime,
  Interaction.InteractionLastChangedDateTime AS InteractionLastChangedDateTime,
  Interaction.InteractionLastChangedByUser AS InteractionLastChangedByUser,
  Interaction.InteractionChannel AS InteractionChannel,
  _InteractonType._Text[1: Language=$session.system_language].InteractionTypeName AS InteractionTypeName,
  _InteractionReason._Text[1: Language=$session.system_language].InteractionReasonName AS InteractionReasonName,
  _Channel._Text[1: Language=$session.system_language].InteractionChannelName AS InteractionChannelName,
  _ContactOrigin._Text[1: Language=$session.system_language].InteractionContactOriginName AS InteractionContactOriginName,
  _CommMedium._Text[1: Language=$session.system_language].CommunicationMediumName AS CommunicationMediumName,
  Interaction._CommunicationFlow.CommunicationFlowName AS CommunicationFlowName
FROM I_IBCInteraction AS Interaction
LEFT OUTER JOIN I_IBCInteractionType AS _InteractonType ON InteractionType = _InteractonType.InteractionType  -- association [1..1]
LEFT OUTER JOIN I_Language AS _Language ON Interaction.InteractionLanguage = _Language.Language  -- association [0..1]
LEFT OUTER JOIN E_IBCInteraction AS _Extension ON Interaction.InteractionUUID = _Extension.InteractionUUID  -- association [1..1]
;

Learn More