FCCX_V_TASK_EXEC_R_BAL

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_R_BAL.
-- 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_R

CREATE VIEW FCCX_V_TASK_EXEC_R_BAL AS
SELECT
  b.resultuuid AS resultuuid,
  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.log_id AS log_id,
  h.object AS object,
  h.subobject AS subobject,
  h.log_handle AS log_handle,
  h.extnumber AS extnumber,
  h.lognumber AS lognumber,
  h.aldate AS aldate,
  h.altime AS altime,
  h.aluser AS aluser,
  h.msg_cnt_al AS msg_cnt_al,
  h.msg_cnt_a AS msg_cnt_a,
  h.msg_cnt_i AS msg_cnt_i,
  h.msg_cnt_e AS msg_cnt_e,
  h.msg_cnt_w AS msg_cnt_w,
  h.msg_cnt_s AS msg_cnt_s,
  h.probclass AS probclass,
  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
INNER JOIN fccx_task_exec_r AS b ON /* join condition not captured in parsed metadata */
INNER JOIN balhdr AS h ON /* join condition not captured in parsed metadata */
;