FCCX_V_TASK_EXEC_M

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 FCCX_V_TASK_EXEC_M.
-- 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: FCCX_V_TSK_M

CREATE VIEW FCCX_V_TASK_EXEC_M AS
SELECT
  b.msguuid AS msguuid,
  a.execuuid AS execuuid,
  a.task_uuid AS task_uuid,
  a.taskc AS taskc,
  a.bttype AS bttype,
  a.programname AS programname,
  a.variant_id AS variant_id,
  a.job_name AS job_name,
  a.job_count AS job_count,
  a.old_sched AS old_sched,
  b.created_on AS created_on,
  b.created_by AS created_by,
  a.strtdate AS strtdate,
  a.strttime AS strttime,
  a.enddate AS enddate,
  a.endtime AS endtime,
  a.job_status AS job_status,
  b.result_type AS result_type,
  b.result_uuid AS result_uuid,
  b.lognumber AS lognumber,
  b.object AS object,
  b.subobject AS subobject,
  b.msgty AS msgty,
  b.msgid AS msgid,
  b.msgno AS msgno,
  b.msgv1 AS msgv1,
  b.msgv2 AS msgv2,
  b.msgv3 AS msgv3,
  b.msgv4 AS msgv4,
  b.message AS message,
  b.bukrs AS bukrs,
  b.kokrs AS kokrs,
  b.werks AS werks,
  b.cgrop AS cgrop,
  b.cunit AS cunit
FROM FCCX_V_TASK_EXEC_ANALYZE AS a
LEFT OUTER JOIN fccx_task_exec_m AS b ON /* join condition not captured in parsed metadata */
;