P_ProcessOrderHeader

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Process Order Header'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.private: true
@VDM.viewType:  #COMPOSITE
define view entity P_ProcessOrderHeader
  as select from I_LogisticsOrder         as _ProcessOrder
    inner join   P_ProcOrdAORListDistinct as _AORList on  _AORList.OrderID                 = _ProcessOrder.OrderID
    //    added for passing filters to AFKO

                                                      and _AORList.Plant                   = _ProcessOrder.Plant
                                                      and _AORList.ScheduledBasicStartDate = _ProcessOrder.ScheduledBasicStartDate
                                                      and _AORList.ScheduledBasicEndDate   = _ProcessOrder.ScheduledBasicEndDate
  //as select from P_ProcOrdAORListDistinct as _AORList

  //    inner join   I_LogisticsOrder         as _ProcessOrder on  _AORList.OrderID            = _ProcessOrder.OrderID

  //                                                           and _ProcessOrder.OrderCategory = '40'

{
  _ProcessOrder.OrderID,
  _ProcessOrder.OrderCategory,
  _ProcessOrder.OrderType,
  _ProcessOrder.OrderDescription,
  _ProcessOrder.OrderHasLongText,
  _ProcessOrder.IsMarkedForDeletion,
  _ProcessOrder.MfgOrderHasMultipleItems,
  _ProcessOrder.MfgOrderIsPartOfCollvOrder,
  _ProcessOrder.MfgOrderSuperiorMfgOrder,
  _ProcessOrder.OrderIsRefurbishmentOrder,
  _ProcessOrder.IsStatisticalOrder,
  _ProcessOrder.PriorityCode,
  _ProcessOrder.MfgOrderHierarchyLevel,
  _ProcessOrder.ProdnProcgIsFlexible,
  _ProcessOrder.OrderIsEventBasedPosting,
  _ProcessOrder.EventBasedPostingMethod,
  _ProcessOrder.CreationDate,
  _ProcessOrder.CreationTime,
  _ProcessOrder.CreatedByUser,
  _ProcessOrder.LastChangeDate,
  _ProcessOrder.LastChangeTime,
  _ProcessOrder.LastChangedByUser,
  _ProcessOrder.OrderInternalBillOfOperations,
  _ProcessOrder.ReferenceOrder,
  _ProcessOrder.LeadingOrder,
  _ProcessOrder.Plant,
  _ProcessOrder.MainWorkCenter,
  _ProcessOrder.MainWorkCenterPlant,
  _ProcessOrder.MaintenanceObjectLocation,
  _ProcessOrder.LocationPlant,
  _ProcessOrder.MRPController,
  _ProcessOrder.ProductionSupervisor,
  _ProcessOrder.ProductionSchedulingProfile,
  _ProcessOrder.ResponsiblePlannerGroup,
  _ProcessOrder.SalesOrder,
  _ProcessOrder.SalesOrderItem,
  _ProcessOrder.WBSElementInternalID,
  _ProcessOrder.WBSElementInternalID_2,
  _ProcessOrder.ProjectInternalID,
  _ProcessOrder.ProjectInternalID_2,
  _ProcessOrder.SuperiorProjectNetwork,
  _ProcessOrder.Reservation,
  _ProcessOrder.SettlementReservation,
  _ProcessOrder.MfgOrderConfirmation,
  _ProcessOrder.MfgOrderConfirmationCount,
  _ProcessOrder.CapacityRequirement,
  _ProcessOrder.InspectionLot,
  _ProcessOrder.ChangeNumber,
  _ProcessOrder.EngineeringChangeOrder,
  _ProcessOrder.BasicSchedulingType,
  _ProcessOrder.ForecastSchedulingType,
  _ProcessOrder.ProdAvailyCheckPlanningType,
  _ProcessOrder.ProjInterestCalcProfile,
  _ProcessOrder.NtwkAccountAssignmentCode,
  _ProcessOrder.NetworkProfile,
  _ProcessOrder.ObjectInternalID,
  _ProcessOrder.ProductConfiguration,
  _ProcessOrder.ConditionApplication,
  _ProcessOrder.ExternalOrder,
  _ProcessOrder.OverheadCode,
  _ProcessOrder.OrderIsNotCostedAutomatically,
  _ProcessOrder.OrdIsNotSchedldAutomatically,
  _ProcessOrder.CapacityActiveVersion,
  _ProcessOrder.CapacityRqmtHasNotToBeCreated,
  _ProcessOrder.OrderSequenceNumber,
  _ProcessOrder.MaterialRevisionLevel,
  _ProcessOrder.MaterialRevisionLevel_2,
  _ProcessOrder.MfgOrderSplitStatus,
  _ProcessOrder.MasterProductionOrder,
  _ProcessOrder.BusinessArea,
  _ProcessOrder.CompanyCode,
  _ProcessOrder.RequestingCompanyCode,
  _ProcessOrder.ControllingArea,
  _ProcessOrder.ProfitCenter,
  _ProcessOrder.CostCenter,
  _ProcessOrder.RequestingCostCenter,
  _ProcessOrder.ResponsibleCostCenter,
  _ProcessOrder.CostElement,
  _ProcessOrder.GLAccount,
  _ProcessOrder.ProductCostCollector,
  _ProcessOrder.CostingSheet,
  _ProcessOrder.ControllingObjectClass,
  _ProcessOrder.FunctionalArea,
  _ProcessOrder.JointVenture,
  _ProcessOrder.JointVentureClass,
  _ProcessOrder.JointVentureSubClass,
  _ProcessOrder.JointVentureOriginalCostObject,
  _ProcessOrder.JointVentureObjectType,
  _ProcessOrder.TaxJurisdiction,
  _ProcessOrder.InvestmentReason,
  _ProcessOrder.EnvironmentalInvestmentReason,
  _ProcessOrder.ActualCostsCostingVariant,
  _ProcessOrder.PlannedCostsCostingVariant,
  _ProcessOrder.OrderProcessingGroup,
  _ProcessOrder.Material,
  _ProcessOrder.BillOfOperationsType,
  _ProcessOrder.BillOfOperations,
  _ProcessOrder.BillOfOperationsGroup,
  _ProcessOrder.BillOfOperationsVariant,
  _ProcessOrder.BOOInternalVersionCounter,
  _ProcessOrder.BillOfOperationsApplication,
  _ProcessOrder.BillOfOperationsUsage,
  _ProcessOrder.BillOfOperationsVersion,
  _ProcessOrder.BOOExplosionDate,
  _ProcessOrder.BOOValidityStartDate,
  _ProcessOrder.BillOfMaterialCategory,
  _ProcessOrder.BillOfMaterial,
  _ProcessOrder.BillOfMaterialInternalID,
  _ProcessOrder.BillOfMaterialVariant,
  _ProcessOrder.BillOfMaterialVariantUsage,
  _ProcessOrder.BillOfMaterialVersion,
  _ProcessOrder.BOMExplosionDate,
  _ProcessOrder.BOMValidityStartDate,
  _ProcessOrder.PlannedStartDate,
  _ProcessOrder.PlannedStartTime,
  _ProcessOrder.PlannedEndDate,
  _ProcessOrder.PlannedEndTime,
  _ProcessOrder.ScheduledBasicStartDate,
  _ProcessOrder.ScheduledBasicStartTime,
  _ProcessOrder.ScheduledBasicEndDate,
  _ProcessOrder.ScheduledBasicEndTime,
  _ProcessOrder.ScheduledReleaseDate,
  _ProcessOrder.ActualStartDate,
  _ProcessOrder.ActualStartTime,
  _ProcessOrder.ActualEndDate,
  _ProcessOrder.ActualReleasedDate,
  _ProcessOrder.ConfirmedEndDate,
  _ProcessOrder.ConfirmedEndTime,
  _ProcessOrder.ScheduledForecastedStartDate,
  _ProcessOrder.ScheduledForecastedStartTime,
  _ProcessOrder.ScheduledForecastedEndDate,
  _ProcessOrder.ScheduledForecastedEndTime,
  _ProcessOrder.ScheduledFcstdReleaseDate,
  _ProcessOrder.ForecastedStartDate,
  _ProcessOrder.ForecastedStartTime,
  _ProcessOrder.ForecastedEndDate,
  _ProcessOrder.ForecastedEndTime,
  _ProcessOrder.TotalCommitmentDate,
  _ProcessOrder.LastScheduledDate,
  _ProcessOrder.PlannedReleaseDate,
  _ProcessOrder.PlannedCompletionDate,
  _ProcessOrder.TechnicalCompletionDate,
  _ProcessOrder.BaseUnit,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  _ProcessOrder.OrderPlannedTotalQty,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  _ProcessOrder.OrderPlannedScrapQty,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  _ProcessOrder.OrderConfirmedYieldQty,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  _ProcessOrder.OrderConfirmedScrapQty,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  _ProcessOrder.MfgOrderConfirmedReworkQty,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  _ProcessOrder.MaterialFromLotSizeQuantity,
  @Semantics.quantity.unitOfMeasure: 'BaseUnit'
  _ProcessOrder.MaterialToLotSizeQuantity,

  _ProcessOrder.MaterialBaseUnit,
  @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
  _ProcessOrder.PlannedTotalQtyInBaseUnit,
  _ProcessOrder.Currency,
  @Semantics.amount.currencyCode: 'Currency'
  _ProcessOrder.EstimatedTotalOrderCost,
  //_ProcessOrder.vogrp,

  _ProcessOrder._BaseUnit,
  _ProcessOrder._BasicSchedulingType,
  _ProcessOrder._BillOfOperations,
  _ProcessOrder._BillOfOperationsApplication,
  _ProcessOrder._BillOfOperationsChangeState,
  _ProcessOrder._BillOfOperationsGroup,
  _ProcessOrder._BillOfOperationsGroup2,
  _ProcessOrder._BillOfOperationsType,
  _ProcessOrder._BillOfOperationsUsage,
  _ProcessOrder._BusinessArea,
  _ProcessOrder._CapacityRequirement,
  _ProcessOrder._ChangeNumber,
  _ProcessOrder._CompanyCode,
  _ProcessOrder._ConfirmationGroup,
  _ProcessOrder._ControllingArea,
  _ProcessOrder._ControllingObjectClass,
  _ProcessOrder._CostCenter,
  _ProcessOrder._CreatedByUser,
  _ProcessOrder._CreatedByUserContactCard,
  _ProcessOrder._Currency,
  _ProcessOrder._ForecastSchedulingType,
  _ProcessOrder._FunctionalArea,
  _ProcessOrder._InspectionLot,
  _ProcessOrder._LastChangedByUser,
  _ProcessOrder._LastChgdByUserContactCard,
  _ProcessOrder._LocationPlant,
  _ProcessOrder._LongText,
  _ProcessOrder._MaintenanceObjectLocation,
  _ProcessOrder._MainWorkCenterPlant,
  _ProcessOrder._MRPController,
  _ProcessOrder._OrderCategory,
  _ProcessOrder._OrderComponent,
  _ProcessOrder._OrderInternalID,
  _ProcessOrder._OrderItem,
  _ProcessOrder._OrderMainItem,
  _ProcessOrder._OrderOperation,
  _ProcessOrder._OrderProcessingGroup,
  _ProcessOrder._OrderSequence,
  _ProcessOrder._OrderType,
  _ProcessOrder._OrderTypeDetails,
  _ProcessOrder._OrdInternalBillOfOperations,
  _ProcessOrder._Plant,
  _ProcessOrder._ProductCostCollector,
  _ProcessOrder._ProductionSchedulingProfile,
  _ProcessOrder._ProductionSupervisor,
  _ProcessOrder._ProfitCenter,
  _ProcessOrder._Project,
  _ProcessOrder._ProjectBasicData,
  _ProcessOrder._ProjectBasicData2,
  _ProcessOrder._Reservation,
  _ProcessOrder._ResponsibleCostCenter,
  _ProcessOrder._ResponsiblePlannerGroup,
  _ProcessOrder._RFM_MasterProductOrder,
  _ProcessOrder._SalesOrder,
  _ProcessOrder._SalesOrderItem,
  _ProcessOrder._SettlementReservation,
  _ProcessOrder._StatusObject,
  _ProcessOrder._StatusObjectStatus,
  _ProcessOrder._SuperiorProjectNetwork,
  _ProcessOrder._WBSElement,
  _ProcessOrder._WBSElementBasicData,
  _ProcessOrder._WBSElementBasicData2,
  _ProcessOrder._WorkCenter
}
where
  _ProcessOrder.OrderCategory = '40'