P_ProcOrdMgmtBasic

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_ProcOrdMgmtBasic.
-- 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: PPROCORDMGMTBSC

CREATE VIEW P_ProcOrdMgmtBasic AS
SELECT
  cast(head.OrderID as manufacturingorder preserving type) AS ManufacturingOrder,
  cast(head.OrderType as pppi_manufacturingordertype preserving type ) AS ManufacturingOrderType,
  _MfgOrderType._Text[1: Language=$session.system_language].ManufacturingOrderTypeName AS ManufacturingOrderTypeName,
  cast(head.OrderDescription as manufacturingordertext preserving type) AS ManufacturingOrderText,
  cast(head.OrderHasLongText as pph_longtextlang) AS LongTextLanguageCode,
  cast(head.PriorityCode as orderimportancecode preserving type) AS ManufacturingOrderImportance,
  cast(head.CreationDate as ordercreationdate preserving type) AS CreationDate,
  cast(head.CreationTime as ordercreationtime preserving type) AS CreationTime,
  cast(head.OrderInternalBillOfOperations as pph_aufpl preserving type) AS MfgOrderInternalID,
  cast(head.Plant as pwwrk preserving type) AS ProductionPlant,
  cast(head.MRPController as pppi_mrpcontroller preserving type) AS MRPController,
  cast(head.ProductionSupervisor as pppi_productionsupervisor preserving type) AS ProductionSupervisor,
  cast(head.ProductionSchedulingProfile as pph_prodprf preserving type) AS ProductionSchedulingProfile,
  cast(head.SettlementReservation as settlmntres preserving type) AS SettlementReservation,
  cast(head.MfgOrderConfirmationCount as pph_noofconf preserving type) AS NumberOfMfgOrderConfirmations,
  cast(head.BasicSchedulingType as basicschedtype preserving type) AS BasicSchedulingType,
  cast(head.ObjectInternalID as pph_objnr preserving type) AS ObjectInternalID,
  cast(head.BillOfMaterial as pppi_billofmaterial preserving type ) AS BillOfMaterial,
  cast(head.ControllingObjectClass as pph_scope preserving type) AS ControllingObjectClass,
  cast(head.PlannedStartDate as mfgorderplannedstartdate preserving type) AS MfgOrderPlannedStartDate,
  cast(head.PlannedStartTime as mfgorderplannedstarttime preserving type) AS MfgOrderPlannedStartTime,
  cast(head.PlannedEndDate as mfgorderplannedenddate preserving type) AS MfgOrderPlannedEndDate,
  cast(head.PlannedEndTime as mfgorderplannedendtime preserving type) AS MfgOrderPlannedEndTime,
  cast(head.PlannedReleaseDate as mfgorderplannedreleasedate preserving type) AS MfgOrderPlannedReleaseDate,
  cast(head.ScheduledBasicStartDate as mfgorderscheduledstartdate preserving type) AS MfgOrderScheduledStartDate,
  cast(head.ScheduledBasicStartTime as mfgorderscheduledstarttime preserving type) AS MfgOrderScheduledStartTime,
  cast(head.ScheduledBasicEndDate as mfgorderscheduledenddate preserving type) AS MfgOrderScheduledEndDate,
  cast(head.ScheduledBasicEndTime as mfgorderscheduledendtime preserving type) AS MfgOrderScheduledEndTime,
  cast(head.ScheduledReleaseDate as mfgorderscheduledreleasedate preserving type) AS MfgOrderScheduledReleaseDate,
  cast(head.ActualStartDate as mfgorderactualstartdate preserving type) AS MfgOrderActualStartDate,
  cast(head.ActualStartTime as mfgorderactualstarttime preserving type) AS MfgOrderActualStartTime,
  cast(head.ActualEndDate as mfgorderactualenddate preserving type) AS MfgOrderActualEndDate,
  cast(head.ActualReleasedDate as mfgorderactualreleasedate preserving type) AS MfgOrderActualReleaseDate,
  cast(head.ConfirmedEndDate as mfgorderconfirmedenddate preserving type) AS MfgOrderConfirmedEndDate,
  cast(head.ConfirmedEndTime as mfgorderconfirmedendtime preserving type) AS MfgOrderConfirmedEndTime,
  cast(head.BaseUnit as productionunit preserving type) AS ProductionUnit,
  cast(head.OrderPlannedTotalQty as mfgorderplannedtotalqty preserving type) AS MfgOrderPlannedTotalQty,
  cast(head.OrderPlannedScrapQty as mfgorderplannedscrapqty preserving type) AS MfgOrderPlannedScrapQty,
  cast(head.OrderConfirmedYieldQty as co_igmng preserving type) AS MfgOrderConfirmedYieldQty,
  cast(head.OrderConfirmedScrapQty as co_iasmg preserving type) AS MfgOrderConfirmedScrapQty,
  _SalesOrder._SoldToParty.Customer AS Customer,
  _SalesOrder._SoldToParty.CustomerName AS CustomerName,
  head.OrderCategory AS ManufacturingOrderCategory,
  head.IsMarkedForDeletion AS IsMarkedForDeletion,
  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.CreatedByUser AS CreatedByUser,
  head.LastChangeDate AS LastChangeDate,
  head.LastChangeTime AS LastChangeTime,
  head.LastChangedByUser AS LastChangedByUser,
  head.ReferenceOrder AS ReferenceOrder,
  head.LeadingOrder AS LeadingOrder,
  head.MfgOrderSuperiorMfgOrder AS SuperiorOrder,
  head.Currency AS Currency,
  head.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  head.Reservation AS Reservation,
  head.MfgOrderConfirmation AS MfgOrderConfirmation,
  head.CapacityRequirement AS CapacityRequirement,
  head.InspectionLot AS InspectionLot,
  head.ChangeNumber AS ChangeNumber,
  head.ConditionApplication AS ConditionApplication,
  head.CapacityActiveVersion AS CapacityActiveVersion,
  head.CapacityRqmtHasNotToBeCreated AS CapacityRqmtHasNotToBeCreated,
  head.OrderSequenceNumber AS OrderSequenceNumber,
  head.Material 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.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.FunctionalArea AS FunctionalArea,
  head.TotalCommitmentDate AS MfgOrderTotalCommitmentDate,
  head.TechnicalCompletionDate AS MfgOrderActualCompletionDate,
  head.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  head.MaterialBaseUnit AS BaseUnit,
  head.PlannedTotalQtyInBaseUnit AS PlndQtyInBaseUnit,
  head.MasterProductionOrder AS MasterProductionOrder,
  head._SettlementReservation AS _SettlementReservation,
  head._BusinessArea AS _BusinessArea,
  _SalesOrder.SoldToParty AS SoldToParty
