C_LegalEntitySVTStatusMonitor

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_LegalEntitySVTStatusMonitor.
-- 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: CCRSVTSBYLGLENMN

CREATE VIEW C_LegalEntitySVTStatusMonitor AS
SELECT
  SVTAggregationItemUUID,
  LegalEntity,
  ComplianceRequirement,
  _SVTAggregationHeader._Substance.ResponsibleUnit AS ResponsibleUnit,
  _SVTAggregationHeader._Substance._ListedSubstance.ECNumber AS ECNumber,
  _SVTAggregationHeader._Substance._ListedSubstance.ListedSubstance AS ListedSubstance,
  _CmplRqLatestSubstanceList.SubstanceList AS SubstanceList,
  LegalEntitySVTStatus,
  _CmplRqSVTStatus._Text[ 1: Language = $session.system_language ].CmplRqSVTStatusText AS CmplRqSVTStatusText,
  _CmplRqSVTStatus.CmplRqSVTStatusCriticality AS CmplRqSVTStatusCriticality,
  _SVTAggregationHeader.SubstanceUUID AS SubstanceUUID,
  SVTAggregationItem._SVTAggregationHeader._Substance.SubstanceInternalName AS SubstanceInternalName,
  SVTAggregationItem._SVTAggregationHeader._Substance._ListedSubstance.CntntListedSubstanceDfltName AS CntntListedSubstanceDfltName,
  cast( PlannedSubstanceVolume as ehpma_svt_subst_vol_ui ) AS PlannedSubstanceVolume,
  PlannedSubstanceVolumeUnit,
  cast( ConfirmedSubstanceVolume as ehpma_svt_subst_vol_ui ) AS ConfirmedSubstanceVolume,
  ConfirmedSubstanceVolumeUnit,
  cast( TotalSubstanceVolume as ehpma_svt_subst_vol_ui ) AS TotalSubstanceVolume,
  TotalSubstanceVolumeUnit,
  cast( SubstanceVolumeThresholdQty as ehpma_svt_subst_vol_ui ) AS SubstanceVolumeThresholdQty,
  _UnitOfMeasureMass._Text[1:Language = $session.system_language].UnitOfMeasure AS SubstanceVolumeThresholdUnit,
  LglEntitySubstVolThldReachUnit,
  LglEntitySubstVolThldReachPct,
  _UnitOfMeasurePercent._Text[1:Language = $session.system_language].UnitOfMeasure AS ProdAllocPercentUnit,
  CmplncRqmtSubstRegnNumber,
  _SVTAggregationHeader.TrackingPeriodStartDate AS TrackingPeriodStartDate,
  _SVTAggregationHeader.TrackingPeriodEndDate AS TrackingPeriodEndDate,
  SVTAggregationHeaderUUID,
  cast( '' as abap.char( 250 )) AS CmplRqVersTrackingPeriodText,
  _SVTAggregationHeader._Substance._ListedSubstance.CASNumber AS CASNumber,
  cast( _SVTTrackingPeriods.TrackingPeriodType as ehpma_svt_track_per_type ) AS TrackingPeriodType
FROM I_SVTAggregationItem AS SVTAggregationItem
LEFT OUTER JOIN C_LegalEntitySubstVolByMonth AS _LegalEntitySubstVolByMonth ON SVTAggregationItemUUID = _LegalEntitySubstVolByMonth.SVTAggregationItemUUID  -- association [0..*]
LEFT OUTER JOIN C_LegalEntitySubstVolByProduct AS _LegalEntitySubstVolByProduct ON SVTAggregationItemUUID = _LegalEntitySubstVolByProduct.SVTAggregationItemUUID  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasurePercent ON SVTAggregationItem.LglEntitySubstVolThldReachUnit = _UnitOfMeasurePercent.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasureMass ON TotalSubstanceVolumeUnit = _UnitOfMeasureMass.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_CmplRqSVTStatus AS _CmplRqSVTStatus ON SVTAggregationItem.LegalEntitySVTStatus = _CmplRqSVTStatus.CmplRqSVTStatus  -- association [1..1]
LEFT OUTER JOIN P_SVTTrackingPeriods AS _SVTTrackingPeriods ON SVTAggregationHeaderUUID = _SVTTrackingPeriods.SVTAggregationHeaderUUID  -- association [1..1]
LEFT OUTER JOIN P_CmplRqLatestSubstanceList AS _CmplRqLatestSubstanceList ON SVTAggregationItem.SubstanceList = _CmplRqLatestSubstanceList.SubstanceList AND SVTAggregationItem.ComplianceRequirement = _CmplRqLatestSubstanceList.ComplianceRequirement  -- association [1..1]
LEFT OUTER JOIN I_OTRText AS _OTRNotAssignText ON _OTRNotAssignText.OnlnTxtRpstryConceptID = '42010AEF4C8E1EED81D263B7DCBAB68B' AND _OTRNotAssignText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN P_ChmlCmplConstants AS _Constants ON _Constants.Dummy = _Constants.Dummy  -- association [0..1]
;