I_MKT_CampaignExecutionRun

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 I_MKT_CampaignExecutionRun.
-- 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 I_MKT_CampaignExecutionRun AS
SELECT
  cast ( cuan_d_mktorc_er.db_key as cuan_campaign_exec_run preserving type ) AS CampaignExecutionRun,
  cast(cuan_d_mktorc_er.parent_key as cuan_cpg_autom_action_uuid preserving type) AS CampaignAutomationActionUUID,
  cast (cuan_d_mktorc_er.execution_start_date_time as cuan_exec_date_time_utc preserving type) AS ExecutionRunDateTime,
  cast(cuan_d_mktorc_er.planned_start_date_time as cuan_mce_exec_run_plnd_dtime preserving type ) AS CampaignExecRunPlndStrtDteTme,
  cast(cuan_d_mktorc_er.execution_finish_date_time as cuan_mce_execrunfinish_dtime preserving type ) AS CampaignExecRunFinishedDteTme,
  cast(cuan_d_mktorc_er.status as cuan_mce_execrun_status preserving type ) AS CampaignExecRunStatus,
  cast(cuan_d_mktorc_er.job_id as cuan_mce_execrunapplicationjob preserving type ) AS ApplicationJob,
  cast(cuan_d_mktorc_er.target_group_member_count as cuan_mce_numberoftgmembers preserving type ) AS NumberOfTargetGroupMembers,
  cast(cuan_d_mktorc_er.target_group_rebuild_job_id as cuan_mce_tgtgrprebuildappljob preserving type ) AS TgtGrpRebuildApplicationJob,
  _MKT_CampaignAutomationAction.CampaignAutomationAction AS CampaignAutomationAction,
  _INI_ROOT.mkt_area_id AS MarketingArea,
  cast(_INI_ROOT.db_key as cuan_campaign_uuid preserving type ) AS Campaign,
  _INI_ROOT.id AS CampaignID,
  cast (tstmp_to_dats( cuan_d_mktorc_er.execution_start_date_time, 'UTC', $session.client, 'INITIAL' ) as cuan_exec_date_utc) AS CampaignExecutionRunDate
FROM cuan_d_mktorc_er
LEFT OUTER JOIN I_MKT_CampaignAutomationAction AS _MKT_CampaignAutomationAction ON CampaignAutomationActionUUID = _MKT_CampaignAutomationAction.CampaignAutomationActionUUID  -- association [0..1]
;