C_SVTCalculationItemResult

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 C_SVTCalculationItemResult.
-- 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 C_SVTCalculationItemResult AS
SELECT
  SVTCalculationItemResultUUID,
  SVTCalculationUUID,
  ProdCmplncEventUUID,
  ProdCmplncEventType,
  _ProdCmplncEventType._Text[1: Language = $session.system_language].ProdCmplncEventTypeText AS ProdCmplncEventTypeText,
  SVTCalculationItemUUID,
  SVTCalculationSubstanceUUID,
  SVTCalculationDecision,
  _SVTCalculationDecision._Text[ 1: Language = $session.system_language ].SVTCalculationDecisionText AS SVTCalculationDecisionText,
  SVTCalculationDecisionReason,
  _SVTCalcDecisionReason._Text[ 1: Language = $session.system_language ].SVTCalcDecisionReasonText AS SVTCalcDecisionReasonText,
  CalculatedSubstanceVolume,
  SubstanceVolumeUnit,
  SVTParentCalculationItemUUID,
  SVTCalculationResultUUID,
  SVTParentCalcItemResultUUID,
  CreationDateTime,
  SVTCalculationStatus,
  _SVTCalculationStatus._Text[ 1: Language = $session.system_language ].SVTCalculationStatusText AS SVTCalculationStatusText,
  SVTChmlComponentUUID,
  SVTCalcSubstanceComponentUUID,
  SubstanceUUID,
  _SubstanceTP.SubstanceName AS SubstanceName,
  _SVTSubstanceRegulation.ChmlCompType AS ChmlCompType,
  _SVTSubstanceRegulation.ComplianceRequirement AS ComplianceRequirement,
  _SVTSubstanceRegulation.CmplRqUUID AS CmplRqUUID,
  _SVTSubstanceRegulation.CmplRqVersUUID AS CmplRqVersUUID,
  _SVTCalculationSubstance.SVTSubstanceList AS SVTSubstanceList,
  _SVTCalculationSubstance.SVTSubstanceListUUID AS SVTSubstanceListUUID,
  _SVTCalculationSubstance._SubstanceList._Text[1: Language = $session.system_language].SubstanceListName AS SubstanceListName,
  _SVTCalculationSubstance._SubstanceList.SubstanceListType AS SubstanceListType,
  _SVTCalculationSubstance._SubstanceList._SubstanceListTypeText[1: Language = $session.system_language].SubstanceListTypeText AS SubstanceListTypeText,
  _SVTCalculationSubstance.SubstIsNotListed AS SubstIsNotListed,
  _SVTCalculationSubstance.PolymerCompositionIntID AS PolymerCompositionIntID,
  _SVTCalculationSubstance.CmplRqRsltUUID AS CmplRqRsltUUID,
  _SVTCalculationSubstance.CmplRqRsltLastChgdDateTime AS CmplRqRsltLastChgdDateTime,
  _SVTCalculationSubstance.SVTCalculationValidityStatus AS SVTCalculationValidityStatus,
  _SVTCalculationSubstance._SVTCalculationStatus._Text[1: Language = $session.system_language].SVTCalculationStatusText AS SVTCalcValidityStatusText,
  _SVTCalculationSubstance.PolymerIsBsdOnOECDDef AS PolymerIsBsdOnOECDDef,
  _SVTCalculationSubstance._ChmlComposition.PolymerCompositionName AS PolymerCompositionName
FROM I_SVTCalculationItemResult
LEFT OUTER JOIN C_SVTCalculationItemResult AS _Parent ON SVTParentCalculationItemUUID = _Parent.SVTCalculationItemUUID AND SVTCalculationUUID = _Parent.SVTCalculationUUID  -- association [0..1]
LEFT OUTER JOIN I_SVTCalcDecisionReason AS _SVTCalcDecisionReason ON SVTCalculationDecisionReason = _SVTCalcDecisionReason.SVTCalculationDecisionReason  -- association [0..1]
LEFT OUTER JOIN I_SVTCalculationDecision AS _SVTCalculationDecision ON SVTCalculationDecision = _SVTCalculationDecision.SVTCalculationDecision  -- association [0..1]
LEFT OUTER JOIN I_ProdCmplncEventType AS _ProdCmplncEventType ON ProdCmplncEventType = _ProdCmplncEventType.ProdCmplncEventType  -- association [0..1]
LEFT OUTER JOIN C_SVTObjectExclusionReason AS _SVTExclsnRsn ON SVTCalculationSubstanceUUID = _SVTExclsnRsn.SVTObjectUUID AND _SVTExclsnRsn.SVTObjExclusionReasonIsDeleted = ''  -- association [0..*]
LEFT OUTER JOIN I_SVTCalculationStatus AS _SVTCalculationStatus ON SVTCalculationStatus = _SVTCalculationStatus.SVTCalculationStatus  -- association [0..1]
LEFT OUTER JOIN I_SVTCalcChmlCmplncInfoComp AS _CCISubstanceConcentration ON SVTChmlComponentUUID = _CCISubstanceConcentration.SVTChmlComponentUUID  -- association [0..1]
LEFT OUTER JOIN I_SVTCalcSubstanceComponent AS _PolySubstanceConcentration ON SVTCalcSubstanceComponentUUID = _PolySubstanceConcentration.SVTCalcSubstanceComponentUUID  -- association [0..1]
LEFT OUTER JOIN I_SubstanceTP AS _SubstanceTP ON SubstanceUUID = _SubstanceTP.SubstanceUUID  -- association [0..1]
LEFT OUTER JOIN C_SVTSubstanceList AS _SVTSubstanceList ON SVTCalculationSubstanceUUID = _SVTSubstanceList.SVTCalculationSubstanceUUID  -- association [0..*]
;