/APE/C_TemplateStepCond

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_TemplateStepCond.
-- 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_TemplateStepCond AS
SELECT
  Condition.config_key AS ProcessStepConditionKey,
  Condition.ape_parent_key AS ProcessStepKey,
  Condition.ape_root_key AS ProcessKey,
  Condition.condition_no AS ConditionSequenceNumber,
  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_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_DomainValueTexts AS _CardinalityVH ON _CardinalityVH.Domname = '/APE/D_CARDINALITY' AND _CardinalityVH.Language = $session.system_language AND _CardinalityVH.Domvalue = Cardinality  -- association [0..1]
LEFT OUTER JOIN /APE/C_DomainValueTexts AS _ConditionLinkVH ON _ConditionLinkVH.Domname = '/APE/D_COND_LINK' AND _ConditionLinkVH.Language = $session.system_language AND _ConditionLinkVH.Domvalue = ConditionLink  -- association [0..1]
;