I_MRPUncoveredDemand

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_MRPUncoveredDemand.
-- 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.

CREATE VIEW I_MRPUncoveredDemand AS
SELECT
  SalesDemand.MRPPlant AS MRPPlant,
  SalesDemand.MRPArea AS MRPArea,
  SalesDemand.Material AS Material,
  SalesDemand.MRPPlanningSegment AS MRPPlanningSegment,
  cast( SalesDemand.MRPPlanningSegmentType as plaab ) AS MRPPlanningSegmentType,
  SalesDemand.MaterialShortageProfile AS MaterialShortageProfile,
  SalesDemand.MaterialShortageProfileCount AS MaterialShortageProfileCount,
  SalesDemand.MRPElement AS MRPElement,
  SalesDemand.MRPElementItem AS MRPElementItem,
  SalesDemand.MRPElementScheduleLine AS MRPElementScheduleLine,
  SalesDemand.MRPElementCategory AS MRPElementCategory,
  _Plant.PlantName AS PlantName,
  SalesDemand.PlanningSegmentDocument AS PlanningSegmentDocument,
  SalesDemand.PlanningSegmentDocumentItem AS PlanningSegmentDocumentItem,
  SalesDemand.FactoryCalendar AS FactoryCalendar,
  SalesDemand.MaterialName AS MaterialName,
  SalesDemand.MaterialSafetyStockQty AS MaterialSafetyStockQty,
  SalesDemand.MRPController AS MRPController,
  SalesDemand.MaterialProcurementCategory AS MaterialProcurementCategory,
  SalesDemand.MaterialBaseUnit AS MaterialBaseUnit,
  SalesDemand.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  SalesDemand.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  SalesDemand.MaterialReplnmtLeadDurnEndDate AS MaterialReplnmtLeadDurnEndDate,
  SalesDemand.TotalReplnmtLeadDurnEndDate AS TotalReplnmtLeadDurnEndDate,
  SalesDemand.ManualPlanningHorizonEndDate AS ManualPlanningHorizonEndDate,
  SalesDemand.MRPSafetyDurationEndDate AS MRPSafetyDurationEndDate,
  SalesDemand.ProductionSupervisor AS ProductionSupervisor,
  SalesDemand.MRPElementAvailyOrRqmtDate AS MRPElementAvailyOrRqmtDate,
  cast ( -1 * SalesDemand.MRPElementOpenQuantity as abap.dec( 20, 3 ) ) AS MRPElementOpenQuantity,
  SalesDemand.SourceMRPElementCategory AS SourceMRPElementCategory,
  SalesDemand.SourceMRPElement AS SourceMRPElement,
  SalesDemand.SourceMRPElementItem AS SourceMRPElementItem,
  SalesDemand.MRPElementUncoveredQuantity AS MRPElementUncoveredQuantity,
  SalesDemand.MRPElementDelayedQuantity AS MRPElementDelayedQuantity,
  SalesDemand.MRPElementTypeImportance AS MRPElementTypeImportance,
  SalesDemand.MaximumDelayDate AS MaximumDelayDate,
  SalesDemand.MaximumDelayInDays AS MaximumDelayInDays,
  SalesDemand.MaximumDelayInWorkdays AS MaximumDelayInWorkdays,
  SalesDemand.ProcurementProgress AS ProcurementProgress,
  SalesDemand.StorageLocation AS StorageLocation,
  SalesDemand.IssuingOrReceivingPlant AS IssuingOrReceivingPlant,
  SalesDemand.CompanyCurrency AS CompanyCurrency,
  SalesDemand.CurrencyDecimals AS CurrencyDecimals,
  SalesDemand.OrderCategory AS MRPOrderCategory,
  SalesDemand.OrderType AS OrderType,
  SalesDemand.OrderQuantity AS OrderQuantity,
  SalesDemand.DocumentCurrency AS DocumentCurrency,
  SalesDemand.NetValueInDocCurrency AS NetValueInDocCurrency,
  SalesDemand.OrderCreationDate AS OrderCreationDate,
  SalesDemand.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesDemand.DeliveryPriority AS DeliveryPriority,
  SalesDemand.DeliveryDateQuantityIsFixed AS DeliveryDateQuantityIsFixed,
  SalesDemand.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  SalesDemand.RequestedLoadingDate AS RequestedLoadingDate,
  SalesDemand.RequestedGoodsIssueDate AS RequestedGoodsIssueDate,
  SalesDemand.SalesOrganization AS SalesOrganization,
  SalesDemand.DistributionChannel AS DistributionChannel,
  SalesDemand.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesDemand.Customer AS Customer,
  _Customer.BPCustomerName AS CustomerName,
  _CustomerSalesArea.CustomerGroup AS CustomerGroup,
  _CustomerSalesArea.CustomerABCClassification AS CustomerClassification,
  SalesDemand.DeliveryBlockReason AS DeliveryBlockReason,
  SalesDemand.DeliveryIsBlocked AS MRPDeliveryIsBlocked,
  SalesDemand.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  SalesDemand.DeliveryBlockReasonText AS DeliveryBlockReasonText,
  SalesDemand.DeliveryPriorityDesc AS DeliveryPriorityDesc,
  SalesDemand.Division AS Division,
  case when SalesDemand.MRPType <> _MaterialMRPArea.MRPType and _MaterialMRPArea.MRPType <> '' then _MaterialMRPArea.MRPType else SalesDemand.MRPType end as MRPType AS MRPTypeendasMRPType,
  _MRPArea.MRPAreaText AS MRPAreaText,
  _MRPController.MRPControllerName AS MRPControllerName,
  _Plant.AddressID AS AddressID,
  SalesDemand.ShipToParty AS ShipToParty,
  TransferDemand.Customer AS SoldToParty
FROM I_MRPSalesDemand AS SalesDemand
LEFT OUTER JOIN I_CustomerSalesArea AS _CustomerSalesArea ON Customer = _CustomerSalesArea.Customer AND SalesOrganization = _CustomerSalesArea.SalesOrganization AND DistributionChannel = _CustomerSalesArea.DistributionChannel AND Division = _CustomerSalesArea.Division  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON MRPPlant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON MRPController = _MRPController.MRPController AND MRPPlant = _MRPController.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialMRPArea AS _MaterialMRPArea ON MRPPlant = _MaterialMRPArea.Plant AND Material = _MaterialMRPArea.Material AND MRPArea = _MaterialMRPArea.MRPArea  -- association [0..1]
-- UNION with additional select branch(es): I_MRPTransferDemand
;