/APE/C_PROC_STP_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_STP_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_PROCSTPCG

CREATE VIEW /APE/C_PROC_STP_WITH_CONFIG AS
SELECT
  proc_uuid,
  _proc_hdr.proc_status AS proc_status,
  step_status,
  tstmp_to_dats(_proc_hdr.proc_date, 'UTC', $session.client, 'NULL' ) AS proc_date,
  _proc_hdr.owner_uuid AS owner_uuid,
  _proc_hdr.client_uuid AS client_uuid,
  _proc_hdr.blocked AS blocked,
  _proc_hdr.test AS test,
  _proc_hdr.bo_type AS bo_type,
  _proc_hdr.bo_uuid AS bo_uuid,
  _proc_hdr.proc_doc_no AS proc_doc_no,
  deadline,
  _proc_hdr.proc_id AS proc_id,
  _proc_hdr.proc_cluster AS proc_cluster,
  _StepConfig._Process.locked AS locked
FROM /APE/C_ProcDataStepHeader
LEFT OUTER JOIN /APE/C_ProcDataHeader AS _proc_hdr ON proc_uuid = _proc_hdr.proc_uuid  -- association [1..1]
LEFT OUTER JOIN /APE/C_ProcessStep AS _StepConfig ON step_config_uuid_phys = _StepConfig.config_key  -- association [1..1]
;