A_ProductionOrder

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 A_ProductionOrder.
-- 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 A_ProductionOrder AS
SELECT
  ManufacturingOrder AS ProductionOrder,
  ProductionPlant,
  OrderInternalBillOfOperations,
  OrderIsCreated,
  OrderIsReleased,
  OrderIsPrinted,
  OrderIsConfirmed,
  OrderIsPartiallyConfirmed,
  OrderIsDelivered,
  OrderIsDeleted,
  OrderIsPreCosted,
  SettlementRuleIsCreated,
  OrderIsPartiallyReleased,
  OrderIsLocked,
  OrderIsTechnicallyCompleted,
  OrderIsClosed,
  OrderIsPartiallyDelivered,
  OrderIsMarkedForDeletion,
  SettlementRuleIsCrtedManually,
  OrderIsScheduled,
  OrderHasGeneratedOperations,
  OrderIsToBeHandledInBatches,
  MaterialAvailyIsNotChecked,
  Material,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  ProductionUnit,
  MfgOrderPlannedTotalQty AS TotalQuantity,
  ManufacturingOrderType,
  MRPArea,
  ObjectInternalID AS ManufacturingObject,
  MRPPlant AS Plant,
  MfgOrderConfirmedYieldQty,
  MfgOrderPlannedStartDate,
  MfgOrderPlannedStartTime,
  MfgOrderPlannedEndDate,
  MfgOrderPlannedEndTime,
  MfgOrderScheduledStartDate,
  MfgOrderScheduledStartTime,
  MfgOrderScheduledEndDate,
  MfgOrderScheduledEndTime,
  SalesOrder,
  SalesOrderItem,
  PlannedOrder,
  _PlannedOrder._Customer.CustomerName AS CustomerName,
  cast( _WBSElement.WBSElement as rcpe_ps_posnr preserving type ) AS WBSElement,
  WBSElementInternalID,
  _WBSElement.WBSDescription AS WBSDescription,
  CompanyCode,
  FunctionalArea,
  PlannedCostsCostingVariant,
  ActualCostsCostingVariant,
  _MRPController.UserID AS UserID,
  ProductionVersion,
  MRPController,
  ProductionSupervisor,
  ManufacturingOrderCategory,
  BusinessArea,
  MfgOrderPlannedScrapQty,
  ProfitCenter,
  ManufacturingOrderImportance,
  OrderSequenceNumber,
  MfgOrderCreationDate,
  MfgOrderCreationTime,
  MfgOrderActualReleaseDate,
  GoodsRecipientName,
  MaterialGoodsReceiptDuration,
  InventoryUsabilityCode,
  UnloadingPointName,
  QuantityDistributionKey,
  StockSegment,
  StorageLocation,
  BasicSchedulingType
FROM I_MfgOrderDuration
LEFT OUTER JOIN A_ProductionOrderOperation AS _ProductionOrderOperation ON ProductionOrder = _ProductionOrderOperation.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN A_ProductionOrderComponent AS _ProductionOrderComponent ON ProductionOrder = _ProductionOrderComponent.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN A_ProductionOrderItem AS _ProductionOrderItem ON ProductionOrder = _ProductionOrderItem.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN A_ProductionOrderStatus AS _ProductionOrderStatus ON ProductionOrder = _ProductionOrderStatus.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN A_ProductionRsceTools AS _ProductionRsceTools ON ProductionOrder = _ProductionRsceTools.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON ProductionOrder = _Extension.OrderID  -- association [1..1]
;