/APE/C_Process_VH

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_Process_VH.
-- 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_Process_VH AS
SELECT
  Process.config_key AS ProcessKey,
  _ProcessText[1: language = $session.system_language ].description AS ProcessDescriptionISL,
  _ProcessCluster.ProcessClusterKey AS ProcessClusterKey,
  _ProcessCluster.ProcessCluster AS ProcessCluster,
  _ProcessCluster.ProcessClusterDescription AS ProcessClusterDescription,
  _ProcessID.ProcessIDKey AS ProcessIDKey,
  _ProcessID.ProcessID AS ProcessID,
  _ProcessID.ProcessIDDescription AS ProcessIDDescription,
  _Version.VersionKey AS VersionKey,
  _Version.Version AS Version,
  _Version.VersionDescription AS VersionDescription,
  Process.category AS Category,
  Process.proc_cluster AS proc_cluster
FROM /APE/C_Process AS Process
LEFT OUTER JOIN /APE/C_Processtext AS _ProcessText ON _ProcessText.ape_parent_key = Process.config_key  -- association [0..*]
LEFT OUTER JOIN /APE/C_ProcessCluster_VH AS _ProcessCluster ON _ProcessCluster.ProcessClusterKey = Process.proc_cluster_uuid  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessID_VH AS _ProcessID ON _ProcessID.ProcessIDKey = Process.proc_id_uuid  -- association [0..1]
LEFT OUTER JOIN /APE/C_Version_VH AS _Version ON _Version.VersionKey = Process.version_uuid  -- association [0..1]
;