I_ProcessOrder

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_ProcessOrder.
-- 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 I_ProcessOrder AS
SELECT
  head.ManufacturingOrder AS ManufacturingOrder,
  cast(head.ManufacturingOrder as co_aufnr preserving type) AS ProcessOrder,
  cast(head. ManufacturingOrderText as pph_auftext preserving type) AS OrderDescription,
  head.ManufacturingOrderHasLongText AS OrderHasLongText,
  head.LongTextLanguageCode AS LongTextLanguageCode,
  head.IsMarkedForDeletion AS IsMarkedForDeletion,
  head.IsCompletelyDelivered AS IsCompletelyDelivered,
  head.CreationDate AS CreationDate,
  head.CreationTime AS CreationTime,
  head.CreatedByUser AS CreatedByUser,
  head.LastChangeDate AS LastChangeDate,
  head.LastChangeTime AS LastChangeTime,
  head.LastChangedByUser AS LastChangedByUser,
  head.Product AS Product,
  head.StorageLocation AS StorageLocation,
  head.Batch AS Batch,
  head.ManufacturingOrderType AS OrderType,
  cast(head.MfgOrderInternalID as pph_aufpl preserving type) AS OrderInternalID,
  head.ReferenceOrder AS ReferenceOrder,
  head.Currency AS Currency,
  head.ProductionPlant AS ProductionPlant,
  head.PlanningPlant AS PlanningPlant,
  head.MRPController AS MRPController,
  head.ProductionSupervisor AS ProductionSupervisor,
  head.ProductionSchedulingProfile AS ProductionSchedulingProfile,
  head.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  head.ProductionVersion AS ProductionVersion,
  head.SalesOrder AS SalesOrder,
  head.SalesOrderItem AS SalesOrderItem,
  head.Reservation AS Reservation,
  head.SettlementReservation AS SettlementReservation,
  head.PlannedOrder AS PlannedOrder,
  head.CapacityRequirement AS CapacityRequirement,
  head.ChangeNumber AS ChangeNumber,
  head.BillOfOperationsMaterial AS BillOfOperationsMaterial,
  head.BillOfOperationsType AS BillOfOperationsType,
  head.BillOfOperationsGroup AS BillOfOperationsGroup,
  head.BillOfOperationsVariant AS BillOfOperationsVariant,
  head.BOOInternalVersionCounter AS BOOInternalVersionCounter,
  head.BillOfOperationsApplication AS BillOfOperationsApplication,
  head.BillOfOperationsUsage AS BillOfOperationsUsage,
  head.BillOfOperationsVersion AS BillOfOperationsVersion,
  head.BOOExplosionDate AS BOOExplosionDate,
  head.BillOfMaterialCategory AS BillOfMaterialCategory,
  head.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  head.BillOfMaterialVariant AS BillOfMaterialVariant,
  head.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  head.BillOfMaterialVersion AS BillOfMaterialVersion,
  head.BOMExplosionDate AS BOMExplosionDate,
  head.BusinessArea AS BusinessArea,
  head.CompanyCode AS CompanyCode,
  head.ControllingArea AS ControllingArea,
  head.ProfitCenter AS ProfitCenter,
  head.CostCenter AS CostCenter,
  head.CostElement AS CostElement,
  head.CostingSheet AS CostingSheet,
  head.GLAccount AS GLAccount,
  head.ProductCostCollector AS ProductCostCollector,
  head.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  head.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  head.ControllingObjectClass AS ControllingObjectClass,
  head.FunctionalArea AS FunctionalArea,
  head.EventBasedPostingMethod AS EventBasedPostingMethod,
  head.MfgOrderPlannedStartDate AS PlannedStartDate,
  head.MfgOrderPlannedStartTime AS PlannedStartTime,
  head.MfgOrderPlannedEndDate AS PlannedEndDate,
  head.MfgOrderPlannedEndTime AS PlannedEndTime,
  head.MfgOrderPlannedReleaseDate AS PlannedReleaseDate,
  head.MfgOrderScheduledStartDate AS ScheduledBasicStartDate,
  head.MfgOrderScheduledStartTime AS ScheduledBasicStartTime,
  head.MfgOrderScheduledEndDate AS ScheduledBasicEndDate,
  head.MfgOrderScheduledEndTime AS ScheduledBasicEndTime,
  head.MfgOrderScheduledReleaseDate AS ScheduledReleaseDate,
  head.MfgOrderActualStartDate AS ActualStartDate,
  head.MfgOrderActualStartTime AS ActualStartTime,
  head.MfgOrderActualEndDate AS ActualEndDate,
  head.MfgOrderActualReleaseDate AS ActualReleasedDate,
  head.MfgOrderConfirmedEndDate AS ConfirmedEndDate,
  head.MfgOrderConfirmedEndTime AS ConfirmedEndTime,
  head.MfgOrderActualCompletionDate AS TechnicalCompletionDate,
  head.MfgOrderItemActualDeliveryDate AS ActualDeliveryDate,
  head.ProductionUnit AS ProductionUnit,
  head.MfgOrderPlannedTotalQty AS OrderPlannedTotalQty,
  head.MfgOrderPlannedScrapQty AS OrderPlannedScrapQty,
  head.MfgOrderConfirmedYieldQty AS OrderConfirmedYieldQty,
  head.MfgOrderConfirmedScrapQty AS OrderConfirmedScrapQty,
  head.ExpectedDeviationQuantity AS ExpectedDeviationQuantity,
  head.ActualDeliveredQuantity AS ActualDeliveredQuantity,
  head._CreatedByUser AS _CreatedByUser,
  head._LastChangedByUser AS _LastChangedByUser,
  head._LongTextLanguage AS _LongTextLanguage,
  head._ProductionUnit AS _ProductionUnit,
  head._Currency AS _Currency,
  head._OrderInternalID AS _OrderInternalID,
  head._BillOfOperationsMaterial AS _BillOfOperationsMaterial,
  head._BillOfOperationsType AS _BillOfOperationsType,
  head._Reservation AS _Reservation,
  head._SettlementReservation AS _SettlementReservation,
  head._ProductionPlant AS _ProductionPlant,
  head._PlanningPlant AS _PlanningPlant,
  head._Product AS _Product,
  head._StorageLocation AS _StorageLocation,
  head._MRPController AS _MRPController,
  head._ProductionSupervisor AS _ProductionSupervisor,
  head._ProductionSchedulingProfile AS _ProductionSchedulingProfile,
  head._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  head._CapacityRequirement AS _CapacityRequirement,
  head._ChangeNumber AS _ChangeNumber
FROM I_ManufacturingOrder AS head
LEFT OUTER JOIN I_ManufacturingOrderItem AS _ProcessOrderItem ON ProcessOrder = _ProcessOrderItem.ManufacturingOrder  -- association [1..*]
LEFT OUTER JOIN I_ManufacturingOrderOperation AS _ProcessOrderOperation ON OrderInternalID = _ProcessOrderOperation.MfgOrderInternalID  -- association [1..*]
LEFT OUTER JOIN I_ManufacturingOrderComponent AS _ProcessOrderComponent ON Reservation = _ProcessOrderComponent.Reservation  -- association [0..*]
;