p_apj_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 p_apj_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: P_APJ_JR_CHAIN
-- Parameters: p_jobcount : btcjobcnt

CREATE VIEW p_apj_job_run_chain AS
SELECT
  job_name,
  coalesce( job.stepcount, step_count ) AS step_count,
  coalesce( job.progname, report ) AS report,
  coalesce( job.variant, variant ) AS variant,
  job.exitcode AS app_rc,
  spool,
  $parameters.p_jobcount AS jobcount,
  apj_d_job_chn.step_count AS stepcount
FROM apj_d_job_chn
LEFT OUTER JOIN tbtcp AS job ON apj_d_job_chn.job_name = job.jobname AND job.jobcount = $parameters.p_jobcount AND apj_d_job_chn.step_count = job.stepcount  -- association [0..1]
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 = $parameters.p_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 = $parameters.p_jobcount AND spool.stepcount = apj_d_job_chn.step_count  -- association [0..1]
;