/APE/C_ProcDataHeader

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_ProcDataHeader.
-- 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.

CREATE VIEW /APE/C_ProcDataHeader AS
SELECT
  db_key AS proc_uuid,
  client_uuid,
  com_acc_uuid,
  proc_doc_no,
  _ProcessConfig.proc_cluster AS proc_cluster,
  _ProcessConfig.proc_id AS proc_id,
  _ProcessConfig.version AS version,
  proc_date,
  proc_status,
  bo_type,
  bo_uuid,
  owner_uuid,
  doc_tags,
  created_at,
  created_by,
  changed_at,
  changed_by,
  auth_grp,
  test,
  log_level,
  archived,
  blocked,
  compressed
FROM /APE/I_ProcessHeader_TP AS ProcessHeader
LEFT OUTER JOIN /APE/C_Process AS _ProcessConfig ON proc_config_uuid = _ProcessConfig.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/C_BusStatus AS _BusStatus ON proc_bus_status_uuid = _BusStatus.proc_bus_status_uuid  -- association [0..1]
;