P_ProcOrdMgmtBasicWithOp

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 P_ProcOrdMgmtBasicWithOp.
-- 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: PPROCORDOP

CREATE VIEW P_ProcOrdMgmtBasicWithOp AS
SELECT
  head.ManufacturingOrder AS ManufacturingOrder,
  head.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  head.ManufacturingOrderType AS ManufacturingOrderType,
  head.ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  head.ManufacturingOrderText AS ManufacturingOrderText,
  head.ManufacturingOrderHasLongText AS ManufacturingOrderHasLongText,
  head.ProcessOrderHasNoLongText AS ProcessOrderHasNoLongText,
  head.LongTextLanguageCode AS LongTextLanguageCode,
  head.ManufacturingOrderImportance AS ManufacturingOrderImportance,
  head.IsMarkedForDeletion AS IsMarkedForDeletion,
  item.IsCompletelyDelivered AS IsCompletelyDelivered,
  head.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems,
  head.MfgOrderIsPartOfCollvOrder AS MfgOrderIsPartOfCollvOrder,
  head.MfgOrderHierarchyLevel AS MfgOrderHierarchyLevel,
  head.OrderIsNotCostedAutomatically AS OrderIsNotCostedAutomatically,
  head.OrdIsNotSchedldAutomatically AS OrdIsNotSchedldAutomatically,
  head.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  head.OrderIsEventBasedPosting AS OrderIsEventBasedPosting,
  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.LastChangeDateTime AS LastChangeDateTime,
  item.Material AS Material,
  cast(item._Material.MaterialGroup as pppi_materialgroup preserving type) AS MaterialGroup,
  cast(item._Material.MaterialType as pppi_materialtype preserving type) AS MaterialType,
  cast(item.Material as productnumber preserving type) AS Product,
  item.StorageLocation AS StorageLocation,
  item.Batch AS Batch,
  item.GoodsRecipientName AS GoodsRecipientName,
  item.UnloadingPointName AS UnloadingPointName,
  item.InventoryUsabilityCode AS InventoryUsabilityCode,
  item.MaterialGoodsReceiptDuration AS MaterialGoodsReceiptDuration,
  item.QuantityDistributionKey AS QuantityDistributionKey,
  item.StockSegment AS StockSegment,
  head.MfgOrderInternalID AS MfgOrderInternalID,
  head.ReferenceOrder AS ReferenceOrder,
  head.LeadingOrder AS LeadingOrder,
  head.SuperiorOrder AS SuperiorOrder,
  head.Currency AS Currency,
  head.ProductionPlant AS ProductionPlant,
  item.PlanningPlant AS PlanningPlant,
  item.MRPArea AS MRPArea,
  head.MRPController AS MRPController,
  head.ProductionSupervisor AS ProductionSupervisor,
  head.ProductionSchedulingProfile AS ProductionSchedulingProfile,
  head.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  item.ProductionVersion AS ProductionVersion,
  cast(item.SalesOrder as pppi_salesorder preserving type) AS SalesOrder,
  cast(item.SalesOrderItem as pppi_salesorderitem preserving type) AS SalesOrderItem,
  item.WBSElementInternalID AS WBSElementInternalID,
  cast(_WBSElement.WBSElement as pph_wbselement preserving type ) AS WBSElement,
  _WBSElement.WBSDescription AS WBSDescription,
  head.Reservation AS Reservation,
  head.SettlementReservation AS SettlementReservation,
  head.MfgOrderConfirmation AS MfgOrderConfirmation,
  head.NumberOfMfgOrderConfirmations AS NumberOfMfgOrderConfirmations,
  item.PlannedOrder AS PlannedOrder,
  head.CapacityRequirement AS CapacityRequirement,
  head.InspectionLot AS InspectionLot,
  head.ChangeNumber AS ChangeNumber,
  head.MaterialRevisionLevel AS MaterialRevisionLevel,
  head.BasicSchedulingType AS BasicSchedulingType,
  head.ObjectInternalID AS ObjectInternalID,
  cast(item.ProductConfiguration as product_configuration preserving type) AS ProductConfiguration,
  item.EffectivityParameterVariant AS EffectivityParameterVariant,
  head.ConditionApplication AS ConditionApplication,
  head.CapacityActiveVersion AS CapacityActiveVersion,
  head.CapacityRqmtHasNotToBeCreated AS CapacityRqmtHasNotToBeCreated,
  head.OrderSequenceNumber AS OrderSequenceNumber,
  head.BillOfOperationsMaterial AS BillOfOperationsMaterial,
  head.BillOfOperationsType AS BillOfOperationsType,
  head.BillOfOperations AS BillOfOperations,
  head.BillOfOperationsGroup AS BillOfOperationsGroup,
  head.BillOfOperationsVariant AS BillOfOperationsVariant,
  head.BOOInternalVersionCounter AS BOOInternalVersionCounter,
  head.BillOfOperationsUsage AS BillOfOperationsUsage,
  head.BillOfOperationsVersion AS BillOfOperationsVersion,
  head.BOOExplosionDate AS BOOExplosionDate,
  head.BOOValidityStartDate AS BOOValidityStartDate,
  head.BillOfMaterialCategory AS BillOfMaterialCategory,
  head.BillOfMaterial AS BillOfMaterial,
  head.BillOfMaterialVariant AS BillOfMaterialVariant,
  head.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  head.BillOfMaterialVersion AS BillOfMaterialVersion,
  head.BOMExplosionDate AS BOMExplosionDate,
  head.BOMValidityStartDate AS BOMValidityStartDate,
  head.BusinessArea AS BusinessArea,
  head.CompanyCode AS CompanyCode,
  head.ControllingArea AS ControllingArea,
  head.ProfitCenter AS ProfitCenter,
  head.CostCenter AS CostCenter,
  head.ResponsibleCostCenter AS ResponsibleCostCenter,
  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.MfgOrderPlannedStartDate AS MfgOrderPlannedStartDate,
  head.MfgOrderPlannedStartTime AS MfgOrderPlannedStartTime,
  head.MfgOrderPlannedEndDate AS MfgOrderPlannedEndDate,
  head.MfgOrderPlannedEndTime AS MfgOrderPlannedEndTime,
  head.MfgOrderPlannedReleaseDate AS MfgOrderPlannedReleaseDate,
  head.MfgOrderScheduledStartDate AS MfgOrderScheduledStartDate,
  head.MfgOrderScheduledStartTime AS MfgOrderScheduledStartTime,
  head.MfgOrderScheduledEndDate AS MfgOrderScheduledEndDate,
  head.MfgOrderScheduledEndTime AS MfgOrderScheduledEndTime,
  head.MfgOrderScheduledReleaseDate AS MfgOrderScheduledReleaseDate,
  head.MfgOrderActualStartDate AS MfgOrderActualStartDate,
  head.MfgOrderActualStartTime AS MfgOrderActualStartTime,
  head.MfgOrderActualEndDate AS MfgOrderActualEndDate,
  head.MfgOrderActualReleaseDate AS MfgOrderActualReleaseDate,
  head.MfgOrderConfirmedEndDate AS MfgOrderConfirmedEndDate,
  head.MfgOrderConfirmedEndTime AS MfgOrderConfirmedEndTime,
  head.MfgOrderTotalCommitmentDate AS MfgOrderTotalCommitmentDate,
  head.MfgOrderActualCompletionDate AS MfgOrderActualCompletionDate,
  item.MfgOrderItemActualDeliveryDate AS MfgOrderItemActualDeliveryDate,
  head.ProductionUnit AS ProductionUnit,
  head.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  head.MfgOrderPlannedScrapQty AS MfgOrderPlannedScrapQty,
  head.MfgOrderConfirmedYieldQty AS MfgOrderConfirmedYieldQty,
  head.MfgOrderConfirmedScrapQty AS MfgOrderConfirmedScrapQty,
  head.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  cast(item.MfgOrderItemActualDeviationQty as co_mimez preserving type) AS ExpectedDeviationQuantity,
  item.ProductionUnit AS MfgOrderItemProductionUnit,
  item.MfgOrderItemGoodsReceiptQty AS ActualDeliveredQuantity,
  head.BaseUnit AS BaseUnit,
  head.PlndQtyInBaseUnit AS PlndQtyInBaseUnit,
  head.MasterProductionOrder AS MasterProductionOrder,
  item.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  item.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  _SalesOrder._SoldToParty.Customer AS Customer,
  _SalesOrder._SoldToParty.CustomerName AS CustomerName,
  _SalesOrder.SoldToParty AS SoldToParty,
  head._ActualCostsCostingVariant AS _ActualCostsCostingVariant,
  head._BasicSchedulingType AS _BasicSchedulingType,
  head._BillOfOperations AS _BillOfOperations,
  head._BillOfOperationsChangeState AS _BillOfOperationsChangeState,
  head._BillOfOperationsGroup AS _BillOfOperationsGroup,
  head._BillOfOperationsGroup2 AS _BillOfOperationsGroup2,
  head._BillOfOperationsType AS _BillOfOperationsType,
  head._BillOfOperationsUsage AS _BillOfOperationsUsage,
  head._BusinessArea AS _BusinessArea,
  head._CapacityRequirement AS _CapacityRequirement,
  head._ChangeNumber AS _ChangeNumber,
  head._CompanyCode AS _CompanyCode,
  head._ConfirmationGroup AS _ConfirmationGroup,
  head._ControllingArea AS _ControllingArea,
  head._ControllingObjectClass AS _ControllingObjectClass,
  head._CostCenter AS _CostCenter,
  head._CostElement AS _CostElement,
  head._CreatedByUser AS _CreatedByUser,
  head._Currency AS _Currency,
  head._FunctionalArea AS _FunctionalArea,
  head._GLAccount AS _GLAccount,
  head._InspectionLot AS _InspectionLot,
  head._LastChangedByUser AS _LastChangedByUser,
  head._LeadingOrder AS _LeadingOrder,
  head._LongText AS _LongText,
  head._LongTextLanguage AS _LongTextLanguage,
  item._Material AS _Material,
  head._MaterialRevisionLevel AS _MaterialRevisionLevel,
  head._MfgOrderCategory AS _MfgOrderCategory,
  head._MfgOrderDocInfoRecord AS _MfgOrderDocInfoRecord,
  head._MfgOrderItem AS _MfgOrderItem,
  head._MfgOrderMaterialDocItem AS _MfgOrderMaterialDocItem,
  head._MfgOrderOperation AS _MfgOrderOperation,
  head._MfgOrderSequence AS _MfgOrderSequence,
  head._MfgOrderType AS _MfgOrderType,
  head._MRPController AS _MRPController,
  head._OrderInternalID AS _OrderInternalID,
  head._OrderTypeDetails AS _OrderTypeDetails,
  head._PlannedCostsCostingVariant AS _PlannedCostsCostingVariant,
  item._PlannedOrder AS _PlannedOrder,
  head._ProductCostCollector AS _ProductCostCollector,
  head._ProductionPlant AS _ProductionPlant,
  head._ProductionSchedulingProfile AS _ProductionSchedulingProfile,
  head._ProductionSupervisor AS _ProductionSupervisor,
  head._ProductionUnit AS _ProductionUnit,
  head._ProfitCenter AS _ProfitCenter,
  head._ReferenceOrder AS _ReferenceOrder,
  head._Reservation AS _Reservation,
  head._ResponsibleCostCenter AS _ResponsibleCostCenter,
  head._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  head._SettlementReservation AS _SettlementReservation,
  head._SuperiorOrder AS _SuperiorOrder
