P_ProductionOrderQuickView

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 P_ProductionOrderQuickView.
-- 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: PPRODNORDQV

CREATE VIEW P_ProductionOrderQuickView AS
SELECT
  ManufacturingOrder AS OrderID,
  ManufacturingOrderItem,
  ProductionOrderItem.Material AS Material,
  MRPPlant,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  _MfgOrderType._Text[1: Language = $session.system_language].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  MfgOrderReleasedCode,
  MfgOrderPlannedStartDate,
  MfgOrderScheduledReleaseDate,
  MfgOrderScheduledStartDate,
  MfgOrderScheduledEndDate,
  MfgOrderPlannedEndDate,
  MaterialGoodsReceiptDuration,
  MfgOrderPlannedTotalQty,
  _MfgOrder.ExpectedDeviationQuantity AS ExpectedDeviationQuantity,
  MfgOrderPlannedScrapQty,
  _MfgOrder.ActualDeliveredQuantity AS MfgOrderItemGoodsReceiptQty,
  (MfgOrderPlannedTotalQty - _MfgOrder.ExpectedDeviationQuantity - MfgOrderPlannedScrapQty - _MfgOrder.ActualDeliveredQuantity) AS MRPElementOpenQuantity,
  ProductionOrderItem.BaseUnit AS BaseUnit,
  ProductionPlant,
  _MfgOrder._Plant.PlantName AS ProductionPlantName,
  ProductionVersion,
  _ProductionVersion.ProductionVersionText AS ProductionVersionText,
  _ProdVersion.ProductionLine AS ProductionLine,
  _MfgOrder.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  ProductionSupervisor,
  _ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  MRPController,
  _MRPCtrlr.MRPControllerName AS MRPControllerName,
  _MRPCtrlr.InternalContactName AS InternalContactPersonName,
  _MRPCtrlr.PhoneNumber AS InternalContactPhoneNumber,
  _MRPCtrlr.EmailAddress AS InternalContactEmailAddress,
  Reservation,
  _ReservationItem.MatlCompRequirementDate AS RequirementDate,
  _ReservationItem.ResvnItmRequiredQtyInBaseUnit AS OrderedQuantity,
  _ReservationItem.ResvnItmWithdrawnQtyInBaseUnit AS WithdrawnQuantity,
  (_ReservationItem.ResvnItmRequiredQtyInBaseUnit - _ReservationItem.ResvnItmWithdrawnQtyInBaseUnit) AS OpenQuantity,
  _ProductSupplyPlanning.InHouseProductionTime AS MaterialPlannedProductionDurn,
  _ProductSupplyPlanning.TotalReplenishmentLeadTime AS TotalReplenishmentLeadDuration,
  _ProductSupplyPlanning.FixedLotSizeQuantity AS FixedLotSizeQuantity,
  _ProductSupplyPlanning.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  _ProductSupplyPlanning.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  _ProductSupplyPlanning.LotSizeRoundingQuantity AS LotSizeRoundingQuantity,
  _ProductSupplyPlanning.RoundingProfile AS RoundingProfile,
  _RoundingProfile[ 1: Language = $session.system_language ].MaterialRoundingProfileName AS MaterialRoundingProfileName,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  _WBSElement.WBSElement AS WBSElement,
  ProductionOrderItem._Material AS _Material
FROM I_MfgOrderItem AS ProductionOrderItem
LEFT OUTER JOIN I_ReservationItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ManufacturingOrderItem = _ReservationItem.ReservationItem  -- association [0..1]
LEFT OUTER JOIN P_DDMRPController AS _MRPCtrlr ON MRPPlant = _MRPCtrlr.Plant AND MRPController = _MRPCtrlr.MRPController  -- association [0..1]
LEFT OUTER JOIN I_RoundingPrfText AS _RoundingProfile ON RoundingProfile = _RoundingProfile.MaterialRoundingProfile AND MRPPlant = _RoundingProfile.Plant  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProdVersion ON Material = _ProdVersion.Material AND MRPPlant = _ProdVersion.Plant AND ProductionVersion = _ProdVersion.ProductionVersion  -- association [0..1]
;