I_SVTCalcItmResultHierNodeRltn

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 I_SVTCalcItmResultHierNodeRltn.
-- 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 I_SVTCalcItmResultHierNodeRltn AS
SELECT
  SVTCalculationItemResultUUID,
  SVTCalculationUUID,
  ProdCmplncEventUUID,
  I_SVTCalculationItemResult.ProdCmplncEventType AS ProdCmplncEventType,
  SVTCalculationItemUUID,
  CreationDateTime,
  CalculatedSubstanceVolume,
  SubstanceVolumeUnit,
  SVTCalculationDecisionReason,
  SVTCalculationDecision,
  SVTCalcSubstanceRegulationUUID,
  SVTCalculationSubstanceUUID,
  SVTParentCalculationItemUUID,
  SVTCalculationResultUUID,
  SVTParentCalcItemResultUUID
FROM I_SVTCalculationItemResult
LEFT OUTER JOIN I_SVTCalcItmResultHierNodeRltn AS _Parent ON _Parent.SVTCalculationItemUUID = SVTParentCalculationItemUUID AND _Parent.SVTCalculationUUID = SVTCalculationUUID  -- association [0..*]
LEFT OUTER JOIN I_SVTCalculationItem AS _SVTCalculationItem ON _SVTCalculationItem.SVTCalculationItemUUID = SVTCalculationItemUUID  -- association [1..1]
LEFT OUTER JOIN I_SVTCalculationResult AS _SVTCalculationResult ON SVTCalculationUUID = _SVTCalculationResult.SVTCalculationUUID  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON SubstanceVolumeUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_SVTCalcSubstanceRegulation AS _SVTSubstanceRegulation ON SVTCalcSubstanceRegulationUUID = _SVTSubstanceRegulation.SVTCalcSubstanceRegulationUUID  -- association [0..1]
LEFT OUTER JOIN I_SVTCalculationSubstance AS _SVTCalculationSubstance ON SVTCalculationSubstanceUUID = _SVTCalculationSubstance.SVTCalculationSubstanceUUID  -- association [0..1]
;