P_PROCESSORDERHEADER
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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":""
}
}*/