XAJ_JOB_APPL_LOG_OVERVIEW

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_APPL_LOG_OVERVIEW.
-- 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_JOB_APP_LOG

CREATE VIEW XAJ_JOB_APPL_LOG_OVERVIEW AS
SELECT
  job_log.job_name AS job_name,
  job_log.job_count AS job_count,
  appl_log.log_handle AS log_handle,
  appl_log.lognumber AS lognumber,
  appl_log.extnumber AS extnumber,
  appl_log.object AS object,
  appl_log.obj_txt AS obj_txt,
  appl_log.subobject AS subobject,
  appl_log.subobj_txt AS subobj_txt,
  appl_log.msg_cnt_al AS msg_cnt_al,
  appl_log.alchdate AS alchdate,
  appl_log.alchtime AS alchtime,
  appl_log.alchuser AS alchuser,
  appl_log.aldate_del AS aldate_del,
  appl_log.msg_cnt_a AS msg_cnt_a,
  appl_log.msg_cnt_e AS msg_cnt_e,
  appl_log.msg_cnt_i AS msg_cnt_i,
  appl_log.msg_cnt_s AS msg_cnt_s,
  appl_log.msg_cnt_w AS msg_cnt_w,
  appl_log.aldate AS aldate,
  appl_log.altime AS altime,
  appl_log.aluser AS aluser,
  appl_log.severity AS severity,
  appl_log.SeverityText AS SeverityText
FROM APL_C_APPL_LOG_OVERVIEW AS appl_log
INNER JOIN XAJ_JOB_LOG AS job_log ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN XAJ_JOB_LOG AS _TestAssociation ON _TestAssociation.log_handle_concat = log_handle  -- association [0..*]
;