I_MaterialCoverage

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_MaterialCoverage.
-- 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: IMATCOV

CREATE VIEW I_MaterialCoverage AS
SELECT
  MRPPlanningSegment.MRPPlant AS MRPPlant,
  MRPPlanningSegment.MRPArea AS MRPArea,
  MRPPlanningSegment.Material AS Material,
  MRPPlanningSegment.MRPPlanningSegment AS MRPPlanningSegment,
  MRPPlanningSegment.MRPPlanningSegmentType AS MRPPlanningSegmentType,
  MRPPlanningSegment.MaterialShortageProfile AS MaterialShortageProfile,
  cast (MaterialShortageDefinition.MaterialShortageProfileCount as materialshortageprofilecount) AS MaterialShortageProfileCount,
  CacheMaterial.FactoryCalendar AS FactoryCalendar,
  _CacheSupplier.Supplier AS Supplier,
  MRPPlanningSegment.MRPPlanningSegmentExternalCode AS MRPPlanningSegmentExternalCode,
  cast (CacheMaterial.MaterialName as maktx) AS MaterialName,
  CacheMaterial.MaterialBaseUnit AS MaterialBaseUnit,
  CacheMaterial.MRPController AS MRPController,
  cast (MRPPlanningSegment.MRPAvailableStockQty as mrpavailablestockqty) AS MRPAvailableStockQty,
  _CacheShortageStatistics.MaterialShortageQuantity AS MaterialShortageQuantity,
  _CacheShortageStatistics.EvaluationHorizonInDays AS EvaluationHorizonInDays,
  _CacheShortageStatistics.MaterialShortageDefinitionName AS MaterialShortageDefinitionName,
  _CacheShortageStatistics.MaterialShortageStartDate AS MaterialShortageStartDate,
  _CacheShortageStatistics.MaterialShortageEndDate AS MaterialShortageEndDate,
  _CacheShortageStatistics.MaterialShortageDuration AS MaterialShortageDuration,
  _CacheShortageStatistics.MaterialShortageDurnInWorkdays AS MaterialShortageDurnInWorkdays,
  _CacheShortageStatistics.DaysOfSupplyCoveragePercent AS DaysOfSupplyCoveragePercent,
  _CacheShortageStatistics.MatlMaxCoverageDurnInWorkdays AS MatlMaxCoverageDurnInWorkdays,
  _CacheShortageStatistics.NumberOfShortagesPerSegment AS NumberOfShortagesPerSegment,
  _CacheShortageStatistics.MinAvailQtyOverCompleteHrzn AS MinAvailQtyOverCompleteHrzn,
  _CacheShortageStatistics.MaterialFirstShortageDate AS MaterialFirstShortageDate,
  _CacheShortageStatistics.MaterialFirstShortageDateQty AS MaterialFirstShortageDateQty,
  _CacheShortageStatistics.ReceiptDaysSupplyCriticality AS ReceiptDaysSupplyCriticality,
  CacheMaterial.MaterialProcurementProfile AS MaterialProcurementProfile,
  CacheMaterial.MaterialProcurementCategory AS MaterialProcurementCategory,
  case when CacheMaterial.MRPType <> _MaterialMRPArea.MRPType and _MaterialMRPArea.MRPType <> '' then _MaterialMRPArea.MRPType else CacheMaterial.MRPType end as MRPType AS MRPTypeendasMRPType,
  CacheMaterial.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  CacheMaterial.MaterialPlannedProductionDurn AS MaterialPlannedProductionDurn,
  CacheMaterial.MRPSafetyDuration AS MRPSafetyDuration,
  _MRPMaterial.PlanningTimeFenceInDays AS PlanningTimeFenceInDays,
  CacheMaterial.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  CacheMaterial.MaterialGroup AS MaterialGroup,
  CacheMaterial.MaterialGroupName AS MaterialGroupName,
  CacheMaterial.MRPGroup AS MRPGroup,
  CacheMaterial.PurchasingGroup AS PurchasingGroup,
  CacheMaterial.TotalReplenishmentLeadDuration AS TotalReplenishmentLeadDuration,
  CacheMaterial.MaterialType AS MaterialType,
  CacheMaterial.MaterialTypeName AS MaterialTypeName,
  CacheMaterial.MaterialABCClassification AS MaterialABCClassification,
  CacheMaterial.MaterialReplnmtLeadDurnEndDate AS MaterialReplnmtLeadDurnEndDate,
  CacheMaterial.TotalReplnmtLeadDurnEndDate AS TotalReplnmtLeadDurnEndDate,
  CacheMaterial.ManualPlanningHorizonEndDate AS ManualPlanningHorizonEndDate,
  CacheMaterial.MRPSafetyDurationEndDate AS MRPSafetyDurationEndDate,
  CacheMaterial.LastBufferUpdateDateTime AS LastBufferUpdateDateTime,
  case MRPPlanningSegment.MRPPlanningSegmentType when '20' then _SalesOrder.SoldToParty else '' end as Customer AS SoldToPartyelseendasCustomer,
  case MRPPlanningSegment.MRPPlanningSegmentType when '20' then _SalesOrder._SoldToParty.CustomerName else '' end as CustomerName AS CustomerNameelseendasCustomerName,
  _SupplierCount.NumberOfSupplier AS NumberOfSupplier,
  cast( '' as availabilitychart ) AS AvailabilityChart,
  cast( '' as weeklyavailabilitychart ) AS WeeklyAvailabilityChart,
  _MRPPlant.Language AS PlantLanguage,
  _MRPMaterialStatus.MRPValidMaterialStatus AS MRPValidMaterialStatus,
  _ScheduleAgreementExists.ScheduleAgreementHasReleaseDoc AS ScheduleAgreementHasReleaseDoc,
  case when MRPPlanningSegment.MRPPlanningSegmentType = '24' then case when MRPPlanningSegment._Reservation.ReferenceOrder <> '' then MRPPlanningSegment._Reservation.ReferenceOrder else MRPPlanningSegment._Reservation.PlannedOrder end else MRPPlanningSegment._WBSElement.Project end as ProjectNetwork AS ProjectendasProjectNetwork,
  case MRPPlanningSegment.MRPPlanningSegmentType when '22' then MRPPlanningSegment._WBSElement._Project.ProjectWithCodingMask else '' end as Project AS ProjectWithCodingMaskelseendasProject,
  MRPPlanningSegment._WBSElement.WBSElementInternalID AS WBSElementInternalID,
  case MRPPlanningSegment.MRPPlanningSegmentType when '22' then MRPPlanningSegment._WBSElement.WBSDescription else '' end as WBSDescription AS WBSDescriptionelseendasWBSDescription,
  MRPPlanningSegment.PlanningSegmentDocument AS PlanningSegmentDocument,
  MRPPlanningSegment.PlanningSegmentDocumentItem AS PlanningSegmentDocumentItem,
  _Product.IsMarkedForDeletion AS IsMarkedForDeletion,
  _Product.LowLevelCode AS LowLevelCode,
  cast( case when _AcceptedMaterialShortageCnt.NumberOfAcceptedShortages > 0 then 'X' else '' end as boolean ) AS HasAcceptedShortage,
  _UnitOfMeasure.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  _UnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _UnitOfMeasure.UnitOfMeasure_E AS UnitOfMeasureCommercialName,
  MRPPlanningSegment.NmbrOfPastDueOpeningDateElmnts AS NmbrOfPastDueOpeningDateElmnts,
  MRPPlanningSegment.NumberOfPastDueStartDateElmnts AS NumberOfPastDueStartDateElmnts,
  MRPPlanningSegment.NumberOfPastDueEndDateElements AS NumberOfPastDueEndDateElements,
  MRPPlanningSegment.MaterialHasMRPNote AS MaterialHasMRPNote,
  MRPPlanningSegment.MRPMaterialNoteText AS MRPMaterialNoteText,
  MRPPlanningSegment.NumberOfRescheduleInElements AS NumberOfRescheduleInElements,
  MRPPlanningSegment.NumberOfRescheduleOutElements AS NumberOfRescheduleOutElements,
  MRPPlanningSegment.NumberOfCancelProcesses AS NumberOfCancelProcesses,
  _MRPMasterDataIssue.IssueCount AS IssueCount,
  _MRPMaterial.MRPSafetyStockMethod AS MRPSafetyStockMethod,
  _Product.SegmentationStrategy AS SegmentationStrategy,
  _Product.SegmentationIsRelevant AS SegmentationIsRelevant
