APJ_V_JOB_TEMPLATE

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 APJ_V_JOB_TEMPLATE.
-- 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: APJ_V_JOB_TEMP

CREATE VIEW APJ_V_JOB_TEMPLATE AS
SELECT
  root.crea_date_time AS created_at,
  root.crea_user_acct AS created_by,
  root.lst_ch_user_acct AS changed_by,
  jce.auth_group AS auth_group,
  case when jce.job_catalog_entry_type_c = 'C' then jce_seq.seq_count else 1 end AS seq_count,
  cast( '1' as abap.char( 1 ) ) AS jce_layer_c,
  jce.report_name AS report_name,
  jt_t.text AS text,
  jt_t_en.text AS text_en
FROM apj_w_jt_root AS root
INNER JOIN apj_w_jce_root AS jce ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN apj_w_jce_ro_t AS jce_t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN apj_w_jce_ro_t AS jce_t_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APJ_V_W_JCE_SEQ_COUNT AS jce_seq ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN apj_w_jt_ro_t AS jt_t ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN apj_w_jt_ro_t AS jt_t_en ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN apj_c_jt_pers AS pers ON /* join condition not captured in parsed metadata */
;