C_LegalEntitySubstVolByProduct

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_LegalEntitySubstVolByProduct.
-- 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: CSVTBYPRDCTMNT

CREATE VIEW C_LegalEntitySubstVolByProduct AS
SELECT
  SVTAggregationItemUUID,
  ChmlCmplncInfoUUID,
  _ChmlCmplncPrimMatl.ChmlCmplncInfoCombinedName AS ChmlCmplncInfoCombinedName,
  _ChmlCmplncPrimMatl.Material AS Material,
  PlannedSubstanceVolume,
  PlannedSubstanceVolumeUnit,
  ConfirmedSubstanceVolume,
  ConfirmedSubstanceVolumeUnit,
  PlannedSubstanceVolume + ConfirmedSubstanceVolume AS LglEntityProductTotalSubstVol,
  _LegalEntitySVTStatusMonitor.CASNumber AS CASNumber,
  _LegalEntitySVTStatusMonitor.SubstanceName AS SubstanceName,
  _LegalEntitySVTStatusMonitor.LegalEntity AS LegalEntity,
  _LegalEntitySVTStatusMonitor.TotalSubstanceVolume AS TotalSubstanceVolume,
  _LegalEntitySVTStatusMonitor.TotalSubstanceVolumeUnit AS TotalSubstanceVolumeUnit,
  _LegalEntitySVTStatusMonitor.CmplRqVersTrackingPeriodText AS CmplRqVersTrackingPeriodText,
  _LegalEntitySVTStatusMonitor.TrackingPeriodStartDate AS TrackingPeriodStartDate,
  _LegalEntitySVTStatusMonitor.TrackingPeriodEndDate AS TrackingPeriodEndDate,
  _LegalEntitySVTStatusMonitor.SubstanceVolumeThresholdQty AS SubstanceVolumeThresholdQty,
  _LegalEntitySVTStatusMonitor.SubstanceListName AS SubstanceListName,
  _LegalEntitySVTStatusMonitor.SubstanceVolumeThresholdUnit AS SubstanceVolumeThresholdUnit,
  _LegalEntitySVTStatusMonitor.LglEntitySubstVolThldReachUnit AS LglEntitySubstVolThldReachUnit,
  _LegalEntitySVTStatusMonitor.LglEntitySubstVolThldReachPct AS LglEntitySubstVolThldReachPct,
  _LegalEntitySVTStatusMonitor.CmplRqSVTStatusCriticality AS CmplRqSVTStatusCriticality,
  _LegalEntitySVTStatusMonitor.ProdAllocPercentUnit AS ProdAllocPercentUnit,
  SVTAggregationHeaderUUID
FROM I_SVTAggrgnLglEntityByProduct AS SVTByProduct
LEFT OUTER JOIN C_MatlDocsByMonthAndBusProcess AS _MatlDocsByMonthAndBusProcess ON SVTAggregationItemUUID = _MatlDocsByMonthAndBusProcess.SVTAggregationItemUUID AND ChmlCmplncInfoUUID = _MatlDocsByMonthAndBusProcess.ChmlCmplncInfoUUID  -- association [0..*]
LEFT OUTER JOIN C_ChmlCmplncPrimMatl AS _ChmlCmplncPrimMatl ON ChmlCmplncInfoUUID = _ChmlCmplncPrimMatl.ChmlCmplncInfoUUID  -- association [1..1]
LEFT OUTER JOIN C_LegalEntitySVTStatusMonitor AS _LegalEntitySVTStatusMonitor ON SVTAggregationItemUUID = _LegalEntitySVTStatusMonitor.SVTAggregationItemUUID  -- association [1..1]
;