FROM I_MRPPlanningSegment AS MRPPlanningSegment
INNER JOIN I_CacheMaterial AS CacheMaterial ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialShortageDefinition AS MaterialShortageDefinition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_TimeDependentStockLevel AS TimedependentStockLevel ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CacheShortageStatistic AS _CacheShortageStatistics ON MRPPlanningSegment.MRPPlant = _CacheShortageStatistics.MRPPlant AND MRPPlanningSegment.Material = _CacheShortageStatistics.Material AND MRPPlanningSegment.MRPArea = _CacheShortageStatistics.MRPArea AND MRPPlanningSegment.MRPPlanningSegment = _CacheShortageStatistics.MRPPlanningSegment AND MRPPlanningSegment.MRPPlanningSegmentType = _CacheShortageStatistics.MRPPlanningSegmentType AND MRPPlanningSegment.MaterialShortageProfile = _CacheShortageStatistics.MaterialShortageProfile AND MaterialShortageDefinition.MaterialShortageProfileCount = _CacheShortageStatistics.MaterialShortageProfileCount AND _CacheShortageStatistics.MaterialShortageDefinitionName != ''  -- association [0..1]
LEFT OUTER JOIN I_CacheMaterial AS _CacheMaterial ON MRPPlant = _CacheMaterial.MRPPlant AND Material = _CacheMaterial.Material AND MRPArea = _CacheMaterial.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_ScheduleAgreementExists AS _ScheduleAgreementExists ON MRPPlant = _ScheduleAgreementExists.Plant AND Material = _ScheduleAgreementExists.Material  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_MRPPlant AS _MRPPlant ON MRPPlant = _MRPPlant.MRPPlant  -- association [1..1]
LEFT OUTER JOIN I_MRPSupplierCount AS _SupplierCount ON MRPPlant = _SupplierCount.MRPPlant AND Material = _SupplierCount.Material AND MRPArea = _SupplierCount.MRPArea AND MRPPlanningSegmentType = _SupplierCount.MRPPlanningSegmentType AND MRPPlanningSegment = _SupplierCount.MRPPlanningSegment  -- association [0..1]
LEFT OUTER JOIN I_CacheSupplier AS _CacheSupplier ON MRPPlant = _CacheSupplier.MRPPlant AND Material = _CacheSupplier.Material AND MRPArea = _CacheSupplier.MRPArea AND MRPPlanningSegmentType = _CacheSupplier.MRPPlanningSegmentType AND MRPPlanningSegment = _CacheSupplier.MRPPlanningSegment  -- association [0..*]
LEFT OUTER JOIN P_AcceptedMaterialShortageCnt AS _AcceptedMaterialShortageCnt ON MRPPlanningSegment.MRPPlant = _AcceptedMaterialShortageCnt.MRPPlant AND MRPPlanningSegment.Material = _AcceptedMaterialShortageCnt.Material AND MRPPlanningSegment.MRPArea = _AcceptedMaterialShortageCnt.MRPArea AND MRPPlanningSegment.MRPPlanningSegment = _AcceptedMaterialShortageCnt.MRPPlanningSegment AND MRPPlanningSegment.MRPPlanningSegmentType = _AcceptedMaterialShortageCnt.MRPPlanningSegmentType AND MRPPlanningSegment.MaterialShortageProfile = _AcceptedMaterialShortageCnt.MaterialShortageProfile AND MaterialShortageDefinition.MaterialShortageProfileCount = _AcceptedMaterialShortageCnt.MaterialShortageProfileCount  -- association [0..1]
LEFT OUTER JOIN I_MRPAvailability AS _MRPAvailability ON MRPPlant = _MRPAvailability.MRPPlant AND Material = _MRPAvailability.Material AND MRPArea = _MRPAvailability.MRPArea AND MRPPlanningSegmentType = _MRPAvailability.MRPPlanningSegmentType AND MRPPlanningSegment = _MRPAvailability.MRPPlanningSegment AND MaterialShortageProfile = _MRPAvailability.MaterialShortageProfile AND MaterialShortageProfileCount = _MRPAvailability.MaterialShortageProfileCount  -- association [0..*]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON PlanningSegmentDocument = _SalesOrder.SalesOrder  -- association [1..1]
LEFT OUTER JOIN I_MRPMaterial AS _MRPMaterial ON MRPPlant = _MRPMaterial.MRPPlant AND Material = _MRPMaterial.Material AND MRPArea = _MRPMaterial.MRPArea  -- association [1..1]
LEFT OUTER JOIN I_MaterialMRPArea AS _MaterialMRPArea ON MRPPlant = _MaterialMRPArea.Plant AND Material = _MaterialMRPArea.Material AND MRPArea = _MaterialMRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN P_ProdnProductHierNode AS _PlanningHierNodeOnePlant ON Material = _PlanningHierNodeOnePlant.Material AND MRPPlant = _PlanningHierNodeOnePlant.MRPPlant AND _PlanningHierNodeOnePlant.ProdnProductHierarchyPurpose = '01' AND _PlanningHierNodeOnePlant.UniversalHierVersValidFrom <= $session.user_date AND _PlanningHierNodeOnePlant.UniversalHierVersValidTo >= $session.user_date  -- association [0..1]
LEFT OUTER JOIN P_ProdnProductHierNode AS _PlanningHierNodeAllPlants ON Material = _PlanningHierNodeAllPlants.Material AND _PlanningHierNodeAllPlants.MRPPlant = '*' AND _PlanningHierNodeAllPlants.ProdnProductHierarchyPurpose = '01' AND _PlanningHierNodeAllPlants.UniversalHierVersValidFrom <= $session.user_date AND _PlanningHierNodeAllPlants.UniversalHierVersValidTo >= $session.user_date  -- association [0..1]
LEFT OUTER JOIN P_ProdnProductHierNode AS _ProductHierNodeAll ON Material = _ProductHierNodeAll.Material AND _ProductHierNodeAll.MRPPlant = '*' AND _ProductHierNodeAll.ProdnProductHierarchyPurpose = '*' AND _ProductHierNodeAll.UniversalHierVersValidFrom <= $session.user_date AND _ProductHierNodeAll.UniversalHierVersValidTo >= $session.user_date  -- association [0..1]
LEFT OUTER JOIN P_MRPMATERIALSTATUS AS _MRPMaterialStatus ON MRPPlanningSegment.MRPPlant = _MRPMaterialStatus.MRPPlant AND MRPPlanningSegment.Material = _MRPMaterialStatus.Material  -- association [0..1]
LEFT OUTER JOIN P_MRPMasterDataIssueCount AS _MRPMasterDataIssue ON Material = _MRPMasterDataIssue.Material AND MRPPlant = _MRPMasterDataIssue.Plant AND MRPArea = _MRPMasterDataIssue.MRPArea  -- association [0..1]
;