C_APJ_JOB_TEMPLATE_F2058

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 C_APJ_JOB_TEMPLATE_F2058.
-- 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: C_APJ_JT_F2058

CREATE VIEW C_APJ_JOB_TEMPLATE_F2058 AS
SELECT
  APJ_V_JOB_TEMPLATE_UNION.created_at AS created_at,
  APJ_V_JOB_TEMPLATE_UNION.changed_at AS changed_at,
  APJ_V_JOB_TEMPLATE_UNION.auth_group AS auth_group,
  APJ_V_JOB_TEMPLATE_UNION.report_name AS report_name,
  APJ_V_JOB_TEMPLATE_UNION.seq_count AS seq_count,
  APJ_V_JOB_TEMPLATE_UNION.jce_layer_c AS jce_layer_c,
  APJ_V_JOB_TEMPLATE_UNION.user_name AS user_name,
  APJ_V_JOB_TEMPLATE_UNION.text AS text,
  APJ_V_JOB_TEMPLATE_UNION.text_en AS text_en,
  tstmp_to_dats( APJ_V_JOB_TEMPLATE_UNION.created_at, 'UTC', $session.client, 'NULL' ) as created_at_date AS clientNULLascreated_at_date,
  tstmp_to_dats( APJ_V_JOB_TEMPLATE_UNION.changed_at, 'UTC', $session.client, 'NULL' ) as changed_at_date AS clientNULLaschanged_at_date,
  case when _Export.item_id = '' or _Export.item_id is null then 'N' when _Export.item_id = APJ_V_JOB_TEMPLATE_UNION.job_template_name and _Export.exported_at > APJ_V_JOB_TEMPLATE_UNION.changed_at then 'Y' else 'C' end as export AS changed_atthenYelseCendasexport
LEFT OUTER JOIN I_User AS _UserCreate ON _UserCreate.UserID = APJ_V_JOB_TEMPLATE_UNION.created_by  -- association [0..1]
LEFT OUTER JOIN I_User AS _UserChanged ON _UserChanged.UserID = APJ_V_JOB_TEMPLATE_UNION.changed_by  -- association [0..1]
LEFT OUTER JOIN apj_c_scope AS scope ON scope.job_catalog_entry_name = job_catalog_entry_name  -- association [0..1]
LEFT OUTER JOIN APJ_V_JOB_PERIOD_GRAN AS _JobPeriodicGranularity ON _JobPeriodicGranularity.PeriodicGranularity = job_periodic_granularity  -- association [0..1]
LEFT OUTER JOIN APJ_V_OBJECT_LAYER AS _ObjectLayer ON _ObjectLayer.ObjectLayer = job_template_layer_c  -- association [0..1]
LEFT OUTER JOIN APJ_V_JT_SEQUENCE_UNION AS _Sequences ON _Sequences.job_template_name = job_template_name  -- association [0..*]
LEFT OUTER JOIN ATOV_U_ITEMS_EXPORTED_AT AS _Export ON _Export.item_id = job_template_name AND _Export.item_type = 'SAJX'  -- association [0..1]
LEFT OUTER JOIN Atov_Latest_Imported_Items AS _Import ON _Import.item_id = job_template_name AND _Import.item_type = 'SAJX'  -- association [0..1]
;