I_CacheMRPMfgOrder

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_CacheMRPMfgOrder.
-- 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: ICACHEMRPMFGORD

CREATE VIEW I_CacheMRPMfgOrder AS
SELECT
  MfgOrderItem.MRPPlant AS MRPPlant,
  MfgOrderItem.OrderID AS MRPElement,
  cast(MfgOrderItem.OrderItem as abap.char( 4 )) AS MRPElementItem,
  MRPPlanningSegment.MRPPlanningSegment AS MRPPlanningSegment,
  MRPPlanningSegment.MRPPlanningSegmentType AS MRPPlanningSegmentType,
  ShortageDefinition.MaterialShortageProfile AS MaterialShortageProfile,
  ShortageDefinition.MaterialShortageProfileCount AS MaterialShortageProfileCount,
  MfgOrderItem.Material AS Material,
  MfgOrder.MRPController AS MRPController,
  _CacheMaterial.FactoryCalendar AS FactoryCalendar,
  MfgOrderItem.ProductionPlant AS ProductionPlant,
  MfgOrderItem.MRPArea AS MRPArea,
  MfgOrderItem.StorageLocation AS StorageLocation,
  MfgOrder.ManufacturingOrderType AS ManufacturingOrderType,
  MfgOrder.ManufacturingOrderText AS ManufacturingOrderText,
  _CacheMaterial.MaterialProcurementCategory AS MaterialProcurementCategory,
  cast(_CacheSupDemItem.MaximumDelayInWorkdays as materialdelayinworkdays preserving type) AS LateSupplyLatenessWorkdays,
  _ProdDemandAggr.NumberOfUncoveredDemandItems AS NumberOfUncoveredDemandItems,
  cast(MfgOrderItem.ItemQuantity - MfgOrderItem.MfgOrderItemGoodsReceiptQty - MfgOrderItem.MfgOrderItemActualDeviationQty as mrpelementopenquantity) AS MRPElementOpenQuantity,
  _ProdDemandAggr.MaximumUncoveredQuantity AS MaximumUncoveredQuantity,
  _ProdDemandAggr.MaximumDelayedQuantity AS MaximumDelayedQuantity,
  MfgOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  coalesce(_CacheSupDemItem.MRPElementDelayedQuantity, 0) AS MRPElementDelayedQuantity,
  MfgOrder.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  MfgOrder.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  MfgOrder.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  MfgOrder.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  MfgOrder.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  MfgOrder.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  MfgOrder.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  MfgOrder.MfgOrderCreationDate AS MfgOrderCreationDate,
  MfgOrder.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  MfgOrder.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  MfgOrderItem.PlannedEndDate AS MRPElementAvailyOrRqmtDate,
  MfgOrder.MfgOrderPlannedReleaseDate AS MfgOrderPlannedReleaseDate,
  _CacheMaterial.MaterialReplnmtLeadDurnEndDate AS MaterialReplnmtLeadDurnEndDate,
  _CacheSupDemItem.MaximumDelayDate AS MaximumDelayDate,
  MfgOrder._ProductionVersion.ProductionLine AS ProductionLine,
  MfgOrder.ProductionVersion AS ProductionVersion,
  MfgOrder._ProductionVersion.ProductionVersionText AS ProductionVersionText,
  MfgOrder.ProductionSupervisor AS ProductionSupervisor,
  MfgOrderItem.OrderIsReleased AS OrderIsReleased,
  concat( _ShortageDefinition.MaterialShortageProfile, cast(_ShortageDefinition.MaterialShortageProfileCount as abap.char(3))) AS ComponentShortageDefinition,
  cast( 0 as durnplndstatustotodayinwrkdays) AS DurnPlndStatusToTodayInWrkdays,
  MfgOrder.ProductionUnit AS ProductionUnit,
  _UnitOfMeasure.UnitOfMeasureNumberOfDecimals AS UnitOfMeasureNumberOfDecimals,
  _UnitOfMeasure.UnitOfMeasureDspNmbrOfDcmls AS UnitOfMeasureDspNmbrOfDcmls,
  MfgOrderItem.MfgOrderItemQtyToBaseQtyDnmntr AS MfgOrderItemQtyToBaseQtyDnmntr,
  MfgOrderItem.MfgOrderItemQtyToBaseQtyNmrtr AS MfgOrderItemQtyToBaseQtyNmrtr,
  MfgOrderItem.InventorySpecialStockType AS InventorySpecialStockType,
  MRPPlanningSegment._Reservation.MaterialCompIsProcuredDirectly AS MaterialCompIsProcuredDirectly,
  case when MRPPlanningSegment.MRPPlanningSegmentType = '24' then case when MRPPlanningSegment._Reservation.ReferenceOrder <> '' then MRPPlanningSegment._Reservation.ReferenceOrder else MRPPlanningSegment._Reservation.PlannedOrder end else _WBSElement._Project.Project end as ProjectNetwork AS ProjectendasProjectNetwork,
  _WBSElement.WBSElementExternalID AS WBSElement,
  MRPPlanningSegment.PlanningSegmentDocument AS PlanningSegmentDocument,
  MRPPlanningSegment.PlanningSegmentDocumentItem AS PlanningSegmentDocumentItem,
  MfgOrder.Reservation AS Reservation,
  MfgOrderItem._Order AS _Order,
  MfgOrderItem._MRPPlant AS _MRPPlant,
  MfgOrderItem._Material AS _Material,
  MfgOrder._MfgOrderType AS _MfgOrderType,
  MfgOrderItem._ProductionPlant AS _ProductionPlant,
  MfgOrderItem._StorageLocation AS _StorageLocation
