/APE/C_ProcStepCond_UI

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_ProcStepCond_UI.
-- 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_ProcStepCond_UI AS
SELECT
  Condition.config_key AS ProcessStepConditionKey,
  Condition.ape_parent_key AS ProcessStepKey,
  Condition.ape_root_key AS ProcessKey,
  Condition.condition_no AS ConditionSequenceNumber,
  _Process.ProcessID AS ProcessID,
  _Process.Version AS Version,
  _Process.ProcessCluster AS ProcessCluster,
  Condition.predecessor_uuid AS PredecessorStepKey,
  Condition.pred_proc_id AS PredeProcessID,
  _ProcessStepVH.ProcessIDDescription AS ProcessIDDescription,
  Condition.pred_version AS PredeVersion,
  Condition.pred_proc_cluster AS PredeProcessCluster,
  Condition.pred_seq_no AS PredeStepSequenceNumber,
  _ProcessStepVH.ProcessStepDescription AS ProcessStepDescription,
  Condition.proc_step_id AS PreProcessStepID,
  _ProcessStepVH.ProcessStepIDDescription AS ProcessStepIDDescription,
  Condition.status AS ProcessStepStatus,
  _ProcessStepStatusVH.Description AS ProcStepStatusDescription,
  Condition.operator AS RelationalOperator,
  Condition.value_low_uuid AS LowValueConditionKey,
  Condition.proc_value_Low AS LowValue,
  _LowValueVH.ValueDescription AS LowValueDescription,
  Condition.value_high_uuid AS HighValueConditionKey,
  Condition.proc_value_high AS HighValue,
  _HighValueVH.ValueDescription AS HighValueDescription,
  Condition.source_step AS isSourceStep,
  Condition.mandatory AS isMandatory,
  Condition.cardinality AS Cardinality,
  Condition.link AS ConditionLink
FROM /APE/I_ProcStepCond_TP AS Condition
LEFT OUTER JOIN /APE/C_Process_UI AS _Process ON _Process.ProcessKey = ProcessKey  -- association [1..1]
LEFT OUTER JOIN /APE/C_ProcessStep_UI AS _Step ON _Step.ProcessStepKey = ProcessStepKey AND _Step.ProcessKey = ProcessKey  -- association [1..1]
LEFT OUTER JOIN /APE/C_ProcStepMap_UI AS _StepMap ON _StepMap.ProcessStepConditionKey = ProcessStepConditionKey AND _StepMap.ProcessStepKey = ProcessStepKey AND _StepMap.ProcessKey = ProcessKey  -- association [0..*]
LEFT OUTER JOIN /APE/C_ProcessStep_VH AS _ProcessStepVH ON _ProcessStepVH.ProcessStepKey = PredecessorStepKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessValue_VH AS _LowValueVH ON _LowValueVH.ValueKey = LowValueConditionKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessValue_VH AS _HighValueVH ON _HighValueVH.ValueKey = HighValueConditionKey  -- association [0..1]
LEFT OUTER JOIN /APE/C_ProcessStepStatus_VH AS _ProcessStepStatusVH ON _ProcessStepStatusVH.Value = ProcessStepStatus  -- association [0..1]
LEFT OUTER JOIN /APE/C_RelationalOperator_VH AS _OperatorVH ON _OperatorVH.Value = RelationalOperator  -- association [0..1]
LEFT OUTER JOIN /APE/C_Cardinality_VH AS _CardinalityVH ON _CardinalityVH.Value = Cardinality  -- association [0..1]
LEFT OUTER JOIN /APE/C_ConditionLink_VH AS _ConditionLinkVH ON _ConditionLinkVH.Value = ConditionLink  -- association [0..1]
;