R_ProcessOrderTP
Process Order Header - TP
R_ProcessOrderTP is a Transactional CDS View that provides data about "Process Order Header - TP" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrder) and exposes 109 fields with key field ProcessOrder. It has 4 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ManufacturingOrder | Header | from |
Associations (4)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | R_ProcessOrderPhaseTP | _Phase | $projection.ProcessOrder = _Phase.ProcessOrder |
| [1..1] | E_ProcessOrder | _Extension | $projection.ProcessOrder = _Extension.OrderID |
| [0..*] | R_ProcessOrderOperationTP | _Operation | |
| [0..*] | R_ProcessOrderComponentTP | _Component | |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.dataMaintenance | #RESTRICTED | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.modelingPattern | #NONE | view | |
| ObjectModel.representativeKey | ProcessOrder | view | |
| ObjectModel.sapObjectNodeType.name | ProcessOrder | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| EndUserText.label | Process Order Header - TP | view |
Fields (109)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ProcessOrder | |||
| ManufacturingOrder | ||||
| ManufacturingOrderCategory | ManufacturingOrderCategory | |||
| ProcessOrderType | ||||
| ProcessOrderText | ManufacturingOrderText | |||
| OrderHasLongText | ManufacturingOrderHasLongText | |||
| LongTextLanguage | LongTextLanguageCode | |||
| OrderImportance | ManufacturingOrderImportance | |||
| IsMarkedForDeletion | IsMarkedForDeletion | |||
| IsCompletelyDelivered | IsCompletelyDelivered | |||
| OrderHasMultipleItems | MfgOrderHasMultipleItems | |||
| OrderIsPartOfCollectiveOrder | MfgOrderIsPartOfCollvOrder | |||
| OrderIsNotCostedAutomatically | OrderIsNotCostedAutomatically | |||
| OrdIsNotSchedldAutomatically | OrdIsNotSchedldAutomatically | |||
| CreationDate | CreationDate | |||
| CreationTime | CreationTime | |||
| CreatedByUser | CreatedByUser | |||
| LastChangeDate | LastChangeDate | |||
| LastChangeTime | LastChangeTime | |||
| LastChangedByUser | LastChangedByUser | |||
| Product | Product | |||
| StorageLocation | StorageLocation | |||
| Batch | Batch | |||
| GoodsRecipientName | GoodsRecipientName | |||
| UnloadingPointName | UnloadingPointName | |||
| InventoryUsabilityCode | InventoryUsabilityCode | |||
| MaterialGoodsReceiptDuration | MaterialGoodsReceiptDuration | |||
| QuantityDistributionKey | QuantityDistributionKey | |||
| OrderInternalID | MfgOrderInternalID | |||
| ReferenceOrder | ReferenceOrder | |||
| ProductionPlant | ProductionPlant | |||
| PlanningPlant | PlanningPlant | |||
| MRPArea | ||||
| MRPController | MRPController | |||
| ProductionSupervisor | ProductionSupervisor | |||
| ProductionSchedulingProfile | ProductionSchedulingProfile | |||
| ResponsiblePlannerGroup | ResponsiblePlannerGroup | |||
| ProductionVersion | ProductionVersion | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| WBSElementInternalID | ||||
| Reservation | Reservation | |||
| SettlementReservation | SettlementReservation | |||
| PlannedOrder | PlannedOrder | |||
| CapacityRequirement | CapacityRequirement | |||
| BasicSchedulingType | BasicSchedulingType | |||
| ObjectInternalID | ObjectInternalID | |||
| BillOfOperationsMaterial | BillOfOperationsMaterial | |||
| BillOfOperationsType | BillOfOperationsType | |||
| BillOfOperationsGroup | BillOfOperationsGroup | |||
| BillOfOperationsVariant | BillOfOperationsVariant | |||
| BOOInternalVersionCounter | BOOInternalVersionCounter | |||
| BillOfOperationsUsage | BillOfOperationsUsage | |||
| BillOfOperationsVersion | BillOfOperationsVersion | |||
| BOOExplosionDate | BOOExplosionDate | |||
| BOOValidityStartDate | BOOValidityStartDate | |||
| BillOfMaterialCategory | BillOfMaterialCategory | |||
| BillOfMaterialInternalID | BillOfMaterialInternalID | |||
| BillOfMaterialVariant | BillOfMaterialVariant | |||
| BillOfMaterialVariantUsage | BillOfMaterialVariantUsage | |||
| BillOfMaterialVersion | BillOfMaterialVersion | |||
| BOMExplosionDate | BOMExplosionDate | |||
| BOMValidityStartDate | BOMValidityStartDate | |||
| BusinessArea | BusinessArea | |||
| CompanyCode | ||||
| ControllingArea | ControllingArea | |||
| ProfitCenter | ProfitCenter | |||
| CostCenter | CostCenter | |||
| ResponsibleCostCenter | ||||
| CostElement | CostElement | |||
| CostingSheet | CostingSheet | |||
| GLAccount | GLAccount | |||
| ProductCostCollector | ProductCostCollector | |||
| ActualCostsCostingVariant | ActualCostsCostingVariant | |||
| PlannedCostsCostingVariant | PlannedCostsCostingVariant | |||
| ControllingObjectClass | ControllingObjectClass | |||
| FunctionalArea | FunctionalArea | |||
| SchedulingFloatProfile | SchedulingFloatProfile | |||
| FloatBeforeProductionInWrkDays | FloatBeforeProductionInWrkDays | |||
| FloatAfterProductionInWorkDays | FloatAfterProductionInWorkDays | |||
| ReleasePeriodInWorkDays | ReleasePeriodInWorkDays | |||
| OrderPlannedStartDate | MfgOrderPlannedStartDate | |||
| OrderPlannedStartTime | MfgOrderPlannedStartTime | |||
| OrderPlannedEndDate | MfgOrderPlannedEndDate | |||
| OrderPlannedEndTime | MfgOrderPlannedEndTime | |||
| OrderPlannedReleaseDate | MfgOrderPlannedReleaseDate | |||
| OrderScheduledStartDate | MfgOrderScheduledStartDate | |||
| OrderScheduledStartTime | MfgOrderScheduledStartTime | |||
| OrderScheduledEndDate | MfgOrderScheduledEndDate | |||
| OrderScheduledEndTime | MfgOrderScheduledEndTime | |||
| OrderScheduledReleaseDate | MfgOrderScheduledReleaseDate | |||
| OrderActualStartDate | MfgOrderActualStartDate | |||
| OrderActualStartTime | MfgOrderActualStartTime | |||
| OrderActualEndDate | MfgOrderItemActualDeliveryDate | |||
| OrderActualReleaseDate | MfgOrderActualReleaseDate | |||
| OrderConfirmedEndDate | MfgOrderConfirmedEndDate | |||
| OrderConfirmedEndTime | MfgOrderConfirmedEndTime | |||
| TotalCommitmentDate | MfgOrderTotalCommitmentDate | |||
| TechnicalCompletionDate | MfgOrderActualCompletionDate | |||
| ProductionUnit | ProductionUnit | |||
| OrderPlannedTotalQty | MfgOrderPlannedTotalQty | |||
| OrderPlannedScrapQty | MfgOrderPlannedScrapQty | |||
| OrderConfirmedYieldQty | MfgOrderConfirmedYieldQty | |||
| OrderConfirmedScrapQty | MfgOrderConfirmedScrapQty | |||
| ExpectedDeviationQuantity | ExpectedDeviationQuantity | |||
| ActualDeliveredQuantity | ActualDeliveredQuantity | |||
| _Operation | _Operation | |||
| _Phase | _Phase | |||
| _Component | _Component |
@AbapCatalog.dataMaintenance: #RESTRICTED
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
@ObjectModel.representativeKey: 'ProcessOrder'
@ObjectModel.sapObjectNodeType.name: 'ProcessOrder'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Process Order Header - TP'
// ************************ DO NOT USE ************************
// * This RAP BO is for testing purpose only *
// **************************************************************
define root view entity R_ProcessOrderTP
as select from I_ManufacturingOrder as Header
// BO relations
composition [0..*] of R_ProcessOrderOperationTP as _Operation
composition [0..*] of R_ProcessOrderComponentTP as _Component
association [0..*] to R_ProcessOrderPhaseTP as _Phase on $projection.ProcessOrder = _Phase.ProcessOrder
// Extension
association [1..1] to E_ProcessOrder as _Extension on $projection.ProcessOrder = _Extension.OrderID
{
key cast(ManufacturingOrder as co_bord preserving type) as ProcessOrder,
cast(ManufacturingOrder as manufacturingorder preserving type) as ManufacturingOrder, // kept for compatibility reasons (Events)
// Category and Type
@Consumption.hidden: true
ManufacturingOrderCategory,
cast(ManufacturingOrderType as aufart preserving type) as ProcessOrderType,
// Text
@Semantics.text: true
ManufacturingOrderText as ProcessOrderText,
ManufacturingOrderHasLongText as OrderHasLongText,
LongTextLanguageCode as LongTextLanguage,
// Attributes
ManufacturingOrderImportance as OrderImportance,
IsMarkedForDeletion,
IsCompletelyDelivered,
@Semantics.booleanIndicator
MfgOrderHasMultipleItems as OrderHasMultipleItems,
@Semantics.booleanIndicator
MfgOrderIsPartOfCollvOrder as OrderIsPartOfCollectiveOrder,
@Semantics.booleanIndicator
OrderIsNotCostedAutomatically,
@Semantics.booleanIndicator
OrdIsNotSchedldAutomatically,
// Admin data
@Semantics.systemDate.createdAt: true
CreationDate,
@Semantics.systemTime.createdAt: true
CreationTime,
@Semantics.user.createdBy: true
CreatedByUser,
@Semantics.systemDate.lastChangedAt: true
LastChangeDate,
@Semantics.systemTime.lastChangedAt: true
LastChangeTime,
@Semantics.user.lastChangedBy: true
LastChangedByUser,
// ETag
@Semantics.systemDateTime.lastChangedAt: true
case when LastChangeDate > '00000000' then
cast( dats_tims_to_tstmp( LastChangeDate, LastChangeTime, '', $session.client, 'NULL' ) as timestampl )
when LastChangeDate = '00000000' then
cast( 0 as timestampl )
end as LastChangeDateTime,
// Header Material data
Product,
StorageLocation,
Batch,
@Semantics.text: true
GoodsRecipientName,
@Semantics.text: true
UnloadingPointName,
InventoryUsabilityCode,
MaterialGoodsReceiptDuration,
QuantityDistributionKey,
// Assignments
MfgOrderInternalID as OrderInternalID,
ReferenceOrder,
ProductionPlant,
PlanningPlant,
cast(MRPArea as berid preserving type ) as MRPArea,
MRPController,
ProductionSupervisor,
ProductionSchedulingProfile,
ResponsiblePlannerGroup,
ProductionVersion,
SalesOrder,
SalesOrderItem,
cast( WBSElementInternalID as ps_s4_pspnr preserving type ) as WBSElementInternalID,
Reservation,
SettlementReservation,
PlannedOrder,
CapacityRequirement,
BasicSchedulingType,
ForecastSchedulingType,
ObjectInternalID,
// Assignments BOO
BillOfOperationsMaterial,
BillOfOperationsType,
BillOfOperationsGroup,
BillOfOperationsVariant,
BOOInternalVersionCounter,
BillOfOperationsUsage,
BillOfOperationsVersion,
BOOExplosionDate,
BOOValidityStartDate,
// Assignments BOM
BillOfMaterialCategory,
BillOfMaterialInternalID,
BillOfMaterialVariant,
BillOfMaterialVariantUsage,
BillOfMaterialVersion,
BOMExplosionDate,
BOMValidityStartDate,
// Assignments FI/CO
BusinessArea,
cast(CompanyCode as bukrs preserving type ) as CompanyCode,
ControllingArea,
ProfitCenter,
CostCenter,
cast(ResponsibleCostCenter as pph_kostl preserving type ) as ResponsibleCostCenter,
CostElement,
CostingSheet,
GLAccount,
ProductCostCollector,
ActualCostsCostingVariant,
PlannedCostsCostingVariant,
ControllingObjectClass,
FunctionalArea,
// Scheduling
SchedulingFloatProfile,
FloatBeforeProductionInWrkDays,
FloatAfterProductionInWorkDays,
ReleasePeriodInWorkDays,
// Dates and Times
MfgOrderPlannedStartDate as OrderPlannedStartDate,
MfgOrderPlannedStartTime as OrderPlannedStartTime,
MfgOrderPlannedEndDate as OrderPlannedEndDate,
MfgOrderPlannedEndTime as OrderPlannedEndTime,
MfgOrderPlannedReleaseDate as OrderPlannedReleaseDate,
MfgOrderScheduledStartDate as OrderScheduledStartDate,
MfgOrderScheduledStartTime as OrderScheduledStartTime,
MfgOrderScheduledEndDate as OrderScheduledEndDate,
MfgOrderScheduledEndTime as OrderScheduledEndTime,
MfgOrderScheduledReleaseDate as OrderScheduledReleaseDate,
MfgOrderActualStartDate as OrderActualStartDate,
MfgOrderActualStartTime as OrderActualStartTime,
MfgOrderItemActualDeliveryDate as OrderActualEndDate,
MfgOrderActualReleaseDate as OrderActualReleaseDate,
MfgOrderConfirmedEndDate as OrderConfirmedEndDate,
MfgOrderConfirmedEndTime as OrderConfirmedEndTime,
MfgOrderTotalCommitmentDate as TotalCommitmentDate,
MfgOrderActualCompletionDate as TechnicalCompletionDate,
// Quantities and UoM
ProductionUnit,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
MfgOrderPlannedTotalQty as OrderPlannedTotalQty,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
MfgOrderPlannedScrapQty as OrderPlannedScrapQty,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
MfgOrderConfirmedYieldQty as OrderConfirmedYieldQty,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
MfgOrderConfirmedScrapQty as OrderConfirmedScrapQty,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
ExpectedDeviationQuantity,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
ActualDeliveredQuantity,
// Associations
_Operation,
_Phase,
_Component
}
where
ManufacturingOrderCategory = '40'
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA