/APE/C_PROC_HDR_WITH_CONFIG

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 /APE/C_PROC_HDR_WITH_CONFIG.
-- 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: /APE/C_PROCHDRCG

CREATE VIEW /APE/C_PROC_HDR_WITH_CONFIG AS
SELECT
  proc_uuid,
  proc_doc_no,
  proc_status,
  tstmp_to_dats(proc_date, 'UTC', $session.client, 'NULL' ) AS proc_date,
  tstmp_to_dats(status_timestmp, 'UTC', $session.client, 'NULL' ) AS status_date,
  blocked,
  test,
  bo_type,
  bo_uuid,
  auth_grp,
  client_uuid,
  com_acc_uuid,
  owner_uuid,
  doc_tags,
  archived,
  tstmp_to_dats(created_at, 'UTC', $session.client, 'NULL' ) AS create_date,
  tstmp_to_dats(changed_at, 'UTC', $session.client, 'NULL' ) AS change_date,
  proc_id,
  proc_cluster,
  version,
  _proc.locked AS locked,
  compressed,
  log_level
FROM /APE/C_ProcDataHeader
LEFT OUTER JOIN /APE/C_Process AS _proc ON proc_config_uuid = _proc.config_key  -- association [1..1]
;