C_WhiteListCommMedium

DDL: C_WHITELISTCOMMMEDIUM SQL: CWHITELISTCOMMME Type: view CONSUMPTION Package: CUAN_CDS_OUTBOUND_FLTR
7 Fields 1 Data Sources 1 Associations

Campaign Execution Inclusion List

C_WhiteListCommMedium is a Consumption CDS View that provides data about "Campaign Execution Inclusion List" in SAP S/4HANA. It reads from 1 data source (I_WhiteListCommMedium) and exposes 7 fields with key field WhiteListEntry. It has 1 association to related views. Part of development package CUAN_CDS_OUTBOUND_FLTR.

Data Sources (1)

SourceAliasJoin Type
I_WhiteListCommMedium Item from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CommType _CommunicationMedium $projection.CommunicationMediumType = _CommunicationMedium.CommunicationMedium

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CWHITELISTCOMMME view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Campaign Execution Inclusion List view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
OData.publish true view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
Search.searchable true view
UI.presentationVariant.sortOrder.by CommunicationMediumType view
UI.headerInfo.typeNamePlural Inclusion Entries view
UI.headerInfo.typeName Inclusion Entry view
UI.headerInfo.title.label Campaign Execution Inclusion List view
UI.headerInfo.title.value WhiteListEntryCommData view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY WhiteListEntry I_WhiteListCommMedium WhiteListEntry NodeID
CommunicationMediumType I_WhiteListCommMedium CommunicationMediumType
CommunicationMediumName
WhiteListEntryCommData
EmailAddress I_WhiteListCommMedium EmailAddress E-Mail Address
MobilePhoneNumber I_WhiteListCommMedium MobilePhoneNumber Telephone
_CommunicationMedium _CommunicationMedium

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_WhiteListCommMedium.
-- 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.
-- SQL view name: CWHITELISTCOMMME

CREATE VIEW C_WhiteListCommMedium AS
SELECT
  Item.WhiteListEntry AS WhiteListEntry,
  Item.CommunicationMediumType AS CommunicationMediumType,
  Item._CommunicationMedium._Text[1:Language = $session.system_language].CommunicationMediumName AS CommunicationMediumName,
  cast (Item.WhiteListEntryCommData as cuan_mkt_whitelist_commdata) AS WhiteListEntryCommData,
  Item.EmailAddress AS EmailAddress,
  Item.MobilePhoneNumber AS MobilePhoneNumber
FROM I_WhiteListCommMedium AS Item
LEFT OUTER JOIN I_CommType AS _CommunicationMedium ON CommunicationMediumType = _CommunicationMedium.CommunicationMedium  -- association [0..1]
;

Learn More