XAJ_JOB_RUN_CHAIN

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 XAJ_JOB_RUN_CHAIN.
-- 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: XAJ_JRUN_CHAIN

CREATE VIEW XAJ_JOB_RUN_CHAIN AS
SELECT
  apj_d_job_chn.job_name AS job_name,
  job.jobcount AS jobcount,
  job.stepcount AS step_count,
  job.progname AS report,
  job.variant AS variant,
  job.exitcode AS app_rc,
  spool,
  apj_d_job_chn.step_count AS stepcount
FROM apj_d_job_chn
INNER JOIN tbtcp AS job ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN apj_d_jr_info AS jr_info ON apj_d_job_chn.job_name = jr_info.job_name AND jr_info.job_count = job.jobcount AND apj_d_job_chn.step_count = jr_info.job_step_count  -- association [0..1]
LEFT OUTER JOIN APJ_V_JCE_UNION AS jce ON apj_d_job_chn.job_catalog_entry = jce.job_catalog_entry_name AND jce.job_catalog_entry_version = '0'  -- association [1]
LEFT OUTER JOIN Apj_V_Spool_Exists_W_SC AS spool ON spool.jobname = apj_d_job_chn.job_name AND spool.jobcount = job.jobcount AND spool.stepcount = apj_d_job_chn.step_count  -- association [0..1]
;