C_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 C_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: CMATCOV

CREATE VIEW C_MaterialCoverage AS
SELECT
  Material.MRPPlant AS MRPPlant,
  Material.MRPArea AS MRPArea,
  Material.Material AS Material,
  Material.MRPPlanningSegmentType AS MRPPlanningSegmentType,
  Material.MRPPlanningSegment AS MRPPlanningSegment,
  Material.MaterialShortageProfile AS MaterialShortageProfile,
  Material.MaterialShortageProfileCount AS MaterialShortageProfileCount,
  Material.FactoryCalendar AS FactoryCalendar,
  concat(Material.Material,concat(Material.MRPPlant,concat(Material.MRPArea,concat(Material.MRPPlanningSegmentType,Material.MRPPlanningSegmentExternalCode)))) AS MaterialSelectionIdentifier,
  _PlantVH.PlantName AS PlantName,
  _MRPAreaVH.MRPAreaText AS MRPAreaText,
  Material.MaterialName AS MaterialName,
  Material.PlantLanguage AS PlantLanguage,
  Material.MaterialABCClassification AS MaterialABCClassification,
  _MaterialStatusText.MRPValidMaterialStatusName AS MRPValidMaterialStatusName,
  Material.MRPValidMaterialStatus AS MRPValidMaterialStatus,
  cast( '' as md_supplier) AS Supplier,
  cast ('' as suppliername_2) AS SupplierName,
  Material.NumberOfSupplier AS NumberOfSupplier,
  Material.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  Material.WeeklyAvailabilityChart AS WeeklyAvailabilityChart,
  _PurchasingGroupVH.PurchasingGroupName AS PurchasingGroupName,
  Material.MaterialType AS MaterialType,
  Material.MaterialTypeName AS MaterialTypeName,
  Material.MaterialGroup AS MaterialGroup,
  Material.MaterialGroupName AS MaterialGroupName,
  cast(concat(Material.MaterialShortageProfile, Material.MaterialShortageProfileCount) as materialshortagedefinition) AS MaterialShortageDefinition,
  Material.MaterialShortageDefinitionName AS MaterialShortageDefinitionName,
  Material.MRPController AS MRPController,
  _MRPController.MRPControllerName AS MRPControllerName,
  Material.IsMarkedForDeletion AS IsMarkedForDeletion,
  Material.LowLevelCode AS LowLevelCode,
  Material.HasAcceptedShortage AS HasAcceptedShortage,
  Material.TotalReplnmtLeadDurnEndDate AS TotalReplnmtLeadDurnEndDate,
  Material.ManualPlanningHorizonEndDate AS ManualPlanningHorizonEndDate,
  Material.MRPSafetyDurationEndDate AS MRPSafetyDurationEndDate,
  Material.MaterialShortageStartDate AS MaterialShortageStartDate,
  Material.MaterialShortageEndDate AS MaterialShortageEndDate,
  Material.MaterialPlannedProductionDurn AS MaterialPlannedProductionDurn,
  Material.MRPSafetyDuration AS MRPSafetyDuration,
  Material.TotalReplenishmentLeadDuration AS TotalReplenishmentLeadDuration,
  Material.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  Material.PlanningTimeFenceInDays AS PlanningTimeFenceInDays,
  Material.EvaluationHorizonInDays AS EvaluationHorizonInDays,
  Material.DaysOfSupplyDuration AS DaysOfSupplyDuration,
  Material.IntraDaySupplyDuration AS IntraDaySupplyDuration,
  Material.TimeTillShortageInCalendarDays AS TimeTillShortageInCalendarDays,
  Material.MaterialShortageDuration AS MaterialShortageDuration,
  Material.MaterialShortageDurnInWorkdays AS MaterialShortageDurnInWorkdays,
  Material.DaysOfSupplyCriticality AS DaysOfSupplyCriticality,
  Material.StockDaysSupplyDuration AS StockDaysSupplyDuration,
  Material.StockDaysSupplyCriticality AS StockDaysSupplyCriticality,
  Material.StockIntraDaySupplyDuration AS StockIntraDaySupplyDuration,
  Material.MRPAvailableStockQty AS MRPAvailableStockQty,
  cast (Material.MaterialShortageQuantity as materialshortageqty) AS MaterialShortageQuantity,
  Material.HasShortageTotalReplnmtLead AS HasShortageTotalReplnmtLead,
  Material.HasShortageManualPlanHorizon AS HasShortageManualPlanHorizon,
  Material.HasShortageMRPSafetyDuration AS HasShortageMRPSafetyDuration,
  case when _MRPTypeText[1: Language = $session.system_language ].MRPTypeName != '' then _MRPTypeText[1: Language = $session.system_language ].MRPTypeName when _MRPTypeTextPlant.MRPTypeName != '' then _MRPTypeTextPlant.MRPTypeName when _MRPTypeText[1: Language = 'E' ].MRPTypeName != '' then _MRPTypeText[1: Language = 'E' ].MRPTypeName else Material.MRPType end as MRPTypeName AS MRPTypeendasMRPTypeName,
  Material.MaterialProcurementProfile AS MaterialProcurementProfile,
  Material.MaterialProcurementCategory AS MaterialProcurementCategory,
  Material.MRPGroup AS MRPGroup,
  case when _MRPGroup._Text[1: Language = $session.system_language ].MRPGroupName != '' then _MRPGroup._Text[1: Language = $session.system_language ].MRPGroupName when _MRPGroupTextPlant.MRPGroupName != '' then _MRPGroupTextPlant.MRPGroupName when _MRPGroup._Text[1: Language = 'E' ].MRPGroupName != '' then _MRPGroup._Text[1: Language = 'E' ].MRPGroupName else Material.MRPGroup end as MRPGroupName AS MRPGroupendasMRPGroupName,
  Material.MRPSafetyStockMethod AS MRPSafetyStockMethod,
  _SafetyStockMethodVH.SafetyStockMethodName AS MRPSafetyStockMethodText,
  Material.SegmentationStrategy AS SegmentationStrategy,
  cast ( Material.SegmentationIsRelevant as sgt_rel1 preserving type ) AS SegmentationIsRelevant,
  cast('' as boolean preserving type) AS SegmentationIsEmpty,
  Material.ProductionProductHierarchy AS ProductionProductHierarchy,
  _HierText.ProdUnivHierarchyText AS ProductHierarchyText,
  Material.ProductionProductHierarchyNode AS ProductionProductHierarchyNode,
  _HierNodeText.ProductHierarchyNodeText AS ProductHierarchyNodeText,
  Material.IssueCount AS IssueCount,
  Material.NumberOfPastDueStartDateElmnts AS NumberOfPastDueStartDateElmnts,
  Material.NumberOfPastDueEndDateElements AS NumberOfPastDueEndDateElements,
  Material.NmbrOfPastDueOpeningDateElmnts + Material.NumberOfPastDueStartDateElmnts + Material.NumberOfPastDueEndDateElements AS NumberOfPastDueElements,
  Material.MRPMaterialNoteText AS MRPMaterialNoteText,
  Material.NumberOfRescheduleOutElements AS NumberOfRescheduleOutElements,
  Material.NumberOfCancelProcesses AS NumberOfCancelProcesses,
  Material.NumberOfRescheduleInElements + Material.NumberOfRescheduleOutElements + Material.NumberOfCancelProcesses AS NumberOfRescheduleElements,
  _LastMRPRun.MaterialLastMRPDateTime AS MaterialLastMRPDateTime,
  Material.MRPResultIsProcessed AS MRPResultIsProcessed,
  _MRPAcknowledgeResultVH.MRPResultProcessingText AS MRPResultProcessingText,
  Material._UnitOfMeasure AS _UnitOfMeasure
