A_ProcessOrder_2

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_ProcessOrder_2.
-- 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_ProcessOrder_2 AS
SELECT
  cast(ManufacturingOrder as co_bid preserving type) AS ManufacturingOrder,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  _LongText.PlainLongText AS OrderLongText,
  ManufacturingOrderImportance,
  OrderIsCreated,
  OrderIsReleased,
  OrderIsPrinted,
  OrderIsConfirmed,
  OrderIsPartiallyConfirmed,
  OrderIsDelivered,
  OrderIsDeleted,
  OrderIsPreCosted,
  SettlementRuleIsCreated,
  OrderIsPartiallyReleased,
  OrderIsLocked,
  OrderIsTechnicallyCompleted,
  OrderIsClosed,
  OrderIsPartiallyDelivered,
  OrderIsMarkedForDeletion,
  SettlementRuleIsCrtedManually,
  OrderIsScheduled,
  OrderHasGeneratedOperations,
  OrderIsToBeHandledInBatches,
  MaterialAvailyIsNotChecked,
  CreationDate AS MfgOrderCreationDate,
  CreationTime AS MfgOrderCreationTime,
  Material,
  StorageLocation,
  GoodsRecipientName,
  UnloadingPointName,
  InventoryUsabilityCode,
  MaterialGoodsReceiptDuration,
  QuantityDistributionKey,
  StockSegment,
  MfgOrderInternalID AS OrderInternalBillOfOperations,
  ProductionPlant,
  PlanningPlant AS Plant,
  MRPArea,
  MRPController,
  ProductionSupervisor,
  ProductionVersion,
  PlannedOrder,
  SalesOrder,
  SalesOrderItem,
  BasicSchedulingType,
  ManufacturingObject,
  ProductConfiguration,
  OrderSequenceNumber,
  BusinessArea,
  CompanyCode,
  ProfitCenter,
  ActualCostsCostingVariant,
  PlannedCostsCostingVariant,
  FunctionalArea,
  MfgOrderPlannedStartDate,
  MfgOrderPlannedStartTime,
  MfgOrderPlannedEndDate,
  MfgOrderPlannedEndTime,
  MfgOrderScheduledStartDate,
  MfgOrderScheduledStartTime,
  MfgOrderScheduledEndDate,
  MfgOrderScheduledEndTime,
  MfgOrderActualReleaseDate,
  ProductionUnit,
  _ProductionUnit.UnitOfMeasureISOCode AS ProductionUnitISOCode,
  _ProductionUnit.UnitOfMeasureSAPCode AS ProductionUnitSAPCode,
  MfgOrderPlannedTotalQty AS TotalQuantity,
  MfgOrderPlannedScrapQty,
  MfgOrderConfirmedYieldQty,
  _SalesDocument._SoldToParty.CustomerName AS CustomerName,
  _WBSElementBasicData.WBSElementExternalID AS WBSElementExternalID
FROM I_MfgOrderWithStatus
LEFT OUTER JOIN A_ProcessOrderOperation_2 AS _ProcessOrderOperation ON ManufacturingOrder = _ProcessOrderOperation.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN A_ProcessOrderComponent_2 AS _ProcessOrderComponent ON ManufacturingOrder = _ProcessOrderComponent.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN A_ProcessOrderItem_2 AS _ProcessOrderItem ON ManufacturingOrder = _ProcessOrderItem.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN A_ProcessOrderStatus_2 AS _ProcessOrderStatus ON ManufacturingOrder = _ProcessOrderStatus.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN A_ProcessOrderProdnRsceTools_2 AS _ProcessProdnRsceTools ON ManufacturingOrder = _ProcessProdnRsceTools.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN E_LogisticsOrder AS _Extension ON ManufacturingOrder = _Extension.OrderID  -- association [1..1]
;