P_PROCORDAORLIST_2
Process Orders for AOR
P_PROCORDAORLIST_2 is a CDS View in S/4HANA. Process Orders for AOR. It contains 69 fields. 7 CDS views read from this table.
CDS Views using this table (7)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ProcOrderOperationDurn | view | inner | COMPOSITE | Process Order Operation Durations |
| P_ProcOrdInspLotUsgeDcsnCodeR | view_entity | from | COMPOSITE | Process Order Inspection Lots with Usage Decision Code R |
| P_ProcOrdInspRjctdChar | view | from | COMPOSITE | process order inspection lot characteristics |
| P_ProcOrdMgmtBasic_2 | view_entity | from | COMPOSITE | Process order |
| P_ProcOrdMgmtOperation | view | inner | COMPOSITE | Process order operation basic view |
| P_ProcOrdOperationQtyIssue | view | inner | COMPOSITE | Process order operations quantity issue |
| P_ProcOrdOpQualityIssAggrgn | view | inner | COMPOSITE | Process order quality issue aggregation |
Fields (69)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | OrderID | ProcessOrder | 1 |
| _BusinessArea | _BusinessArea | 1 | |
| _SettlementReservation | _SettlementReservation | 1 | |
| ActualCostsCostingVariant | ActualCostsCostingVariant | 1 | |
| BillOfMaterialCategory | BillOfMaterialCategory | 1 | |
| BillOfMaterialVariant | BillOfMaterialVariant | 1 | |
| BillOfMaterialVariantUsage | BillOfMaterialVariantUsage | 1 | |
| BillOfMaterialVersion | BillOfMaterialVersion | 1 | |
| BillOfOperations | BillOfOperations | 1 | |
| BillOfOperationsGroup | BillOfOperationsGroup | 1 | |
| BillOfOperationsType | BillOfOperationsType | 1 | |
| BillOfOperationsUsage | BillOfOperationsUsage | 1 | |
| BillOfOperationsVariant | BillOfOperationsVariant | 1 | |
| BillOfOperationsVersion | BillOfOperationsVersion | 1 | |
| BOMExplosionDate | BOMExplosionDate | 1 | |
| BOMValidityStartDate | BOMValidityStartDate | 1 | |
| BOOExplosionDate | BOOExplosionDate | 1 | |
| BOOInternalVersionCounter | BOOInternalVersionCounter | 1 | |
| BOOValidityStartDate | BOOValidityStartDate | 1 | |
| BusinessArea | BusinessArea | 1 | |
| CapacityActiveVersion | CapacityActiveVersion | 1 | |
| CapacityRequirement | CapacityRequirement | 1 | |
| CapacityRqmtHasNotToBeCreated | CapacityRqmtHasNotToBeCreated | 1 | |
| ChangeNumber | ChangeNumber | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ConditionApplication | ConditionApplication | 1 | |
| ControllingArea | ControllingArea | 2 | |
| CostCenter | CostCenter | 1 | |
| CostElement | CostElement | 1 | |
| CostingSheet | CostingSheet | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| Currency | Currency | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| GLAccount | GLAccount | 1 | |
| InspectionLot | InspectionLot | 2 | |
| IsMarkedForDeletion | IsMarkedForDeletion | 1 | |
| LastChangeDate | LastChangeDate | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LastChangeTime | LastChangeTime | 1 | |
| LeadingOrder | LeadingOrder | 1 | |
| MasterProductionOrder | MasterProductionOrder | 1 | |
| Material | BillOfOperationsMaterial | 1 | |
| MaterialBaseUnit | BaseUnit | 1 | |
| MfgOrderConfirmation | MfgOrderConfirmation | 1 | |
| MfgOrderConfirmedReworkQty | MfgOrderConfirmedReworkQty | 1 | |
| MfgOrderHasMultipleItems | MfgOrderHasMultipleItems | 1 | |
| MfgOrderHierarchyLevel | MfgOrderHierarchyLevel | 1 | |
| MfgOrderIsPartOfCollvOrder | MfgOrderIsPartOfCollvOrder | 1 | |
| MfgOrderSuperiorMfgOrder | SuperiorOrder | 1 | |
| ObjectInternalID | OrdObjectInternalID | 1 | |
| OrderCategory | ManufacturingOrderCategory | 1 | |
| OrderIsEventBasedPosting | OrderIsEventBasedPosting | 1 | |
| OrderIsNotCostedAutomatically | OrderIsNotCostedAutomatically | 1 | |
| OrderSequenceNumber | OrderSequenceNumber | 1 | |
| OrdIsNotSchedldAutomatically | OrdIsNotSchedldAutomatically | 1 | |
| PlannedCostsCostingVariant | PlannedCostsCostingVariant | 1 | |
| PlannedTotalQtyInBaseUnit | PlndQtyInBaseUnit | 1 | |
| PriorityCode | ManufacturingOrderImportance | 1 | |
| ProdnProcgIsFlexible | ProdnProcgIsFlexible | 1 | |
| ProductCostCollector | ProductCostCollector | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ReferenceOrder | ReferenceOrder | 1 | |
| Reservation | Reservation | 1 | |
| ResponsibleCostCenter | ResponsibleCostCenter | 1 | |
| ResponsiblePlannerGroup | ResponsiblePlannerGroup | 1 | |
| ScheduledBasicEndDate | ScheduledBasicEndDate | 3 | |
| ScheduledBasicStartDate | ScheduledBasicStartDate | 3 | |
| TechnicalCompletionDate | MfgOrderActualCompletionDate | 1 | |
| TotalCommitmentDate | MfgOrderTotalCommitmentDate | 1 |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Process Orders for AOR'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #X,
sizeCategory: #S,
dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_ProcOrdAORList_2
as select from I_PPAreaOfResponsibility as AOR1
inner join I_LogisticsOrder as _Orders on AOR1.Plant = _Orders.Plant
and AOR1.ProductionSupervisor = _Orders.ProductionSupervisor
and _Orders.OrderCategory = '40'
{
key _Orders.OrderID,
_Orders.OrderInternalBillOfOperations as OrderInternalID,
_Orders.OrderType,
_Orders.Plant,
_Orders.ProductionSupervisor,
_Orders.ObjectInternalID as ProcessOrderObjectNumber,
// added for passing filters to AFKO
_Orders.ScheduledBasicStartDate,
_Orders.ScheduledBasicEndDate,
_Orders.OrderCategory,
_Orders.OrderDescription,
_Orders.OrderHasLongText,
_Orders.LongTextLanguage,
_Orders.IsMarkedForDeletion,
_Orders.IsStatisticalOrder,
_Orders.MfgOrderHasMultipleItems,
_Orders.MfgOrderIsPartOfCollvOrder,
_Orders.OrderIsRefurbishmentOrder,
_Orders.PriorityCode,
_Orders.MfgOrderHierarchyLevel,
_Orders.OrderHierarchyLevelValue,
_Orders.OrderHierarchyPathValue,
_Orders.ProdnProcgIsFlexible,
_Orders.OrderIsNotCostedAutomatically,
_Orders.OrdIsNotSchedldAutomatically,
_Orders.CreationDate,
_Orders.CreationTime,
_Orders.CreatedByUser,
_Orders.LastChangeDate,
_Orders.LastChangeTime,
_Orders.LastChangedByUser,
_Orders.OrderInternalBillOfOperations,
_Orders.ReferenceOrder,
_Orders.LeadingOrder,
_Orders.MfgOrderSuperiorMfgOrder,
_Orders.MainWorkCenter,
_Orders.MainWorkCenterPlant,
_Orders.MaintenanceObjectLocation,
_Orders.LocationPlant,
_Orders.MRPController,
_Orders.ProductionSchedulingProfile,
_Orders.ResponsiblePlannerGroup,
_Orders.SalesOrder,
_Orders.SalesOrderItem,
_Orders.WBSElementInternalID,
_Orders.WBSElementInternalID_2,
_Orders.ProjectInternalID,
_Orders.ProjectInternalID_2,
_Orders.SuperiorProjectNetwork,
_Orders.Reservation,
_Orders.SettlementReservation,
_Orders.MfgOrderConfirmation,
_Orders.MfgOrderConfirmationCount,
_Orders.CapacityRequirement,
_Orders.InspectionLot,
_Orders.ChangeNumber,
_Orders.EngineeringChangeOrder,
_Orders.BasicSchedulingType,
_Orders.ForecastSchedulingType,
_Orders.ProdAvailyCheckPlanningType,
_Orders.SchedulingIsAllowingForBreaks,
_Orders.ProjInterestCalcProfile,
_Orders.NtwkAccountAssignmentCode,
_Orders.NetworkProfile,
_Orders.ObjectInternalID,
_Orders.ProductConfiguration,
_Orders.ConditionApplication,
_Orders.ExternalOrder,
_Orders.RequestOrderType,
_Orders.CapacityActiveVersion,
_Orders.CapacityRqmtHasNotToBeCreated,
_Orders.OrderSequenceNumber,
_Orders.MaterialRevisionLevel,
_Orders.MaterialRevisionLevel_2,
_Orders.MfgOrderSplitStatus,
_Orders.MasterProductionOrder,
_Orders.BusinessArea,
_Orders.CompanyCode,
_Orders.RequestingCompanyCode,
_Orders.ControllingArea,
_Orders.ProfitCenter,
_Orders.CostCenter,
_Orders.RequestingCostCenter,
_Orders.ResponsibleCostCenter,
_Orders.CostElement,
_Orders.GLAccount,
_Orders.ProductCostCollector,
_Orders.CostingSheet,
_Orders.ControllingObjectClass,
_Orders.FunctionalArea,
_Orders.OverheadCode,
_Orders.ResultAnalysisInternalID,
_Orders.VarianceKey,
_Orders.JointVenture,
_Orders.JointVentureClass,
_Orders.JointVentureSubClass,
_Orders.JointVentureOriginalCostObject,
_Orders.JointVentureObjectType,
_Orders.TaxJurisdiction,
_Orders.InvestmentReason,
_Orders.EnvironmentalInvestmentReason,
_Orders.ActualCostsCostingVariant,
_Orders.PlannedCostsCostingVariant,
_Orders.OrderProcessingGroup,
_Orders.OrderIsEventBasedPosting,
_Orders.EventBasedPostingMethod,
_Orders.EventBasedProcessingKey,
_Orders.OrderSettlementTriggerType,
_Orders.Material,
_Orders.BillOfOperationsType,
_Orders.BillOfOperations,
_Orders.BillOfOperationsGroup,
_Orders.BillOfOperationsVariant,
_Orders.BOOInternalVersionCounter,
_Orders.BillOfOperationsApplication,
_Orders.BillOfOperationsUsage,
_Orders.BillOfOperationsVersion,
_Orders.BOOExplosionDate,
_Orders.BOOValidityStartDate,
_Orders.BillOfMaterialCategory,
_Orders.BillOfMaterial,
_Orders.BillOfMaterialInternalID,
_Orders.BillOfMaterialVariant,
_Orders.BillOfMaterialVariantUsage,
_Orders.BillOfMaterialVersion,
_Orders.BOMExplosionDate,
_Orders.BOMValidityStartDate,
_Orders.SchedulingFloatProfile,
_Orders.FloatBeforeProductionInWrkDays,
_Orders.FloatAfterProductionInWorkDays,
_Orders.ReleasePeriodInWorkDays,
_Orders.ChangeToScheduledDatesIsMade,
_Orders.PlannedStartDate,
_Orders.PlannedStartTime,
_Orders.PlannedEndDate,
_Orders.PlannedEndTime,
_Orders.PlannedReleaseDate,
_Orders.ScheduledBasicStartTime,
_Orders.ScheduledBasicEndTime,
_Orders.ScheduledReleaseDate,
_Orders.ActualStartDate,
_Orders.ActualStartTime,
_Orders.ConfirmedEndDate,
_Orders.ConfirmedEndTime,
_Orders.ActualEndDate,
_Orders.ActualDeliveryDate,
_Orders.ActualReleasedDate,
_Orders.ScheduledForecastedStartDate,
_Orders.ScheduledForecastedStartTime,
_Orders.ScheduledForecastedEndDate,
_Orders.ScheduledForecastedEndTime,
_Orders.ScheduledFcstdReleaseDate,
_Orders.ForecastedStartDate,
_Orders.ForecastedStartTime,
_Orders.ForecastedEndDate,
_Orders.ForecastedEndTime,
_Orders.TotalCommitmentDate,
_Orders.LastScheduledDate,
_Orders.PlannedCompletionDate,
_Orders.TechnicalCompletionDate,
_Orders.BaseUnit,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
_Orders.OrderPlannedTotalQty,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
_Orders.OrderPlannedScrapQty,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
_Orders.OrderConfirmedYieldQty,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
_Orders.OrderConfirmedScrapQty,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
_Orders.MfgOrderConfirmedReworkQty,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
_Orders.MaterialFromLotSizeQuantity,
@Semantics.quantity.unitOfMeasure: 'BaseUnit'
_Orders.MaterialToLotSizeQuantity,
_Orders.MaterialBaseUnit,
@Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
_Orders.PlannedTotalQtyInBaseUnit,
_Orders.Currency,
@Semantics.amount.currencyCode: 'Currency'
_Orders.EstimatedTotalOrderCost,
_Orders.CombinedOrderRequestIdentifier,
_Orders.CombnOrdCombinationIdentifier,
_Orders._BaseUnit,
_Orders._BasicSchedulingType,
_Orders._BillOfOperations,
_Orders._BillOfOperationsApplication,
_Orders._BillOfOperationsChangeState,
_Orders._BillOfOperationsGroup,
_Orders._BillOfOperationsGroup2,
_Orders._BillOfOperationsType,
_Orders._BillOfOperationsUsage,
_Orders._BusinessArea,
_Orders._CapacityRequirement,
_Orders._ChangeNumber,
_Orders._CompanyCode,
_Orders._ConfirmationGroup,
_Orders._ControllingArea,
_Orders._ControllingObjectClass,
_Orders._CostCenter,
_Orders._CreatedByUser,
_Orders._CreatedByUserContactCard,
_Orders._Currency,
_Orders._ForecastSchedulingType,
_Orders._FunctionalArea,
_Orders._GLAccount,
_Orders._InspectionLot,
_Orders._LastChangedByUser,
_Orders._LastChgdByUserContactCard,
_Orders._LeadingOrder,
_Orders._LocationPlant,
_Orders._LongText,
_Orders._LongTextLanguage,
_Orders._MaintenanceObjectLocation,
_Orders._MainWorkCenterPlant,
_Orders._MaterialBaseUnit,
_Orders._MRPController,
_Orders._OrderCategory,
_Orders._OrderComponent,
_Orders._OrderInternalID,
_Orders._OrderItem,
_Orders._OrderMainItem,
_Orders._OrderOperation,
_Orders._OrderPriority,
_Orders._OrderProcessingGroup,
_Orders._OrderSequence,
_Orders._OrderType,
_Orders._OrderTypeDetails,
_Orders._OrdInternalBillOfOperations,
_Orders._Plant,
_Orders._ProductCostCollector,
_Orders._ProductionSchedulingProfile,
_Orders._ProductionSupervisor,
_Orders._ProfitCenter,
_Orders._Project,
_Orders._ProjectBasicData,
_Orders._ProjectBasicData2,
_Orders._ReferenceOrder,
_Orders._RequestOrderType,
_Orders._Reservation,
_Orders._ResponsibleCostCenter,
_Orders._ResponsiblePlannerGroup,
_Orders._RFM_MasterProductOrder,
_Orders._SalesOrder,
_Orders._SalesOrderItem,
_Orders._SchedulingFloatProfile,
_Orders._SettlementReservation,
_Orders._StatusObject,
_Orders._StatusObjectStatus,
_Orders._SuperiorOrder,
_Orders._SuperiorProjectNetwork,
_Orders._WBSElement,
_Orders._WBSElementBasicData,
_Orders._WBSElementBasicData2,
_Orders._WorkCenter
}
where
AOR1.WorkCenterInternalID is initial
union
select from I_PPAreaOfResponsibility as AOR2
inner join I_OrderOperationBasic as _OrderOperBasic on _OrderOperBasic.WorkCenterInternalID = AOR2.WorkCenterInternalID
inner join I_LogisticsOrder as _OrdersBasic on _OrdersBasic.OrderInternalBillOfOperations = _OrderOperBasic.OrderInternalID
and AOR2.Plant = _OrdersBasic.Plant
and _OrdersBasic.OrderCategory = '40'
{
key _OrdersBasic.OrderID,
_OrdersBasic.OrderInternalBillOfOperations as OrderInternalID,
_OrdersBasic.OrderType,
_OrdersBasic.Plant,
_OrdersBasic.ProductionSupervisor,
_OrdersBasic.ObjectInternalID as ProcessOrderObjectNumber,
// added for passing filters to AFKO
_OrdersBasic.ScheduledBasicStartDate,
_OrdersBasic.ScheduledBasicEndDate,
_OrdersBasic.OrderCategory,
_OrdersBasic.OrderDescription,
_OrdersBasic.OrderHasLongText,
_OrdersBasic.LongTextLanguage,
_OrdersBasic.IsMarkedForDeletion,
_OrdersBasic.IsStatisticalOrder,
_OrdersBasic.MfgOrderHasMultipleItems,
_OrdersBasic.MfgOrderIsPartOfCollvOrder,
_OrdersBasic.OrderIsRefurbishmentOrder,
_OrdersBasic.PriorityCode,
_OrdersBasic.MfgOrderHierarchyLevel,
_OrdersBasic.OrderHierarchyLevelValue,
_OrdersBasic.OrderHierarchyPathValue,
_OrdersBasic.ProdnProcgIsFlexible,
_OrdersBasic.OrderIsNotCostedAutomatically,
_OrdersBasic.OrdIsNotSchedldAutomatically,
_OrdersBasic.CreationDate,
_OrdersBasic.CreationTime,
_OrdersBasic.CreatedByUser,
_OrdersBasic.LastChangeDate,
_OrdersBasic.LastChangeTime,
_OrdersBasic.LastChangedByUser,
_OrdersBasic.OrderInternalBillOfOperations,
_OrdersBasic.ReferenceOrder,
_OrdersBasic.LeadingOrder,
_OrdersBasic.MfgOrderSuperiorMfgOrder,
_OrdersBasic.MainWorkCenter,
_OrdersBasic.MainWorkCenterPlant,
_OrdersBasic.MaintenanceObjectLocation,
_OrdersBasic.LocationPlant,
_OrdersBasic.MRPController,
_OrdersBasic.ProductionSchedulingProfile,
_OrdersBasic.ResponsiblePlannerGroup,
_OrdersBasic.SalesOrder,
_OrdersBasic.SalesOrderItem,
_OrdersBasic.WBSElementInternalID,
_OrdersBasic.WBSElementInternalID_2,
_OrdersBasic.ProjectInternalID,
_OrdersBasic.ProjectInternalID_2,
_OrdersBasic.SuperiorProjectNetwork,
_OrdersBasic.Reservation,
_OrdersBasic.SettlementReservation,
_OrdersBasic.MfgOrderConfirmation,
_OrdersBasic.MfgOrderConfirmationCount,
_OrdersBasic.CapacityRequirement,
_OrdersBasic.InspectionLot,
_OrdersBasic.ChangeNumber,
_OrdersBasic.EngineeringChangeOrder,
_OrdersBasic.BasicSchedulingType,
_OrdersBasic.ForecastSchedulingType,
_OrdersBasic.ProdAvailyCheckPlanningType,
_OrdersBasic.SchedulingIsAllowingForBreaks,
_OrdersBasic.ProjInterestCalcProfile,
_OrdersBasic.NtwkAccountAssignmentCode,
_OrdersBasic.NetworkProfile,
_OrdersBasic.ObjectInternalID,
_OrdersBasic.ProductConfiguration,
_OrdersBasic.ConditionApplication,
_OrdersBasic.ExternalOrder,
_OrdersBasic.RequestOrderType,
_OrdersBasic.CapacityActiveVersion,
_OrdersBasic.CapacityRqmtHasNotToBeCreated,
_OrdersBasic.OrderSequenceNumber,
_OrdersBasic.MaterialRevisionLevel,
_OrdersBasic.MaterialRevisionLevel_2,
_OrdersBasic.MfgOrderSplitStatus,
_OrdersBasic.MasterProductionOrder,
_OrdersBasic.BusinessArea,
_OrdersBasic.CompanyCode,
_OrdersBasic.RequestingCompanyCode,
_OrdersBasic.ControllingArea,
_OrdersBasic.ProfitCenter,
_OrdersBasic.CostCenter,
_OrdersBasic.RequestingCostCenter,
_OrdersBasic.ResponsibleCostCenter,
_OrdersBasic.CostElement,
_OrdersBasic.GLAccount,
_OrdersBasic.ProductCostCollector,
_OrdersBasic.CostingSheet,
_OrdersBasic.ControllingObjectClass,
_OrdersBasic.FunctionalArea,
_OrdersBasic.OverheadCode,
_OrdersBasic.ResultAnalysisInternalID,
_OrdersBasic.VarianceKey,
_OrdersBasic.JointVenture,
_OrdersBasic.JointVentureClass,
_OrdersBasic.JointVentureSubClass,
_OrdersBasic.JointVentureOriginalCostObject,
_OrdersBasic.JointVentureObjectType,
_OrdersBasic.TaxJurisdiction,
_OrdersBasic.InvestmentReason,
_OrdersBasic.EnvironmentalInvestmentReason,
_OrdersBasic.ActualCostsCostingVariant,
_OrdersBasic.PlannedCostsCostingVariant,
_OrdersBasic.OrderProcessingGroup,
_OrdersBasic.OrderIsEventBasedPosting,
_OrdersBasic.EventBasedPostingMethod,
_OrdersBasic.EventBasedProcessingKey,
_OrdersBasic.OrderSettlementTriggerType,
_OrdersBasic.Material,
_OrdersBasic.BillOfOperationsType,
_OrdersBasic.BillOfOperations,
_OrdersBasic.BillOfOperationsGroup,
_OrdersBasic.BillOfOperationsVariant,
_OrdersBasic.BOOInternalVersionCounter,
_OrdersBasic.BillOfOperationsApplication,
_OrdersBasic.BillOfOperationsUsage,
_OrdersBasic.BillOfOperationsVersion,
_OrdersBasic.BOOExplosionDate,
_OrdersBasic.BOOValidityStartDate,
_OrdersBasic.BillOfMaterialCategory,
_OrdersBasic.BillOfMaterial,
_OrdersBasic.BillOfMaterialInternalID,
_OrdersBasic.BillOfMaterialVariant,
_OrdersBasic.BillOfMaterialVariantUsage,
_OrdersBasic.BillOfMaterialVersion,
_OrdersBasic.BOMExplosionDate,
_OrdersBasic.BOMValidityStartDate,
_OrdersBasic.SchedulingFloatProfile,
_OrdersBasic.FloatBeforeProductionInWrkDays,
_OrdersBasic.FloatAfterProductionInWorkDays,
_OrdersBasic.ReleasePeriodInWorkDays,
_OrdersBasic.ChangeToScheduledDatesIsMade,
_OrdersBasic.PlannedStartDate,
_OrdersBasic.PlannedStartTime,
_OrdersBasic.PlannedEndDate,
_OrdersBasic.PlannedEndTime,
_OrdersBasic.PlannedReleaseDate,
_OrdersBasic.ScheduledBasicStartTime,
_OrdersBasic.ScheduledBasicEndTime,
_OrdersBasic.ScheduledReleaseDate,
_OrdersBasic.ActualStartDate,
_OrdersBasic.ActualStartTime,
_OrdersBasic.ConfirmedEndDate,
_OrdersBasic.ConfirmedEndTime,
_OrdersBasic.ActualEndDate,
_OrdersBasic.ActualDeliveryDate,
_OrdersBasic.ActualReleasedDate,
_OrdersBasic.ScheduledForecastedStartDate,
_OrdersBasic.ScheduledForecastedStartTime,
_OrdersBasic.ScheduledForecastedEndDate,
_OrdersBasic.ScheduledForecastedEndTime,
_OrdersBasic.ScheduledFcstdReleaseDate,
_OrdersBasic.ForecastedStartDate,
_OrdersBasic.ForecastedStartTime,
_OrdersBasic.ForecastedEndDate,
_OrdersBasic.ForecastedEndTime,
_OrdersBasic.TotalCommitmentDate,
_OrdersBasic.LastScheduledDate,
_OrdersBasic.PlannedCompletionDate,
_OrdersBasic.TechnicalCompletionDate,
_OrdersBasic.BaseUnit,
_OrdersBasic.OrderPlannedTotalQty,
_OrdersBasic.OrderPlannedScrapQty,
_OrdersBasic.OrderConfirmedYieldQty,
_OrdersBasic.OrderConfirmedScrapQty,
_OrdersBasic.MfgOrderConfirmedReworkQty,
_OrdersBasic.MaterialFromLotSizeQuantity,
_OrdersBasic.MaterialToLotSizeQuantity,
_OrdersBasic.MaterialBaseUnit,
_OrdersBasic.PlannedTotalQtyInBaseUnit,
_OrdersBasic.Currency,
_OrdersBasic.EstimatedTotalOrderCost,
_OrdersBasic.CombinedOrderRequestIdentifier,
_OrdersBasic.CombnOrdCombinationIdentifier,
_OrdersBasic._BaseUnit,
_OrdersBasic._BasicSchedulingType,
_OrdersBasic._BillOfOperations,
_OrdersBasic._BillOfOperationsApplication,
_OrdersBasic._BillOfOperationsChangeState,
_OrdersBasic._BillOfOperationsGroup,
_OrdersBasic._BillOfOperationsGroup2,
_OrdersBasic._BillOfOperationsType,
_OrdersBasic._BillOfOperationsUsage,
_OrdersBasic._BusinessArea,
_OrdersBasic._CapacityRequirement,
_OrdersBasic._ChangeNumber,
_OrdersBasic._CompanyCode,
_OrdersBasic._ConfirmationGroup,
_OrdersBasic._ControllingArea,
_OrdersBasic._ControllingObjectClass,
_OrdersBasic._CostCenter,
_OrdersBasic._CreatedByUser,
_OrdersBasic._CreatedByUserContactCard,
_OrdersBasic._Currency,
_OrdersBasic._ForecastSchedulingType,
_OrdersBasic._FunctionalArea,
_OrdersBasic._GLAccount,
_OrdersBasic._InspectionLot,
_OrdersBasic._LastChangedByUser,
_OrdersBasic._LastChgdByUserContactCard,
_OrdersBasic._LeadingOrder,
_OrdersBasic._LocationPlant,
_OrdersBasic._LongText,
_OrdersBasic._LongTextLanguage,
_OrdersBasic._MaintenanceObjectLocation,
_OrdersBasic._MainWorkCenterPlant,
_OrdersBasic._MaterialBaseUnit,
_OrdersBasic._MRPController,
_OrdersBasic._OrderCategory,
_OrdersBasic._OrderComponent,
_OrdersBasic._OrderInternalID,
_OrdersBasic._OrderItem,
_OrdersBasic._OrderMainItem,
_OrdersBasic._OrderOperation,
_OrdersBasic._OrderPriority,
_OrdersBasic._OrderProcessingGroup,
_OrdersBasic._OrderSequence,
_OrdersBasic._OrderType,
_OrdersBasic._OrderTypeDetails,
_OrdersBasic._OrdInternalBillOfOperations,
_OrdersBasic._Plant,
_OrdersBasic._ProductCostCollector,
_OrdersBasic._ProductionSchedulingProfile,
_OrdersBasic._ProductionSupervisor,
_OrdersBasic._ProfitCenter,
_OrdersBasic._Project,
_OrdersBasic._ProjectBasicData,
_OrdersBasic._ProjectBasicData2,
_OrdersBasic._ReferenceOrder,
_OrdersBasic._RequestOrderType,
_OrdersBasic._Reservation,
_OrdersBasic._ResponsibleCostCenter,
_OrdersBasic._ResponsiblePlannerGroup,
_OrdersBasic._RFM_MasterProductOrder,
_OrdersBasic._SalesOrder,
_OrdersBasic._SalesOrderItem,
_OrdersBasic._SchedulingFloatProfile,
_OrdersBasic._SettlementReservation,
_OrdersBasic._StatusObject,
_OrdersBasic._StatusObjectStatus,
_OrdersBasic._SuperiorOrder,
_OrdersBasic._SuperiorProjectNetwork,
_OrdersBasic._WBSElement,
_OrdersBasic._WBSElementBasicData,
_OrdersBasic._WBSElementBasicData2,
_OrdersBasic._WorkCenter
}
where
AOR2.ProductionSupervisor is initial
and AOR2.WorkCenterInternalID is not initial