FROM P_ProcOrdMgmtBasic AS head
LEFT OUTER JOIN I_Plant AS _PlanningPlant ON PlanningPlant = _PlanningPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_MRPArea AS _MRPArea ON MRPArea = _MRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON ProductionPlant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _Batch ON Material = _Batch.Material AND Batch = _Batch.Batch  -- association [0..*]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _ProductUnitsOfMeasure ON Product = _ProductUnitsOfMeasure.Product  -- association [1..*]
LEFT OUTER JOIN I_ProductPlant AS _ProductPlant ON ProductionPlant = _ProductPlant.Plant AND Product = _ProductPlant.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductStorageLocation AS _ProductStorageLocation ON Material = _ProductStorageLocation.Product AND ProductionPlant = _ProductStorageLocation.Plant AND StorageLocation = _ProductStorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductPlantMRP AS _ProductPlantMRPArea ON Product = _ProductPlantMRPArea.Product AND ProductionPlant = _ProductPlantMRPArea.Plant AND MRPArea = _ProductPlantMRPArea.MRPArea  -- association [0..1]
LEFT OUTER JOIN I_Product AS _BillOfOperationsMaterial ON BillOfOperationsMaterial = _BillOfOperationsMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentBasic AS _SalesOrder ON SalesOrder = _SalesOrder.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersion ON Product = _ProductionVersion.Material AND ProductionPlant = _ProductionVersion.Plant AND ProductionVersion = _ProductionVersion.ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_ProductionVersion AS _ProductionVersion2 ON Material = _ProductionVersion2.Material AND ProductionPlant = _ProductionVersion2.Plant AND ProductionVersion = _ProductionVersion2.ProductionVersion  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrderItem AS _MfgOrderMainItem ON ManufacturingOrder = _MfgOrderMainItem.ManufacturingOrder AND _MfgOrderMainItem.ManufacturingOrderItem = '0001'  -- association [1..1]
;