FROM I_MRPMaterialCoverage AS Material
INNER JOIN also AS filter ON /* join condition not captured in parsed metadata */
INNER JOIN I_SDMAreaOfResponsibility AS SDMAreaOfResponsibility ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_CacheSupplier AS _Supplier ON MRPPlant = _Supplier.MRPPlant AND Material = _Supplier.Material AND MRPArea = _Supplier.MRPArea AND MRPPlanningSegmentType = _Supplier.MRPPlanningSegmentType AND MRPPlanningSegment = _Supplier.MRPPlanningSegment  -- association [0..*]
LEFT OUTER JOIN C_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 C_MRPController AS _MRPController ON MRPPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_MRPType AS _MRPType ON MRPType = _MRPType.MRPType  -- association [1..1]
LEFT OUTER JOIN I_MRPTypeText AS _MRPTypeText ON MRPType = _MRPTypeText.MRPType  -- association [0..*]
LEFT OUTER JOIN I_MRPTypeText AS _MRPTypeTextPlant ON MRPType = _MRPTypeTextPlant.MRPType AND PlantLanguage = _MRPTypeTextPlant.Language  -- association [0..1]
LEFT OUTER JOIN I_MatlProcurementCategoryText AS _ProcurementCategoryTextPlant ON MaterialProcurementCategory = _ProcurementCategoryTextPlant.MaterialProcurementCategory AND PlantLanguage = _ProcurementCategoryTextPlant.Language  -- association [0..1]
LEFT OUTER JOIN I_MatlProcurementProfileText AS _ProcurementProfileTextPlant ON MaterialProcurementProfile = _ProcurementProfileTextPlant.MaterialProcurementProfile AND MRPPlant = _ProcurementProfileTextPlant.Plant AND PlantLanguage = _ProcurementProfileTextPlant.Language  -- association [0..1]
LEFT OUTER JOIN I_MRPGroup AS _MRPGroup ON MRPGroup = _MRPGroup.MRPGroup AND MRPPlant = _MRPGroup.MRPPlant  -- association [0..1]
LEFT OUTER JOIN I_MRPGroupText AS _MRPGroupTextPlant ON MRPGroup = _MRPGroupTextPlant.MRPGroup AND MRPPlant = _MRPGroupTextPlant.MRPPlant  -- association [0..1]
LEFT OUTER JOIN I_MatlProcurementCategory AS _MatlProcurementCategory ON MaterialProcurementCategory = _MatlProcurementCategory.MaterialProcurementCategory  -- association [1..1]
LEFT OUTER JOIN I_MatlProcurementProfile AS _MatlProcurementProfile ON MaterialProcurementProfile = _MatlProcurementProfile.MaterialProcurementProfile AND MRPPlant = _MatlProcurementProfile.Plant  -- association [1..1]
LEFT OUTER JOIN C_PlantVH AS _PlantVH ON MRPPlant = _PlantVH.Plant  -- association [1..1]
LEFT OUTER JOIN C_MRPAreaValHelp AS _MRPAreaVH ON MRPArea = _MRPAreaVH.MRPArea AND MRPPlant = _MRPAreaVH.Plant  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupVH ON PurchasingGroup = _PurchasingGroupVH.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_ProdUniversalHierarchyText_2 AS _HierText ON ProductionProductHierarchy = _HierText.ProdUnivHierarchy AND _HierText.ProdHierarchyValidityEndDate >= $session.user_date AND _HierText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductHierarchyNormalNodeT AS _HierNodeText ON ProductionProductHierarchyNode = _HierNodeText.ProductHierarchyNode AND _HierNodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MRPMaterialStatusText AS _MaterialStatusText ON MRPValidMaterialStatus = _MaterialStatusText.MRPValidMaterialStatus AND _MaterialStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SafetyStockMethodVH AS _SafetyStockMethodVH ON MRPSafetyStockMethod = _SafetyStockMethodVH.SafetyStockMethod  -- association [0..1]
LEFT OUTER JOIN E_Product AS _MatExtension ON Material = _MatExtension.Product  -- association [0..1]
LEFT OUTER JOIN E_Productplant AS _PlantExtension ON Material = _PlantExtension.Product AND MRPPlant = _PlantExtension.Plant  -- association [0..1]
LEFT OUTER JOIN I_MRPAreaPlanningFileEntry AS _LastMRPRun ON Material = _LastMRPRun.Material AND MRPPlant = _LastMRPRun.Plant AND MRPArea = _LastMRPRun.MRPArea AND _LastMRPRun.MRPPlanningScenario = '000'  -- association [0..1]
LEFT OUTER JOIN I_MRPAcknowledgeResultVH AS _MRPAcknowledgeResultVH ON MRPResultIsProcessed = _MRPAcknowledgeResultVH.MRPResultIsProcessed AND _MRPAcknowledgeResultVH.Language = $session.system_language  -- association [0..1]
;