FROM P_ProcessOrderHeader AS head
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ReferenceOrder ON ReferenceOrder = _ReferenceOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _LeadingOrder ON LeadingOrder = _LeadingOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _SuperiorOrder ON SuperiorOrder = _SuperiorOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_OrderInternalID AS _OrderInternalID ON MfgOrderInternalID = _OrderInternalID.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguageCode = _LongTextLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ProductionUnit ON ProductionUnit = _ProductionUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_ChangeMaster AS _ChangeNumber ON ChangeNumber = _ChangeNumber.ChangeNumber  -- association [0..1]
LEFT OUTER JOIN I_ChangeMstrObjTypeRevisionLvl AS _MaterialRevisionLevel ON MaterialRevisionLevel = _MaterialRevisionLevel.RevisionLevel AND _MaterialRevisionLevel.ChangeNumberObjectType = '41'  -- association [0..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON GLAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CostElement AS _CostElement ON ControllingArea = _CostElement.ControllingArea AND CostElement = _CostElement.CostElement  -- association [0..1]
LEFT OUTER JOIN I_CostingVariant AS _ActualCostsCostingVariant ON ActualCostsCostingVariant = _ActualCostsCostingVariant.CostingVariant  -- association [0..1]
LEFT OUTER JOIN I_CostingVariant AS _PlannedCostsCostingVariant ON PlannedCostsCostingVariant = _PlannedCostsCostingVariant.CostingVariant  -- association [0..1]
LEFT OUTER JOIN I_MRPController AS _MRPController ON ProductionPlant = _MRPController.Plant AND MRPController = _MRPController.MRPController  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupervisor AS _ProductionSupervisor ON ProductionPlant = _ProductionSupervisor.Plant AND ProductionSupervisor = _ProductionSupervisor.ProductionSupervisor  -- association [0..1]
LEFT OUTER JOIN I_ProductionSchedulingProfile AS _ProductionSchedulingProfile ON ProductionPlant = _ProductionSchedulingProfile.Plant AND ProductionSchedulingProfile = _ProductionSchedulingProfile.ProductionSchedulingProfile  -- association [0..1]
LEFT OUTER JOIN I_ResponsiblePlannerGroup AS _ResponsiblePlannerGroup ON ProductionPlant = _ResponsiblePlannerGroup.Plant AND ResponsiblePlannerGroup = _ResponsiblePlannerGroup.ResponsiblePlannerGroup  -- association [0..1]
LEFT OUTER JOIN I_MfgBillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [0..1]
LEFT OUTER JOIN I_MfgBillOfOperationsChgSt AS _BillOfOperationsChangeState ON BillOfOperationsType = _BillOfOperationsChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperationsChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperationsChangeState.BillOfOperationsVariant AND BOOInternalVersionCounter = _BillOfOperationsChangeState.BOOInternalVersionCounter  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingOrderItem AS _MfgOrderItem ON ManufacturingOrder = _MfgOrderItem.ManufacturingOrder  -- association [1..*]
LEFT OUTER JOIN I_MfgOrderSequence AS _MfgOrderSequence ON ManufacturingOrder = _MfgOrderSequence.ManufacturingOrder  -- association [1..*]
LEFT OUTER JOIN I_ManufacturingOrderOperation AS _MfgOrderOperation ON MfgOrderInternalID = _MfgOrderOperation.MfgOrderInternalID  -- association [1..*]
LEFT OUTER JOIN I_MfgOrderMaterialDocumentItem AS _MfgOrderMaterialDocItem ON ManufacturingOrder = _MfgOrderMaterialDocItem.ManufacturingOrder  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderDocInfoRecdObjLink AS _MfgOrderDocInfoRecord ON ManufacturingOrder = _MfgOrderDocInfoRecord.ManufacturingOrder  -- association [0..*]
;