CUAN_CPG_TRIGGER_COND_SEARCH

DDL: CUAN_CPG_TRIGGER_COND_SEARCH Type: view_entity
8 Fields 1 Data Sources

Comm Flow Trigger Condition Search

CUAN_CPG_TRIGGER_COND_SEARCH is a CDS View that provides data about "Comm Flow Trigger Condition Search" in SAP S/4HANA. It reads from 1 data source (cuan_d_mktorc_tc) and exposes 8 fields with key field db_key.

Data Sources (1)

SourceAliasJoin Type
cuan_d_mktorc_tc cuan_d_mktorc_tc from

Annotations (6)

NameValueLevelField
ObjectModel.representativeKey DB_KEY view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Comm Flow Trigger Condition Search view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY db_key cuan_d_mktorc_tc db_key UUID
root_key cuan_d_mktorc_tc root_key UUID
parent_key cuan_d_mktorc_tc parent_key UUID
sign cuan_d_mktorc_tc sign Type of SIGN component in row type of a Ranges type
opt cuan_d_mktorc_tc option Type of OPTION component in row type of a Ranges type
low cuan_d_mktorc_tc low Value from
high cuan_d_mktorc_tc high Value up to
comm_area_id _MKT_ORC_RT comm_area_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_TRIGGER_COND_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_CPG_TRIGGER_COND_SEARCH AS
SELECT
  cuan_d_mktorc_tc.db_key AS db_key,
  cuan_d_mktorc_tc.root_key AS root_key,
  cuan_d_mktorc_tc.parent_key AS parent_key,
  cuan_d_mktorc_tc.sign AS sign,
  cuan_d_mktorc_tc.option AS opt,
  cuan_d_mktorc_tc.low AS low,
  cuan_d_mktorc_tc.high AS high,
  _MKT_ORC_RT.comm_area_id AS comm_area_id
FROM cuan_d_mktorc_tc
;

Learn More