CUAN_CPG_TPL_TRIGGER

DDL: CUAN_CPG_TPL_TRIGGER SQL: CUAN_TPLTRIGGER Type: view Package: CUAN_CDS_CAMPAIGN_TEMPLATE

Query by Elements

CUAN_CPG_TPL_TRIGGER is a CDS View that provides data about "Query by Elements" in SAP S/4HANA. It reads from 1 data source (cuan_d_tpl_tr) and exposes 11 fields with key field db_key. Part of development package CUAN_CDS_CAMPAIGN_TEMPLATE.

Data Sources (1)

SourceAliasJoin Type
cuan_d_tpl_tr cuan_d_tpl_tr from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CUAN_TPLTRIGGER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Query by Elements view
ObjectModel.representativeKey db_key view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

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
ref_node_key cuan_d_tpl_tr ref_node_key NodeID
is_inactive cuan_d_tpl_tr is_inactive
active_from cuan_d_tpl_tr active_from Active from
is_changed cuan_d_tpl_tr is_changed Definition changed
mkt_area_id _MKT_TPL_ROOT mkt_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.
-- SQL view name: CUAN_TPLTRIGGER

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,
  cuan_d_tpl_tr.ref_node_key AS ref_node_key,
  cuan_d_tpl_tr.is_inactive AS is_inactive,
  cuan_d_tpl_tr.active_from AS active_from,
  cuan_d_tpl_tr.is_changed AS is_changed,
  _MKT_TPL_ROOT.mkt_area_id AS mkt_area_id,
  _MKT_TPL_ORCH.initiative_id AS campaign_id
FROM cuan_d_tpl_tr
;