/APE/I_ProcessStepCondTP_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/I_ProcessStepCondTP_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/I_ProcessStepCondTP_C AS
SELECT
  config_key,
  ape_root_key,
  _Process.proc_cluster AS proc_cluster,
  _Process.proc_id AS proc_id,
  _Process.version AS version,
  _ProcessStep.seq_no AS seq_no,
  condition_no,
  _PredStep._Process.proc_id AS pred_proc_id,
  _PredStep._Process.version AS pred_version,
  _PredStep.seq_no AS pred_seq_no,
  _PredStep.proc_step_id AS proc_step_id,
  status,
  operator,
  _ProcValueLow.proc_value AS proc_value_Low,
  source_step,
  mandatory,
  cardinality,
  link,
  created_at_,
  created_by_,
  changed_at_,
  changed_by_
FROM /APE/I_ProcessStepCond_C
LEFT OUTER JOIN /APE/I_ProcessTP_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/I_ProcessStep_TP AS _PredStep ON predecessor_uuid = _PredStep.config_key  -- association [1..1]
LEFT OUTER JOIN /APE/I_ProcessValueText_C AS _ProcValueLowText ON value_low_uuid = _ProcValueLowText.ape_parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/I_ProcessValueText_C AS _ProcValueHighText ON value_high_uuid = _ProcValueHighText.ape_parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/I_ProcessStepText_C AS _ProcessStepText ON ape_parent_key = _ProcessStepText.ape_parent_key  -- association [0..*]
LEFT OUTER JOIN /APE/C_DomainValuesText AS _ConditionLinkText ON _ConditionLinkText.Name = '/APE/D_COND_LINK' AND _ConditionLinkText.ValueCode = link  -- association [0..*]
LEFT OUTER JOIN /APE/C_DomainValuesText AS _CardinalityText ON _CardinalityText.Name = '/APE/D_CARDINALITY' AND _CardinalityText.ValueCode = cardinality  -- association [0..*]
LEFT OUTER JOIN /APE/C_DomainValuesText AS _OperatorText ON _OperatorText.Name = '/APE/D_OPERATOR' AND _OperatorText.ValueCode = operator  -- association [0..*]
LEFT OUTER JOIN /APE/C_DomainValuesText AS _StatusText ON _StatusText.Name = '/APE/D_PROC_STEP_STATUS' AND _StatusText.ValueCode = status  -- association [0..*]
LEFT OUTER JOIN /APE/I_ProcessStepMapTP_C AS _ProcessStepMap ON /* condition not available in parsed metadata */  -- association [0..*]
;