P_ProcessOrderHeader

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_ProcessOrderHeader.
-- 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 P_ProcessOrderHeader AS
SELECT
  _ProcessOrder.OrderID AS OrderID,
  _ProcessOrder.OrderCategory AS OrderCategory,
  _ProcessOrder.OrderType AS OrderType,
  _ProcessOrder.OrderDescription AS OrderDescription,
  _ProcessOrder.OrderHasLongText AS OrderHasLongText,
  _ProcessOrder.IsMarkedForDeletion AS IsMarkedForDeletion,
  _ProcessOrder.MfgOrderHasMultipleItems AS MfgOrderHasMultipleItems,
  _ProcessOrder.MfgOrderIsPartOfCollvOrder AS MfgOrderIsPartOfCollvOrder,
  _ProcessOrder.MfgOrderSuperiorMfgOrder AS MfgOrderSuperiorMfgOrder,
  _ProcessOrder.OrderIsRefurbishmentOrder AS OrderIsRefurbishmentOrder,
  _ProcessOrder.IsStatisticalOrder AS IsStatisticalOrder,
  _ProcessOrder.PriorityCode AS PriorityCode,
  _ProcessOrder.MfgOrderHierarchyLevel AS MfgOrderHierarchyLevel,
  _ProcessOrder.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  _ProcessOrder.OrderIsEventBasedPosting AS OrderIsEventBasedPosting,
  _ProcessOrder.EventBasedPostingMethod AS EventBasedPostingMethod,
  _ProcessOrder.CreationDate AS CreationDate,
  _ProcessOrder.CreationTime AS CreationTime,
  _ProcessOrder.CreatedByUser AS CreatedByUser,
  _ProcessOrder.LastChangeDate AS LastChangeDate,
  _ProcessOrder.LastChangeTime AS LastChangeTime,
  _ProcessOrder.LastChangedByUser AS LastChangedByUser,
  _ProcessOrder.OrderInternalBillOfOperations AS OrderInternalBillOfOperations,
  _ProcessOrder.ReferenceOrder AS ReferenceOrder,
  _ProcessOrder.LeadingOrder AS LeadingOrder,
  _ProcessOrder.Plant AS Plant,
  _ProcessOrder.MainWorkCenter AS MainWorkCenter,
  _ProcessOrder.MainWorkCenterPlant AS MainWorkCenterPlant,
  _ProcessOrder.MaintenanceObjectLocation AS MaintenanceObjectLocation,
  _ProcessOrder.LocationPlant AS LocationPlant,
  _ProcessOrder.MRPController AS MRPController,
  _ProcessOrder.ProductionSupervisor AS ProductionSupervisor,
  _ProcessOrder.ProductionSchedulingProfile AS ProductionSchedulingProfile,
  _ProcessOrder.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  _ProcessOrder.SalesOrder AS SalesOrder,
  _ProcessOrder.SalesOrderItem AS SalesOrderItem,
  _ProcessOrder.WBSElementInternalID AS WBSElementInternalID,
  _ProcessOrder.WBSElementInternalID_2 AS WBSElementInternalID_2,
  _ProcessOrder.ProjectInternalID AS ProjectInternalID,
  _ProcessOrder.ProjectInternalID_2 AS ProjectInternalID_2,
  _ProcessOrder.SuperiorProjectNetwork AS SuperiorProjectNetwork,
  _ProcessOrder.Reservation AS Reservation,
  _ProcessOrder.SettlementReservation AS SettlementReservation,
  _ProcessOrder.MfgOrderConfirmation AS MfgOrderConfirmation,
  _ProcessOrder.MfgOrderConfirmationCount AS MfgOrderConfirmationCount,
  _ProcessOrder.CapacityRequirement AS CapacityRequirement,
  _ProcessOrder.InspectionLot AS InspectionLot,
  _ProcessOrder.ChangeNumber AS ChangeNumber,
  _ProcessOrder.EngineeringChangeOrder AS EngineeringChangeOrder,
  _ProcessOrder.BasicSchedulingType AS BasicSchedulingType,
  _ProcessOrder.ProdAvailyCheckPlanningType AS ProdAvailyCheckPlanningType,
  _ProcessOrder.ProjInterestCalcProfile AS ProjInterestCalcProfile,
  _ProcessOrder.NtwkAccountAssignmentCode AS NtwkAccountAssignmentCode,
  _ProcessOrder.NetworkProfile AS NetworkProfile,
  _ProcessOrder.ObjectInternalID AS ObjectInternalID,
  _ProcessOrder.ProductConfiguration AS ProductConfiguration,
  _ProcessOrder.ConditionApplication AS ConditionApplication,
  _ProcessOrder.ExternalOrder AS ExternalOrder,
  _ProcessOrder.OverheadCode AS OverheadCode,
  _ProcessOrder.OrderIsNotCostedAutomatically AS OrderIsNotCostedAutomatically,
  _ProcessOrder.OrdIsNotSchedldAutomatically AS OrdIsNotSchedldAutomatically,
  _ProcessOrder.CapacityActiveVersion AS CapacityActiveVersion,
  _ProcessOrder.CapacityRqmtHasNotToBeCreated AS CapacityRqmtHasNotToBeCreated,
  _ProcessOrder.OrderSequenceNumber AS OrderSequenceNumber,
  _ProcessOrder.MaterialRevisionLevel AS MaterialRevisionLevel,
  _ProcessOrder.MaterialRevisionLevel_2 AS MaterialRevisionLevel_2,
  _ProcessOrder.MfgOrderSplitStatus AS MfgOrderSplitStatus,
  _ProcessOrder.MasterProductionOrder AS MasterProductionOrder,
  _ProcessOrder.BusinessArea AS BusinessArea,
  _ProcessOrder.CompanyCode AS CompanyCode,
  _ProcessOrder.RequestingCompanyCode AS RequestingCompanyCode,
  _ProcessOrder.ControllingArea AS ControllingArea,
  _ProcessOrder.ProfitCenter AS ProfitCenter,
  _ProcessOrder.CostCenter AS CostCenter,
  _ProcessOrder.RequestingCostCenter AS RequestingCostCenter,
  _ProcessOrder.ResponsibleCostCenter AS ResponsibleCostCenter,
  _ProcessOrder.CostElement AS CostElement,
  _ProcessOrder.GLAccount AS GLAccount,
  _ProcessOrder.ProductCostCollector AS ProductCostCollector,
  _ProcessOrder.CostingSheet AS CostingSheet,
  _ProcessOrder.ControllingObjectClass AS ControllingObjectClass,
  _ProcessOrder.FunctionalArea AS FunctionalArea,
  _ProcessOrder.JointVenture AS JointVenture,
  _ProcessOrder.JointVentureClass AS JointVentureClass,
  _ProcessOrder.JointVentureSubClass AS JointVentureSubClass,
  _ProcessOrder.JointVentureOriginalCostObject AS JointVentureOriginalCostObject,
  _ProcessOrder.JointVentureObjectType AS JointVentureObjectType,
  _ProcessOrder.TaxJurisdiction AS TaxJurisdiction,
  _ProcessOrder.InvestmentReason AS InvestmentReason,
  _ProcessOrder.EnvironmentalInvestmentReason AS EnvironmentalInvestmentReason,
  _ProcessOrder.ActualCostsCostingVariant AS ActualCostsCostingVariant,
  _ProcessOrder.PlannedCostsCostingVariant AS PlannedCostsCostingVariant,
  _ProcessOrder.OrderProcessingGroup AS OrderProcessingGroup,
  _ProcessOrder.Material AS Material,
  _ProcessOrder.BillOfOperationsType AS BillOfOperationsType,
  _ProcessOrder.BillOfOperations AS BillOfOperations,
  _ProcessOrder.BillOfOperationsGroup AS BillOfOperationsGroup,
  _ProcessOrder.BillOfOperationsVariant AS BillOfOperationsVariant,
  _ProcessOrder.BOOInternalVersionCounter AS BOOInternalVersionCounter,
  _ProcessOrder.BillOfOperationsApplication AS BillOfOperationsApplication,
  _ProcessOrder.BillOfOperationsUsage AS BillOfOperationsUsage,
  _ProcessOrder.BillOfOperationsVersion AS BillOfOperationsVersion,
  _ProcessOrder.BOOExplosionDate AS BOOExplosionDate,
  _ProcessOrder.BOOValidityStartDate AS BOOValidityStartDate,
  _ProcessOrder.BillOfMaterialCategory AS BillOfMaterialCategory,
  _ProcessOrder.BillOfMaterial AS BillOfMaterial,
  _ProcessOrder.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  _ProcessOrder.BillOfMaterialVariant AS BillOfMaterialVariant,
  _ProcessOrder.BillOfMaterialVariantUsage AS BillOfMaterialVariantUsage,
  _ProcessOrder.BillOfMaterialVersion AS BillOfMaterialVersion,
  _ProcessOrder.BOMExplosionDate AS BOMExplosionDate,
  _ProcessOrder.BOMValidityStartDate AS BOMValidityStartDate,
  _ProcessOrder.PlannedStartDate AS PlannedStartDate,
  _ProcessOrder.PlannedStartTime AS PlannedStartTime,
  _ProcessOrder.PlannedEndDate AS PlannedEndDate,
  _ProcessOrder.PlannedEndTime AS PlannedEndTime,
  _ProcessOrder.ScheduledBasicStartDate AS ScheduledBasicStartDate,
  _ProcessOrder.ScheduledBasicStartTime AS ScheduledBasicStartTime,
  _ProcessOrder.ScheduledBasicEndDate AS ScheduledBasicEndDate,
  _ProcessOrder.ScheduledBasicEndTime AS ScheduledBasicEndTime,
  _ProcessOrder.ScheduledReleaseDate AS ScheduledReleaseDate,
  _ProcessOrder.ActualStartDate AS ActualStartDate,
  _ProcessOrder.ActualStartTime AS ActualStartTime,
  _ProcessOrder.ActualEndDate AS ActualEndDate,
  _ProcessOrder.ActualReleasedDate AS ActualReleasedDate,
  _ProcessOrder.ConfirmedEndDate AS ConfirmedEndDate,
  _ProcessOrder.ConfirmedEndTime AS ConfirmedEndTime,
  _ProcessOrder.ScheduledFcstdReleaseDate AS ScheduledFcstdReleaseDate,
  _ProcessOrder.TotalCommitmentDate AS TotalCommitmentDate,
  _ProcessOrder.LastScheduledDate AS LastScheduledDate,
  _ProcessOrder.PlannedReleaseDate AS PlannedReleaseDate,
  _ProcessOrder.PlannedCompletionDate AS PlannedCompletionDate,
  _ProcessOrder.TechnicalCompletionDate AS TechnicalCompletionDate,
  _ProcessOrder.BaseUnit AS BaseUnit,
  _ProcessOrder.OrderPlannedTotalQty AS OrderPlannedTotalQty,
  _ProcessOrder.OrderPlannedScrapQty AS OrderPlannedScrapQty,
  _ProcessOrder.OrderConfirmedYieldQty AS OrderConfirmedYieldQty,
  _ProcessOrder.OrderConfirmedScrapQty AS OrderConfirmedScrapQty,
  _ProcessOrder.MfgOrderConfirmedReworkQty AS MfgOrderConfirmedReworkQty,
  _ProcessOrder.MaterialFromLotSizeQuantity AS MaterialFromLotSizeQuantity,
  _ProcessOrder.MaterialToLotSizeQuantity AS MaterialToLotSizeQuantity,
  _ProcessOrder.MaterialBaseUnit AS MaterialBaseUnit,
  _ProcessOrder.PlannedTotalQtyInBaseUnit AS PlannedTotalQtyInBaseUnit,
  _ProcessOrder.Currency AS Currency,
  _ProcessOrder.EstimatedTotalOrderCost AS EstimatedTotalOrderCost,
  _ProcessOrder._BaseUnit AS _BaseUnit,
  _ProcessOrder._BasicSchedulingType AS _BasicSchedulingType,
  _ProcessOrder._BillOfOperations AS _BillOfOperations,
  _ProcessOrder._BillOfOperationsApplication AS _BillOfOperationsApplication,
  _ProcessOrder._BillOfOperationsChangeState AS _BillOfOperationsChangeState,
  _ProcessOrder._BillOfOperationsGroup AS _BillOfOperationsGroup,
  _ProcessOrder._BillOfOperationsGroup2 AS _BillOfOperationsGroup2,
  _ProcessOrder._BillOfOperationsType AS _BillOfOperationsType,
  _ProcessOrder._BillOfOperationsUsage AS _BillOfOperationsUsage,
  _ProcessOrder._BusinessArea AS _BusinessArea,
  _ProcessOrder._CapacityRequirement AS _CapacityRequirement,
  _ProcessOrder._ChangeNumber AS _ChangeNumber,
  _ProcessOrder._CompanyCode AS _CompanyCode,
  _ProcessOrder._ConfirmationGroup AS _ConfirmationGroup,
  _ProcessOrder._ControllingArea AS _ControllingArea,
  _ProcessOrder._ControllingObjectClass AS _ControllingObjectClass,
  _ProcessOrder._CostCenter AS _CostCenter,
  _ProcessOrder._CreatedByUser AS _CreatedByUser,
  _ProcessOrder._CreatedByUserContactCard AS _CreatedByUserContactCard,
  _ProcessOrder._Currency AS _Currency,
  _ProcessOrder._FunctionalArea AS _FunctionalArea,
  _ProcessOrder._InspectionLot AS _InspectionLot,
  _ProcessOrder._LastChangedByUser AS _LastChangedByUser,
  _ProcessOrder._LastChgdByUserContactCard AS _LastChgdByUserContactCard,
  _ProcessOrder._LocationPlant AS _LocationPlant,
  _ProcessOrder._LongText AS _LongText,
  _ProcessOrder._MaintenanceObjectLocation AS _MaintenanceObjectLocation,
  _ProcessOrder._MainWorkCenterPlant AS _MainWorkCenterPlant,
  _ProcessOrder._MRPController AS _MRPController,
  _ProcessOrder._OrderCategory AS _OrderCategory,
  _ProcessOrder._OrderComponent AS _OrderComponent,
  _ProcessOrder._OrderInternalID AS _OrderInternalID,
  _ProcessOrder._OrderItem AS _OrderItem,
  _ProcessOrder._OrderMainItem AS _OrderMainItem,
  _ProcessOrder._OrderOperation AS _OrderOperation,
  _ProcessOrder._OrderProcessingGroup AS _OrderProcessingGroup,
  _ProcessOrder._OrderSequence AS _OrderSequence,
  _ProcessOrder._OrderType AS _OrderType,
  _ProcessOrder._OrderTypeDetails AS _OrderTypeDetails,
  _ProcessOrder._OrdInternalBillOfOperations AS _OrdInternalBillOfOperations,
  _ProcessOrder._Plant AS _Plant,
  _ProcessOrder._ProductCostCollector AS _ProductCostCollector,
  _ProcessOrder._ProductionSchedulingProfile AS _ProductionSchedulingProfile,
  _ProcessOrder._ProductionSupervisor AS _ProductionSupervisor,
  _ProcessOrder._ProfitCenter AS _ProfitCenter,
  _ProcessOrder._Project AS _Project,
  _ProcessOrder._ProjectBasicData AS _ProjectBasicData,
  _ProcessOrder._ProjectBasicData2 AS _ProjectBasicData2,
  _ProcessOrder._Reservation AS _Reservation,
  _ProcessOrder._ResponsibleCostCenter AS _ResponsibleCostCenter,
  _ProcessOrder._ResponsiblePlannerGroup AS _ResponsiblePlannerGroup,
  _ProcessOrder._RFM_MasterProductOrder AS _RFM_MasterProductOrder,
  _ProcessOrder._SalesOrder AS _SalesOrder,
  _ProcessOrder._SalesOrderItem AS _SalesOrderItem,
  _ProcessOrder._SettlementReservation AS _SettlementReservation,
  _ProcessOrder._StatusObject AS _StatusObject,
  _ProcessOrder._StatusObjectStatus AS _StatusObjectStatus,
  _ProcessOrder._SuperiorProjectNetwork AS _SuperiorProjectNetwork,
  _ProcessOrder._WBSElement AS _WBSElement,
  _ProcessOrder._WBSElementBasicData AS _WBSElementBasicData,
  _ProcessOrder._WBSElementBasicData2 AS _WBSElementBasicData2,
  _ProcessOrder._WorkCenter AS _WorkCenter
FROM I_LogisticsOrder AS _ProcessOrder
INNER JOIN P_ProcOrdAORListDistinct AS _AORList ON /* join condition not captured in parsed metadata */
;