P_PROCESSORDERHEADER

CDS View

Process Order Header

P_PROCESSORDERHEADER is a CDS View in S/4HANA. Process Order Header. It contains 55 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
P_NmbrOfProcOrdOpValidPhases view inner COMPOSITE
P_ProcOrdInspLotUsgeDcsnCodeR view from COMPOSITE
P_ProcOrdInspRjctdChar view from COMPOSITE
P_ProcOrdMgmtBasic view from COMPOSITE
P_ProcOrdOpScrapIssAggrgn view inner COMPOSITE

Fields (55)

KeyField CDS FieldsUsed in Views
KEY OrderID ProcessOrder 3
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 1
CostCenter CostCenter 1
CostElement CostElement 1
CostingSheet CostingSheet 1
CreatedByUser CreatedByUser 1
Currency Currency 1
GLAccount GLAccount 1
InspectionLot InspectionLot 1
IsMarkedForDeletion IsMarkedForDeletion 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
LastChangeTime LastChangeTime 1
LeadingOrder LeadingOrder 1
Material BillOfOperationsMaterial 1
MfgOrderConfirmation MfgOrderConfirmation 1
MfgOrderHasMultipleItems MfgOrderHasMultipleItems 1
MfgOrderHierarchyLevel MfgOrderHierarchyLevel 1
MfgOrderIsPartOfCollvOrder MfgOrderIsPartOfCollvOrder 1
MfgOrderSuperiorMfgOrder SuperiorOrder 1
OrderCategory ManufacturingOrderCategory 1
OrderIsEventBasedPosting OrderIsEventBasedPosting 1
OrderIsNotCostedAutomatically OrderIsNotCostedAutomatically 1
OrderSequenceNumber OrderSequenceNumber 1
OrdIsNotSchedldAutomatically OrdIsNotSchedldAutomatically 1
Plant ProductionPlant 2
ProdnProcgIsFlexible ProdnProcgIsFlexible 1
ProductionSupervisor ProductionSupervisor 2
ProfitCenter ProfitCenter 1
ReferenceOrder ReferenceOrder 1
Reservation Reservation 1
ResponsibleCostCenter ResponsibleCostCenter 1
ResponsiblePlannerGroup ResponsiblePlannerGroup 1
@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
//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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGISTICSORDER",
"P_PROCORDAORLISTDISTINCT"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONS",
"I_BILLOFOPERATIONSCHANGESTATE",
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSTYPE",
"I_BILLOFOPERATIONSUSAGE",
"I_BOOAPPLICATION",
"I_BUSINESSAREA",
"I_CAPACITYREQUIREMENT",
"I_CHANGEMASTER",
"I_COMPANYCODE",
"I_CONFIRMATIONGROUP",
"I_CONTROLLINGAREA",
"I_CONTROLLINGOBJECTCLASS",
"I_COSTCENTER",
"I_CURRENCY",
"I_FUNCTIONALAREA",
"I_INSPECTIONLOT",
"I_LOCATION",
"I_MRPCONTROLLER",
"I_ORDERCATEGORY",
"I_ORDERCOMPONENT",
"I_ORDERINTERNALID",
"I_ORDERITEM",
"I_ORDERLONGTEXT",
"I_ORDEROPERATION",
"I_ORDERPROCESSINGGROUP",
"I_ORDERSEQUENCE",
"I_ORDERTYPE",
"I_ORDERTYPEDETAILS",
"I_ORDINTERNALBILLOFOPERATIONS",
"I_PLANT",
"I_PRODUCTCOSTCTRLGORDER",
"I_PRODUCTIONSCHEDULINGPROFILE",
"I_PRODUCTIONSUPERVISOR",
"I_PROFITCENTER",
"I_PROJECTBASICDATA",
"I_PROJECTBYINTERNALKEY",
"I_PROJECTNETWORK",
"I_RESERVATIONDOCUMENTHEADER",
"I_RESPONSIBLEPLANNERGROUP",
"I_RFM_MASTERPRODUCTORDER",
"I_SALESORDER",
"I_SALESORDERITEM",
"I_SCHEDULINGTYPE",
"I_STATUSOBJECT",
"I_STATUSOBJECTSTATUS",
"I_UNITOFMEASURE",
"I_USER",
"I_USERCONTACTCARD",
"I_WBSELEMENTBASICDATA",
"I_WBSELEMENTBYINTERNALKEY",
"I_WORKCENTERBYSEMANTICKEY"
],
"BASE":
[
"I_LOGISTICSORDER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/