I_ProcessOrderMgmtWorkList

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_ProcessOrderMgmtWorkList.
-- 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: IPROCORDMGMTLIST

CREATE VIEW I_ProcessOrderMgmtWorkList AS
SELECT
  ProcessOrder,
  ManufacturingOrderText,
  ManufacturingOrderCategory,
  ManufacturingOrderType,
  ManufacturingOrderTypeName,
  Material,
  MaterialName,
  MaterialGroup,
  MaterialGroupName,
  MaterialType,
  MaterialTypeName,
  MfgOrderInternalID AS OrderInternalBillOfOperations,
  OrderIsCreated,
  OrderIsPartiallyReleased,
  OrderIsReleased,
  OrderIsConfirmed,
  OrderIsPartiallyConfirmed,
  OrderIsDelivered,
  OrderIsPartiallyDelivered,
  OrderIsDeleted,
  OrderIsLocked,
  OrderIsTechnicallyCompleted,
  OrderIsClosed,
  OrderIsMarkedForDeletion,
  ProcOrdConfIsAtHeader,
  OrderHasMissingComponents,
  OrderHasPostedGoodsMovements,
  UserStatusName,
  UserStatusShortName,
  NumberOfUserStatus,
  StatusProfile,
  NumberOfFailedGoodsMovements,
  OrderStatusCode,
  OrderStatusText,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeTime,
  CreationDateTime,
  Batch,
  ProductionPlant,
  ProductionPlantName,
  PlantTimeZone,
  PlanningPlant,
  MRPPlantName,
  MRPArea,
  MRPController,
  ProductionSupervisor,
  ProductionSupervisorName,
  PlannedOrder,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  WBSElement,
  WBSDescription,
  InspectionLot,
  ObjectInternalID,
  MfgOrderPlannedStartDate,
  MfgOrderPlannedStartTime,
  MfgOrderPlannedStartDateTime,
  MfgOrderPlannedEndDate,
  MfgOrderPlannedEndTime,
  MfgOrderPlannedEndDateTime,
  MfgOrderPlannedReleaseDate,
  MfgOrderScheduledStartDate,
  MfgOrderScheduledStartTime,
  MfgOrderScheduledStartDateTime,
  MfgOrderScheduledEndDate,
  MfgOrderScheduledEndTime,
  MfgOrderScheduledEndDateTime,
  MfgOrderScheduledReleaseDate,
  MfgOrderActualStartDate,
  MfgOrderActualStartTime,
  MfgOrderActualStartDateTime,
  MfgOrderActualEndDate,
  MfgOrderActualEndDate AS ActualEndDate,
  MfgOrderActualReleaseDate,
  MfgOrderConfirmedEndDate,
  MfgOrderConfirmedEndTime,
  MfgOrderConfirmedEndDateTime,
  MfgOrderTotalCommitmentDate,
  MfgOrderActualCompletionDate,
  MfgOrderItemActualDeliveryDate,
  ProductionUnit,
  MfgOrderPlannedTotalQty,
  MfgOrderPlannedScrapQty,
  MfgOrderConfirmedYieldQty,
  MfgOrderConfirmedScrapQty,
  MfgOrderConfirmedReworkQty,
  ExpectedDeviationQuantity,
  MfgOrderItemProductionUnit,
  ActualDeliveredQuantity,
  OrderOpenQuantity,
  BaseUnit,
  PlndQtyInBaseUnit,
  CurrentStartDelayInSeconds,
  CurrentEndDelayInSeconds,
  ConfirmedStartDelayInSeconds,
  ConfirmedEndDelayInSeconds,
  ConfirmedReleaseDelayInSeconds,
  ProcOrdDelayStatusCode,
  ProcOrdQltyIssueStatusCode,
  ProcOrdCompAvailabilityStsCode,
  ProcOrdQtyIssueStatusCode,
  ProcOrdScrapQltyIssueStsCode,
  ProcOrdInspQltyIssueStatusCode,
  StockSegment,
  cast (cast('1' as abap.int8) as nmbrofprocordswithissues preserving type) AS NmbrOfProcOrdsWithIssues,
  CurOperation,
  CurOperationText,
  WorkCenterInternalID,
  cast(WorkCenter as pppi_resource preserving type ) AS WorkCenter,
  WorkCenterText,
  OpLtstSchedldExecStrtDteTme,
  OpActualExecutionStartDateTime,
  ProcOrdReleaseIsAllowed,
  ProcOrdTechCompltnIsAllowed,
  ProcOrdHdrConfIsAllwd,
  ProcOrdOpPhseConfIsAllwd,
  ProcOrdChkComponentsIsAllwd,
  InspLotUsageDecisionValuation,
  InspCharcHasRejection,
  OrderLongText,
  ProcessOrderHasNoLongText,
  AsyncApplicationJobStatus,
  ApplicationJobName,
  ApplicationJobDescription,
  ApplicationJobStartDateTime,
  ProcOrdOpIsDelayed,
  ProcOrdOpHasQuantityIssue,
  ProcOrdOpHasQualityIssue,
  Customer,
  CustomerName,
  SoldToParty
FROM I_ProcessOrderMgmtWrkListCalc
LEFT OUTER JOIN E_ProcessOrder AS _Extension ON ProcessOrder = _Extension.OrderID  -- association [1..1]
LEFT OUTER JOIN I_ProcOrdMgmtQtyChartData AS _QuantityChartData ON ProcessOrder = _QuantityChartData.ProcessOrder  -- association [1..*]
LEFT OUTER JOIN I_ProcessOrderUserStatus AS _UserStatus ON ProcessOrder = _UserStatus.OrderID  -- association [1..*]
LEFT OUTER JOIN I_ProcOrdMgmtIssues AS _ProcOrdMgmtIssues ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN I_ProcOrdMgmtOpsOvw AS _ProcOrdMgmtOpsOvw ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN I_ProcOrdMgmtOperation AS _ProcOrdMgmtOp ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProcOrdMgmtOpComponents AS _ProcOrdMgmtOpComp ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProcOrdMgmtOpCompAggrgn AS _ProcOrdMgmtOpCompAggrgn ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProcOrdMgmtConfirmation AS _ProcOrdMgmtConf ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProcOrdMgmtGoodsMovement AS _ProcOrdMgmtGoodsMovement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProcOrdMgmtInspLot AS _ProcOrdMgmtInspLot ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_ProcOrdMgmtCompAvailySts AS _ProcOrdMgmtCompAvailySts ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN I_ProcOrdMgmtDelayIssue AS _ProcOrdMgmtDelayIss ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN I_ProcOrdMgmtQualityIssue AS _ProcOrdMgmtQltyIss ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN I_ProcOrdMgmtQuantityIssue AS _ProcOrdMgmtQtyIss ON /* condition not available in parsed metadata */  -- association [1..1]
LEFT OUTER JOIN I_ProcOrdMgmtAllProducts AS _ProcOrdMgmtAllProducts ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN I_ProcOrdFailedGoodsMovement AS _ProcOrdFailedGoodsMovement ON /* condition not available in parsed metadata */  -- association [1..*]
;