P_PROCESSORDERHEADER
Process Order Header
P_PROCESSORDERHEADER is a CDS View in S/4HANA. Process Order Header. It contains 67 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 (67)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | OrderID | ProcessOrder | 3 |
| _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 | 1 | |
| CostCenter | CostCenter | 1 | |
| CostElement | CostElement | 1 | |
| CostingSheet | CostingSheet | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| Currency | Currency | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| GLAccount | GLAccount | 1 | |
| InspectionLot | InspectionLot | 1 | |
| 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 | |
| OrderCategory | ManufacturingOrderCategory | 1 | |
| OrderIsEventBasedPosting | OrderIsEventBasedPosting | 1 | |
| OrderIsNotCostedAutomatically | OrderIsNotCostedAutomatically | 1 | |
| OrderSequenceNumber | OrderSequenceNumber | 1 | |
| OrdIsNotSchedldAutomatically | OrdIsNotSchedldAutomatically | 1 | |
| PlannedCostsCostingVariant | PlannedCostsCostingVariant | 1 | |
| PlannedTotalQtyInBaseUnit | PlndQtyInBaseUnit | 1 | |
| Plant | ProductionPlant | 2 | |
| ProdnProcgIsFlexible | ProdnProcgIsFlexible | 1 | |
| ProductCostCollector | ProductCostCollector | 1 | |
| ProductionSupervisor | ProductionSupervisor | 2 | |
| ProfitCenter | ProfitCenter | 1 | |
| ReferenceOrder | ReferenceOrder | 1 | |
| Reservation | Reservation | 1 | |
| ResponsibleCostCenter | ResponsibleCostCenter | 1 | |
| ResponsiblePlannerGroup | ResponsiblePlannerGroup | 1 | |
| TechnicalCompletionDate | MfgOrderActualCompletionDate | 1 | |
| TotalCommitmentDate | MfgOrderTotalCommitmentDate | 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'