A_SVTManufacturing_2

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 A_SVTManufacturing_2.
-- 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.
-- SQL view name: ASVTMANUFCTRNG2

CREATE VIEW A_SVTManufacturing_2 AS
SELECT
  _SVTAggregationItem.ComplianceRequirement AS ComplianceRequirement,
  _SVTAggregationItem.SubstanceList AS SubstanceList,
  _SVTAggregationItem._SVTAggregationHeader.TrackingPeriodStartDate AS TrackingPeriodStartDate,
  _SVTAggregationItem._SVTAggregationHeader.TrackingPeriodEndDate AS TrackingPeriodEndDate,
  cast( _ChmlCmplncInfo.Specification as ehpma_svt_cci_specification ) AS ChmlCmplncInfoSpecification,
  cast( _Substance.Specification as ehpma_svt_sub_specification ) AS Specification,
  _SVTAggregationItem.LegalEntity AS LegalEntity,
  I_SVTDailyAggregation.Plant AS Plant,
  I_SVTDailyAggregation.Material AS Material,
  I_SVTDailyAggregation.CmplRqSVTScenario AS CmplRqSVTScenario,
  I_SVTDailyAggregation.PostingDate AS PostingDate,
  _Plant.Country AS Country,
  _SVTTotalAggregationToDate.ConfdTotToDteSubstVol AS ConfdTotToDteSubstVol,
  I_SVTDailyAggregation.ConfirmedDailySubstanceVolume AS ConfirmedDailySubstanceVolume,
  I_SVTDailyAggregation.ConfirmedSubstanceVolumeUnit AS ConfirmedSubstanceVolumeUnit,
  _SVTSubstanceConcentration.SVTSubstanceConcentrationQty AS SVTSubstanceConcentrationQty,
  _SVTSubstanceConcentration.SVTSubstConcentrationQtyUnit AS SVTSubstConcentrationQtyUnit
FROM I_SVTDailyAggregation
INNER JOIN I_SVTAggregationItem AS _SVTAggregationItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SVTTotalAggregationToDate AS _SVTTotalAggregationToDate ON _SVTTotalAggregationToDate.SVTAggregationItemUUID = I_SVTDailyAggregation.SVTAggregationItemUUID AND _SVTTotalAggregationToDate.SVTBusinessProcess = I_SVTDailyAggregation.SVTBusinessProcess AND _SVTTotalAggregationToDate.Material = I_SVTDailyAggregation.Material AND _SVTTotalAggregationToDate.Plant = I_SVTDailyAggregation.Plant AND _SVTTotalAggregationToDate.SubstanceUUID = I_SVTDailyAggregation.SubstanceUUID AND _SVTTotalAggregationToDate.ChmlCmplncInfoUUID = I_SVTDailyAggregation.ChmlCmplncInfoUUID AND _SVTTotalAggregationToDate.PostingDate = I_SVTDailyAggregation.PostingDate  -- association [1..1]
LEFT OUTER JOIN I_ChmlCmplncInfo AS _ChmlCmplncInfo ON _ChmlCmplncInfo.ChmlCmplncInfoUUID = I_SVTDailyAggregation.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN I_Substance AS _Substance ON _Substance.SubstanceUUID = I_SVTDailyAggregation.SubstanceUUID  -- association [1..1]
LEFT OUTER JOIN P_SVTSubstanceConcentration AS _SVTSubstanceConcentration ON _SVTSubstanceConcentration.SubstanceUUID = I_SVTDailyAggregation.SubstanceUUID AND _SVTSubstanceConcentration.ChmlCmplncInfoUUID = I_SVTDailyAggregation.ChmlCmplncInfoUUID AND _SVTSubstanceConcentration.ComplianceRequirement = _SVTAggregationItem.ComplianceRequirement AND _SVTSubstanceConcentration.ValidityStartDate <= I_SVTDailyAggregation.PostingDate AND _SVTSubstanceConcentration.ValidityEndDate > I_SVTDailyAggregation.PostingDate AND _SVTSubstanceConcentration.SVTBusinessProcess = I_SVTDailyAggregation.SVTBusinessProcess  -- association [1..*]
LEFT OUTER JOIN P_SVTLastDateCalculation AS _SVTLastDateCalculation ON _SVTLastDateCalculation.SVTAggregationItemUUID = I_SVTDailyAggregation.SVTAggregationItemUUID AND _SVTLastDateCalculation.SVTBusinessProcess = I_SVTDailyAggregation.SVTBusinessProcess AND _SVTLastDateCalculation.Material = I_SVTDailyAggregation.Material AND _SVTLastDateCalculation.Plant = I_SVTDailyAggregation.Plant AND _SVTLastDateCalculation.SubstanceUUID = I_SVTDailyAggregation.SubstanceUUID AND _SVTLastDateCalculation.ChmlCmplncInfoUUID = I_SVTDailyAggregation.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN I_SVTPlant AS _Plant ON _Plant.Plant = I_SVTDailyAggregation.Plant  -- association [1..1]
;