CUAN_LI_TRG_RES

DDL: CUAN_LI_TRG_RES Type: view_entity
11 Fields 2 Data Sources

Campaign Execution: Trigger Result

CUAN_LI_TRG_RES is a CDS View that provides data about "Campaign Execution: Trigger Result" in SAP S/4HANA. It reads from 2 data sources (cuan_d_mktorc_tr, cuand_cpg_trgres) and exposes 11 fields with key fields RT_KEY, TR_KEY, IA_KEY.

Data Sources (2)

SourceAliasJoin Type
cuan_d_mktorc_tr TR from
cuand_cpg_trgres TRGRES inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Campaign Execution: Trigger Result view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY RT_KEY RT db_key UUID
KEY TR_KEY cuan_d_mktorc_tr db_key UUID
KEY IA_KEY cuand_cpg_trgres cmpgntrggrrsltrefuuid NodeID
TR_IS_NON_EVENT cuan_d_mktorc_tr is_non_event
TR_TRIGGER_TYPE cuan_d_mktorc_tr trigger_type
TR_ORDINAL_NUMBER cuan_d_mktorc_tr ordinal_number Ordinal Number
RT_SCHEDULE_DATE_TIME RT schedule_date_time Time Stamp
RT_INITIATIVE_ID RT initiative_id
RT_INITIATIVE_VERSION RT initiative_version
RT_LIFE_CYCLE_STATUS RT life_cycle_status Life Cycle
PARENT_IA_KEY cuand_cpg_trgres cmpgntrggrrsltprecdguuid NodeID

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_LI_TRG_RES.
-- 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_LI_TRG_RES AS
SELECT
  RT.db_key AS RT_KEY,
  TR.db_key AS TR_KEY,
  TRGRES.cmpgntrggrrsltrefuuid AS IA_KEY,
  TR.is_non_event AS TR_IS_NON_EVENT,
  TR.trigger_type AS TR_TRIGGER_TYPE,
  TR.ordinal_number AS TR_ORDINAL_NUMBER,
  RT.schedule_date_time AS RT_SCHEDULE_DATE_TIME,
  RT.initiative_id AS RT_INITIATIVE_ID,
  RT.initiative_version AS RT_INITIATIVE_VERSION,
  RT.life_cycle_status AS RT_LIFE_CYCLE_STATUS,
  TRGRES.cmpgntrggrrsltprecdguuid AS PARENT_IA_KEY
FROM cuan_d_mktorc_tr AS TR
INNER JOIN cuand_cpg_trgres AS TRGRES ON /* join condition not captured in parsed metadata */
;

Learn More