FROM I_MRPMfgOrderItem AS MfgOrderItem
INNER JOIN I_ManufacturingOrder AS MfgOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_MRPPlanningSegment AS MRPPlanningSegment ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialShortageDefinition AS ShortageDefinition ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_MRPProdDemandAggregation AS _ProdDemandAggr ON MfgOrder.ManufacturingOrder = _ProdDemandAggr.SourceMRPElement AND MfgOrderItem.MRPPlanningSegmentType = _ProdDemandAggr.MRPPlanningSegmentType AND MfgOrderItem.MRPPlanningSegment = _ProdDemandAggr.MRPPlanningSegment AND ShortageDefinition.MaterialShortageProfile = _ProdDemandAggr.MaterialShortageProfile AND ( _ProdDemandAggr.SourceMRPElementCategory = 'BR' OR _ProdDemandAggr.SourceMRPElementCategory = 'FE' )  -- association [0..*]
LEFT OUTER JOIN I_CacheSupplyDemandItem AS _CacheSupDemItem ON MaterialShortageProfile = _CacheSupDemItem.MaterialShortageProfile AND MaterialShortageProfileCount = _CacheSupDemItem.NumberOfShortages AND MRPElement = _CacheSupDemItem.MRPElement AND MRPPlant = _CacheSupDemItem.MRPPlant AND Material = _CacheSupDemItem.Material AND MRPPlanningSegmentType = _CacheSupDemItem.MRPPlanningSegmentType AND MRPPlanningSegment = _CacheSupDemItem.MRPPlanningSegment AND ( _CacheSupDemItem.MRPElementCategory = 'BR' OR _CacheSupDemItem.MRPElementCategory = 'FE' )  -- 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_WBSElementBasicData AS _WBSElement ON MfgOrderItem.WBSElementInternalID = _WBSElement.WBSElementInternalID AND MfgOrderItem.InventorySpecialStockType = 'Q'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON MaterialBaseUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_MaterialShortageDefinition AS _ShortageDefinition ON MaterialShortageProfile = _ShortageDefinition.MaterialShortageProfile AND _ShortageDefinition.HasMfgOrderComponentCheckRule = 'X'  -- association [0..1]
;