/APE/C_ProcessStepCond_C

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_ProcessStepCond_C.
-- 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_ProcessStepCond_C AS
SELECT
  config_key,
  ape_root_key,
  _ProcessStepQuery.proc_cluster AS proc_cluster,
  _ProcessStepQuery.proc_id AS proc_id,
  _ProcessStepQuery.version AS version,
  _ProcessStepQuery.seq_no AS seq_no,
  _ProcessStepQuery.proc_step_id AS proc_step_id,
  condition_no,
  _ProcessStepQuery.multiple AS multiple,
  _ProcessStepQuery.type AS type,
  _PredStep.proc_id AS pred_proc_id,
  _PredStep.version AS pred_version,
  _PredStep.seq_no AS pred_seq_no,
  _PredStep.type AS pred_type,
  status,
  operator,
  _ProcValueLow.proc_value AS proc_value_Low,
  source_step,
  mandatory,
  cardinality,
  link
FROM /APE/I_ProcessStepCond_C
LEFT OUTER JOIN /APE/C_ProcessStepMap_C AS _StepMap ON config_key = _StepMap.ape_parent_key AND ape_parent_key = _StepMap.ape_parentlvl2_key AND ape_root_key = _StepMap.ape_root_key  -- association [0..*]
LEFT OUTER JOIN /APE/C_ProcessStep_C AS _Step ON ape_parent_key = _Step.config_key AND ape_root_key = _Step.ape_parent_key  -- association [1..1]
LEFT OUTER JOIN /APE/C_Process_C AS _Process ON ape_root_key = _Process.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_ProcessValue_C AS _ProcValueLow ON value_low_uuid = _ProcValueLow.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_ProcessValue_C AS _ProcValueHigh ON value_high_uuid = _ProcValueHigh.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/C_ProcessStep_C AS _PredStep ON predecessor_uuid = _PredStep.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/C_ProcessStep_C AS _ProcessStepQuery ON ape_parent_key = _ProcessStepQuery.config_key  -- association [1..1]
;