I_SVTCalculationSubstance

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_SVTCalculationSubstance.
-- 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_SVTCalculationSubstance AS
SELECT
  svtsubstanceuserprofileuuid AS SVTCalculationSubstanceUUID,
  svtsubregulatoryprofileuuid AS SVTCalcSubstanceRegulationUUID,
  substanceisnotlisted AS SubstIsNotListed,
  relevantsubstancelist AS SVTSubstanceList,
  relevantsubstancelistuuid AS SVTSubstanceListUUID,
  polymercompositionuuid AS ChmlCompositionUUID,
  PolymerCompositionIntID,
  CmplRqRsltUUID,
  validitystartdatetime AS SVTCalcSubstValdtyStrtDateTime,
  validityenddatetime AS SVTCalcSubstValdtyEndDateTime,
  calculationstatus AS SVTCalculationValidityStatus,
  SubstVolRetrackingUUID,
  PolymerIsBsdOnOECDDef,
  crrlastchangedatetime AS CmplRqRsltLastChgdDateTime,
  ProdCmplncEventUUID
FROM ehpmad_svt_subup
LEFT OUTER JOIN I_CmplRqVersSubstanceList AS _SubstanceList ON SVTSubstanceListUUID = _SubstanceList.SubstanceListUUID  -- association [0..1]
LEFT OUTER JOIN I_ChmlComposition AS _ChmlComposition ON ChmlCompositionUUID = _ChmlComposition.ChmlCompositionUUID  -- association [0..1]
LEFT OUTER JOIN I_SVTCalculationStatus AS _SVTCalculationStatus ON SVTCalculationValidityStatus = _SVTCalculationStatus.SVTCalculationStatus  -- association [0..1]
;