p_apj_job_run_exe

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_exe.
-- 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_EXE
-- Parameters: p_jobcount : btcjobcnt

CREATE VIEW p_apj_job_run_exe AS
SELECT
  job_name,
  job.stepcount AS step_count,
  report,
  variant,
  job.exitcode AS app_rc,
  spool,
  $parameters.p_jobcount AS jobcount,
  cast( 1 as abap.int4 ) AS stepcount
FROM apj_d_job_exe
LEFT OUTER JOIN tbtcp AS job ON apj_d_job_exe.job_name = job.jobname AND job.jobcount = $parameters.p_jobcount AND job.stepcount = 1  -- association [0..1]
LEFT OUTER JOIN APJ_V_JCE_UNION AS jce ON apj_d_job_exe.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_exe.job_name AND spool.jobcount = $parameters.p_jobcount AND spool.stepcount = 1  -- association [0..1]
;