/APE/C_ProcessStep_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_ProcessStep_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_ProcessStep_VH AS
SELECT
  ProcessStep.config_key AS ProcessStepKey,
  ProcessStep.proc_id AS ProcessID,
  ProcessStep.proc_id AS ProcessIDFilter,
  _ProcessIDText.ProcessIDDescription AS ProcessIDDescription,
  _ProcessIDText.ProcessIDDescriptionISL AS ProcessIDDescriptionISL,
  ProcessStep.version AS Version,
  ProcessStep.version AS VersionFilter,
  _VersionText.VersionDescription AS VersionDescription,
  ProcessStep.seq_no AS StepSequenceNumber,
  ProcessStep.proc_step_id_uuid AS ProcessStepIDKey,
  ProcessStep.proc_step_id AS ProcessStepID,
  _ProcessStepIDText.ProcessStepIDDescription AS ProcessStepIDDescription,
  _ProcessStepIDText.ProcessStepIDDescriptionISL AS ProcessStepIDDescriptionISL,
  ProcessStep.category AS Category,
  ProcessStep.type AS Type,
  ProcessStep.ape_parent_key AS ProcessKey,
  ProcessStep.proc_cluster AS ProcessCluster,
  ProcessStep.proc_cluster AS ProcessClusterFilter,
  _ProClusterText.ProcessClusterDescription AS ProcessClusterDescription,
  _ProcessStepText[1: language = $session.system_language ].description AS ProcessStepDescriptionISL,
  _BusMsgText.BusinessMessageID AS BusinessMessageID,
  _BusMsgText.BusinessMessageIDDescription AS BusMsgDescription,
  ProcessStep.class AS ProcessStepClass,
  ProcessStep.pattern_step_config_uuid AS PatternStepKey,
  ProcessStep.trigger_proc_id_uuid AS TriggerProcessIDKey,
  _TriggerProcessIDText.ProcessIDDescription AS TriggerProcessIDDescription
FROM /APE/C_ProcessStep_QR AS ProcessStep
LEFT OUTER JOIN /APE/C_ProcStepText AS _ProcessStepText ON _ProcessStepText.ape_parent_key = ProcessStepKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_ProcStepText AS _PatternStepText ON _PatternStepText.ape_parent_key = PatternStepKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_ProcessStepID_VH AS _ProcessStepIDText ON _ProcessStepIDText.ProcessStepIDKey = ProcessStepIDKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_BUSMESID_VH AS _BusMsgText ON _BusMsgText.BusinessMessageIDKey = bus_msg_id_uuid  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessID_VH AS _ProcessIDText ON _ProcessIDText.ProcessID = ProcessID  -- association [0..1]
LEFT OUTER JOIN /APE/C_Version_VH AS _VersionText ON _VersionText.Version = Version AND _VersionText.ProcessCluster = ProcessCluster  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessStepType_VH AS _StepTypeText ON _StepTypeText.Value = Type  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessCluster_VH AS _ProClusterText ON _ProClusterText.ProcessCluster = ProcessCluster  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessStepCategory_VH AS _StepCategoryText ON _StepCategoryText.Value = Category  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessID_VH AS _TriggerProcessIDText ON _TriggerProcessIDText.ProcessIDKey = TriggerProcessIDKey  -- association [0..1]
;