CUAN_CPG_TPL_TRIGGER

DDL: CUAN_CPG_TPL_TRIGGER Type: view_entity
7 Fields 1 Data Sources

Communication Flow Template Trigger

CUAN_CPG_TPL_TRIGGER is a CDS View that provides data about "Communication Flow Template Trigger" in SAP S/4HANA. It reads from 1 data source (cuan_d_tpl_tr) and exposes 7 fields with key field db_key.

Data Sources (1)

SourceAliasJoin Type
cuan_d_tpl_tr cuan_d_tpl_tr from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Communication Flow Template Trigger view
ObjectModel.representativeKey db_key view
Analytics.technicalName CUAN_TPLTRIGGER view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY db_key cuan_d_tpl_tr db_key UUID
parent_key cuan_d_tpl_tr parent_key UUID
root_key cuan_d_tpl_tr root_key UUID
trigger_type cuan_d_tpl_tr trigger_type
is_non_event cuan_d_tpl_tr is_non_event
comm_area_id _MKT_TPL_ROOT comm_area_id
campaign_id _MKT_TPL_ORCH initiative_id

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_CPG_TPL_TRIGGER.
-- 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_CPG_TPL_TRIGGER AS
SELECT
  cuan_d_tpl_tr.db_key AS db_key,
  cuan_d_tpl_tr.parent_key AS parent_key,
  cuan_d_tpl_tr.root_key AS root_key,
  cuan_d_tpl_tr.trigger_type AS trigger_type,
  cuan_d_tpl_tr.is_non_event AS is_non_event,
  _MKT_TPL_ROOT.comm_area_id AS comm_area_id,
  _MKT_TPL_ORCH.initiative_id AS campaign_id
FROM cuan_d_tpl_tr
;

Learn More