CUAN_MKTCAL_CAMPAIGN_SEARCH

DDL: CUAN_MKTCAL_CAMPAIGN_SEARCH Type: view_entity
18 Fields 1 Data Sources

Communication Flow Calendar Search

CUAN_MKTCAL_CAMPAIGN_SEARCH is a CDS View that provides data about "Communication Flow Calendar Search" in SAP S/4HANA. It reads from 1 data source (I_IBCCommunicationFlow) and exposes 18 fields with key field DB_KEY.

Data Sources (1)

SourceAliasJoin Type
I_IBCCommunicationFlow I_IBCCommunicationFlow from

Annotations (7)

NameValueLevelField
EndUserText.label Communication Flow Calendar Search view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DB_KEY I_IBCCommunicationFlow CommunicationFlowUUID
ID I_IBCCommunicationFlow CommunicationFlow
NAME I_IBCCommunicationFlow CommunicationFlowName
DESCRIPTION I_IBCCommunicationFlow CommunicationFlowDescription
START_DATE I_IBCCommunicationFlow CommunicationFlowStartDate
END_DATE I_IBCCommunicationFlow CommunicationFlowEndDate
LIFE_CYCLE_STATUS I_IBCCommunicationFlow CommFlowLifecycleStatus
LIFE_CYCLE_STATUS_T
CREA_UNAME_ID
CREA_UNAME_PERSON_NAME
CREA_DATE_TIME I_IBCCommunicationFlow CommFlowCreationDateTime
LCHG_UNAME_ID
LCHG_UNAME_PERSON_NAME
LCHG_DATE_TIME I_IBCCommunicationFlow CommFlowLastChangedDateTime
COMM_AREA_ID I_IBCCommunicationFlow CommunicationArea
COMM_AREA_ID_T
REF_ORG_STRUCT I_IBCCommunicationFlow ReferencedOrgStructure
_AuthCommArea I_IBCCommunicationFlow _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 CUAN_MKTCAL_CAMPAIGN_SEARCH.
-- 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 CUAN_MKTCAL_CAMPAIGN_SEARCH AS
SELECT
  I_IBCCommunicationFlow.CommunicationFlowUUID AS DB_KEY,
  I_IBCCommunicationFlow.CommunicationFlow AS ID,
  I_IBCCommunicationFlow.CommunicationFlowName AS NAME,
  I_IBCCommunicationFlow.CommunicationFlowDescription AS DESCRIPTION,
  I_IBCCommunicationFlow.CommunicationFlowStartDate AS START_DATE,
  I_IBCCommunicationFlow.CommunicationFlowEndDate AS END_DATE,
  I_IBCCommunicationFlow.CommFlowLifecycleStatus AS LIFE_CYCLE_STATUS,
  I_IBCCommunicationFlow._IBCCommFlowLifeCycleStatus._Text[1: Language = $session.system_language ].CommFlowLifecycleStatusName AS LIFE_CYCLE_STATUS_T,
  cast( I_IBCCommunicationFlow._IBCCommFlowCreatedByUser.UserID as xubname preserving type ) AS CREA_UNAME_ID,
  I_IBCCommunicationFlow._IBCCommFlowCreatedByUser._UserAddress._PersonName.PersonFullName AS CREA_UNAME_PERSON_NAME,
  I_IBCCommunicationFlow.CommFlowCreationDateTime AS CREA_DATE_TIME,
  cast( I_IBCCommunicationFlow._IBCCommFlowLastChangedByUser.UserID as xubname preserving type ) AS LCHG_UNAME_ID,
  I_IBCCommunicationFlow._IBCCommFlowLastChangedByUser._UserAddress._PersonName.PersonFullName AS LCHG_UNAME_PERSON_NAME,
  I_IBCCommunicationFlow.CommFlowLastChangedDateTime AS LCHG_DATE_TIME,
  I_IBCCommunicationFlow.CommunicationArea AS COMM_AREA_ID,
  I_IBCCommunicationFlow._CommunicationArea._Text[1: Language = $session.system_language ].CommunicationAreaName AS COMM_AREA_ID_T,
  I_IBCCommunicationFlow.ReferencedOrgStructure AS REF_ORG_STRUCT,
  I_IBCCommunicationFlow._AuthCommArea AS _AuthCommArea
FROM I_IBCCommunicationFlow
;

Learn More