/APE/C_ProcessBuffered

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_ProcessBuffered.
-- 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_ProcessBuffered AS
SELECT
  Proc.config_key AS config_key,
  Proc.proc_id_uuid AS proc_id_uuid,
  Proc.version_uuid AS version_uuid,
  ProcCluster.proc_cluster AS proc_cluster,
  ProcId.proc_id AS proc_id,
  Version.version AS version,
  Proc.category AS category,
  Proc.class AS class,
  Proc.reversible AS reversible,
  Proc.market_role AS market_role,
  Proc.config_layer AS config_layer
FROM /ape/proc AS Proc
LEFT OUTER JOIN /ape/proc AS PatternProc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ape/procid AS ProcId ON Proc.proc_id_uuid = ProcId.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procclus AS ProcCluster ON Proc.proc_cluster_uuid = ProcCluster.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/version AS Version ON Proc.version_uuid = Version.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procid AS PatternProcId ON PatternProc.proc_id_uuid = PatternProcId.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procclus AS PatternProcCluster ON PatternProc.proc_cluster_uuid = PatternProcCluster.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/version AS PatternVersion ON PatternProc.version_uuid = PatternVersion.config_key  -- association [0..1]
LEFT OUTER JOIN /ape/procc AS ProcCust ON Proc.config_key = ProcCust.ape_parent_key  -- association [0..*]
;