I_ProcOrdMgmtWithStatus

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_ProcOrdMgmtWithStatus.
-- 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: IPROCORDWTHSTS

CREATE VIEW I_ProcOrdMgmtWithStatus AS
SELECT
  ord.ManufacturingOrder AS ManufacturingOrder,
  ord.ManufacturingOrder AS ProcessOrder,
  ord.ManufacturingOrderText AS ManufacturingOrderText,
  ord.ManufacturingOrderHasLongText AS ManufacturingOrderHasLongText,
  ord.ProcessOrderHasNoLongText AS ProcessOrderHasNoLongText,
  ord.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  ord.ManufacturingOrderType AS ManufacturingOrderType,
  ord.ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  _systemStatus.OrderIsCreated AS OrderIsCreated,
  _systemStatus.OrderIsPartiallyReleased AS OrderIsPartiallyReleased,
  _systemStatus.OrderIsReleased AS OrderIsReleased,
  _systemStatus.OrderIsConfirmed AS OrderIsConfirmed,
  _systemStatus.OrderIsPartiallyConfirmed AS OrderIsPartiallyConfirmed,
  _systemStatus.OrderIsDelivered AS OrderIsDelivered,
  _systemStatus.OrderIsDeleted AS OrderIsDeleted,
  _systemStatus.OrderIsLocked AS OrderIsLocked,
  _systemStatus.OrderIsTechnicallyCompleted AS OrderIsTechnicallyCompleted,
  _systemStatus.OrderIsClosed AS OrderIsClosed,
  _systemStatus.OrderIsPartiallyDelivered AS OrderIsPartiallyDelivered,
  _systemStatus.OrderIsMarkedForDeletion AS OrderIsMarkedForDeletion,
  _systemStatus.MaterialAvailyIsNotChecked AS MaterialAvailyIsNotChecked,
  _systemStatus.ProcOrdConfIsAtHeader AS ProcOrdConfIsAtHeader,
  _systemStatus.OrderHasMissingComponents AS OrderHasMissingComponents,
  _systemStatus.OrderHasPostedGoodsMovements AS OrderHasPostedGoodsMovements,
  _userStatus.StatusProfile AS StatusProfile,
  _userStatus.UserStatusName AS UserStatusName,
  _userStatus.UserStatusShortName AS UserStatusShortName,
  _userStatus.NumberOfUserStatus AS NumberOfUserStatus,
  _cogiIssues.NumberOfFailedGoodsMovements AS NumberOfFailedGoodsMovements,
  ord.CreationDate AS CreationDate,
  ord.CreationTime AS CreationTime,
  ord.LastChangeDate AS LastChangeDate,
  ord.LastChangeTime AS LastChangeTime,
  ord.Material AS Material,
  _Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  cast(_Material.MaterialGroup as pppi_materialgroup preserving type) AS MaterialGroup,
  cast(_Material.MaterialType as pppi_materialtype preserving type) AS MaterialType,
  ord.Product AS Product,
  case when ord.Batch is not initial then ord.Batch when _ProcOrdBatch.Batch is not initial then _ProcOrdBatch.Batch else '' end as Batch AS BatchelseendasBatch,
  ord.MfgOrderInternalID AS MfgOrderInternalID,
  ord.ProductionPlant AS ProductionPlant,
  _ProductionPlant.PlantName AS ProductionPlantName,
  cast( _ProductionPlant._StandardOrganizationAddress.AddressTimeZone as co_plant_timezone ) AS PlantTimeZone,
  ord.PlanningPlant AS PlanningPlant,
  _PlanningPlant.PlantName AS MRPPlantName,
  cast(ord.MRPArea as pppi_mrparea preserving type) AS MRPArea,
  ord.MRPController AS MRPController,
  ord.ProductionSupervisor AS ProductionSupervisor,
  _ProductionSupervisor.ProductionSupervisorName AS ProductionSupervisorName,
  cast(ord.PlannedOrder as pppi_plannedorder preserving type) AS PlannedOrder,
  ord.SalesOrder AS SalesOrder,
  ord.SalesOrderItem AS SalesOrderItem,
  ord.WBSElementInternalID AS WBSElementInternalID,
  ord.WBSElement AS WBSElement,
  ord.WBSDescription AS WBSDescription,
  ord.InspectionLot AS InspectionLot,
  ord.ObjectInternalID AS ObjectInternalID,
  ord.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  ord.MfgOrderPlannedStartTime AS MfgOrderPlannedStartTime,
  ord.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  ord.MfgOrderPlannedEndTime AS MfgOrderPlannedEndTime,
  ord.MfgOrderPlannedReleaseDate AS MfgOrderPlannedReleaseDate,
  ord.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  ord.MfgOrderScheduledStartTime AS MfgOrderScheduledStartTime,
  ord.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  ord.MfgOrderScheduledEndTime AS MfgOrderScheduledEndTime,
  ord.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  ord.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  ord.MfgOrderActualStartTime AS MfgOrderActualStartTime,
  ord.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  ord.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  ord.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  ord.MfgOrderConfirmedEndTime AS MfgOrderConfirmedEndTime,
  ord.MfgOrderTotalCommitmentDate AS MfgOrderTotalCommitmentDate,
  ord.MfgOrderActualCompletionDate AS MfgOrderActualCompletionDate,
  ord.MfgOrderItemActualDeliveryDate AS MfgOrderItemActualDeliveryDate,
  ord.StockSegment AS StockSegment,
  ord.ProductionUnit AS ProductionUnit,
  ord.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  ord.MfgOrderPlannedScrapQty AS MfgOrderPlannedScrapQty,
  ord.MfgOrderConfirmedYieldQty AS MfgOrderConfirmedYieldQty,
  ord.MfgOrderConfirmedScrapQty AS MfgOrderConfirmedScrapQty,
  ord.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  ord.ExpectedDeviationQuantity AS ExpectedDeviationQuantity,
  ord.BaseUnit AS BaseUnit,
  ord.PlndQtyInBaseUnit AS PlndQtyInBaseUnit,
  MfgOrderItemProductionUnit,
  ord.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  case when ( MfgOrderConfirmedYieldQty < MfgOrderPlannedTotalQty ) then ( cast(( MfgOrderPlannedTotalQty - MfgOrderConfirmedYieldQty ) * 100 as abap.fltp ) / cast(MfgOrderPlannedTotalQty as abap.fltp) ) else 0.0 end as ProcOrdMissingConfYieldInPct AS 0endasProcOrdMissingConfYieldInPct,
  case when ( MfgOrderConfirmedYieldQty > MfgOrderPlannedTotalQty ) then ( cast(( MfgOrderConfirmedYieldQty - MfgOrderPlannedTotalQty ) * 100 as abap.fltp ) / cast(MfgOrderPlannedTotalQty as abap.fltp) ) else 0.0 end as ProcOrdExtraConfYieldInPct AS 0endasProcOrdExtraConfYieldInPct,
  UnderdelivTolrtdLmtRatioInPct,
  OverdelivTolrtdLmtRatioInPct,
  IsCompletelyDelivered,
  cast(BillOfMaterial as pppi_billofmaterial preserving type ) AS BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialVariantUsage,
  ChangeNumber,
  BOMExplosionDate,
  BOMValidityStartDate,
  BillOfOperations,
  BillOfOperationsVariant,
  BillOfOperationsUsage,
  BOOValidityStartDate,
  ResponsiblePlannerGroup,
  ProductionVersion,
  Customer,
  CustomerName,
  SoldToParty,
  case when (_systemStatus.OrderIsCreated = 'X' or _systemStatus.OrderIsPartiallyDelivered = 'X' or _systemStatus.OrderIsDelivered = 'X' or _systemStatus.OrderIsTechnicallyCompleted = 'X' or _systemStatus.OrderIsDeleted = 'X' or _systemStatus.OrderIsClosed ='X' or _systemStatus.OrderIsMarkedForDeletion = 'X') then '' else case when _ProcOrdOp.LatestOperation is null then _ProcOrdOp.FirstOperation else _ProcOrdOp.LatestOperation end end as CurOperation AS LatestOperationendendasCurOperation,
  case when (_systemStatus.OrderIsCreated = 'X' or _systemStatus.OrderIsPartiallyDelivered = 'X' or _systemStatus.OrderIsDelivered = 'X' or _systemStatus.OrderIsTechnicallyCompleted = 'X' or _systemStatus.OrderIsDeleted = 'X' or _systemStatus.OrderIsClosed ='X' or _systemStatus.OrderIsMarkedForDeletion = 'X') then '' else case when _ProcOrdOp.LatestOperation is null then _ProcOrdOp.FirstWorkCenter else _ProcOrdOp.LatestWorkCenter end end as WorkCenter AS LatestWorkCenterendendasWorkCenter,
  _Material._MaterialGroup AS _MaterialGroup,
  _Material._MaterialType AS _MaterialType
FROM P_ProcOrdMgmtBasicWithOp_2 AS ord
INNER JOIN P_ProcOrdSystemStatusAggr AS _systemStatus ON /* join condition not captured in parsed metadata */
INNER JOIN P_ProcOrdOpAggr AS _ProcOrdOp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ProcOrdUserStatusAggregation AS _userStatus ON ManufacturingOrder = _userStatus.OrderID  -- association [0..1]
LEFT OUTER JOIN P_ProcOrdCOGIAggr AS _cogiIssues ON ManufacturingOrder = _cogiIssues.OrderID  -- association [0..1]
LEFT OUTER JOIN P_ProcOrdMgmtBatchMaxItm_2 AS _ProcOrdBatch ON ManufacturingOrder = _ProcOrdBatch.ProcessOrder  -- association [0..1]
;