C_LegalEntitySubstVolByMonth

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_LegalEntitySubstVolByMonth.
-- 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: CSVTBYMONTHMNT

CREATE VIEW C_LegalEntitySubstVolByMonth AS
SELECT
  SVTAggregationItemUUID,
  CalendarMonth,
  CalendarYear,
  SVTBusinessProcess,
  CmplRqSVTScenario,
  _CalendarMonth._Text[1: Language = $session.system_language].CalendarMonthName AS CalendarMonthName,
  _SVTBusinessProcess._Text[1: Language = $session.system_language].SVTBusinessProcessText AS SVTBusinessProcessText,
  _CmplRqSVTScenario._Text[1: Language = $session.system_language].CmplRqSVTScenarioText AS CmplRqSVTScenarioText,
  PlannedSubstanceVolume,
  PlannedSubstanceVolumeUnit,
  concat_with_space(_CalendarMonth._Text[1: Language = $session.system_language].CalendarMonthName, CalendarYear, 2) AS PeriodMonthYearName,
  ConfirmedSubstanceVolume,
  ConfirmedSubstanceVolumeUnit,
  PlannedSubstanceVolume + ConfirmedSubstanceVolume AS LglEntityTotalSubstVol,
  _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,
  _LegalEntitySVTStatusMonitor._UnitOfMeasureMass AS _UnitOfMeasureMass
FROM I_SVTAggrgnLegalEntityByMonth AS SVTByMonth
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [1..1]
LEFT OUTER JOIN I_SVTBusinessProcess AS _SVTBusinessProcess ON SVTBusinessProcess = _SVTBusinessProcess.SVTBusinessProcess  -- association [0..1]
LEFT OUTER JOIN I_CmplRqSVTScenario AS _CmplRqSVTScenario ON CmplRqSVTScenario = _CmplRqSVTScenario.CmplRqSVTScenario  -- association [0..1]
LEFT OUTER JOIN C_MatlDocsByMonthAndBusProcess AS _MatlDocsByMonthAndBusProcess ON SVTAggregationItemUUID = _MatlDocsByMonthAndBusProcess.SVTAggregationItemUUID AND CalendarMonth = _MatlDocsByMonthAndBusProcess.CalendarMonth AND SVTBusinessProcess = _MatlDocsByMonthAndBusProcess.SVTBusinessProcess AND CmplRqSVTScenario = _MatlDocsByMonthAndBusProcess.CmplRqSVTScenario  -- association [0..*]
LEFT OUTER JOIN C_LegalEntitySVTStatusMonitor AS _LegalEntitySVTStatusMonitor ON SVTAggregationItemUUID = _LegalEntitySVTStatusMonitor.SVTAggregationItemUUID  -- association [1..1]
;