R_ProductionOrderTP
Production Order Header - TP
R_ProductionOrderTP is a Transactional CDS View that provides data about "Production Order Header - TP" in SAP S/4HANA. It reads from 1 data source (I_ManufacturingOrder) and exposes 126 fields with key field ProductionOrder. 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_ProductionOrderOperationTP | _Operation | _Operation.ProductionOrder = $projection.ProductionOrder and _Operation.ProductionOrderSequence = '000000' |
| [1..1] | E_ProductionOrder | _Extension | $projection.ProductionOrder = _Extension.ProductionOrder |
| [0..*] | R_ProductionOrderSequenceTP | _Sequence | |
| [0..*] | R_ProductionOrderOpComponentTP | _Component | |
Annotations (15)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.dataMaintenance | #RESTRICTED | view | |
| AccessControl.authorizationCheck | #MANDATORY | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| Metadata.allowExtensions | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.modelingPattern | #NONE | view | |
| ObjectModel.sapObjectNodeType.name | ProductionOrder | view | |
| ObjectModel.representativeKey | ProductionOrder | view | |
| Analytics.technicalName | RPRODNORDTP | 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 | Production Order Header - TP | view |
Fields (126)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ProductionOrder | |||
| ManufacturingOrder | ||||
| ManufacturingOrderCategory | ManufacturingOrderCategory | |||
| ProductionOrderType | ||||
| ProductionOrderText | ManufacturingOrderText | |||
| OrderHasLongText | ManufacturingOrderHasLongText | |||
| LongTextLanguageCode | LongTextLanguageCode | |||
| OrderImportance | ManufacturingOrderImportance | |||
| IsMarkedForDeletion | IsMarkedForDeletion | |||
| IsCompletelyDelivered | IsCompletelyDelivered | |||
| OrderHasMultipleItems | MfgOrderHasMultipleItems | |||
| OrderIsPartOfCollectiveOrder | MfgOrderIsPartOfCollvOrder | |||
| OrderHierarchyLevelValue | MfgOrderHierarchyLevel | |||
| OrderIsNotCostedAutomatically | OrderIsNotCostedAutomatically | |||
| OrdIsNotSchedldAutomatically | OrdIsNotSchedldAutomatically | |||
| ProdnProcgIsFlexible | ProdnProcgIsFlexible | |||
| 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 | |||
| StockSegment | StockSegment | |||
| OrderInternalID | MfgOrderInternalID | |||
| ReferenceOrder | ReferenceOrder | |||
| LeadingOrder | LeadingOrder | |||
| SuperiorOrder | SuperiorOrder | |||
| Currency | Currency | |||
| ProductionPlant | ProductionPlant | |||
| PlanningPlant | PlanningPlant | |||
| MRPArea | ||||
| MRPController | MRPController | |||
| ProductionSupervisor | ProductionSupervisor | |||
| ProductionSchedulingProfile | ProductionSchedulingProfile | |||
| ResponsiblePlannerGroup | ResponsiblePlannerGroup | |||
| ProductionVersion | ProductionVersion | |||
| SalesOrder | SalesOrder | |||
| SalesOrderItem | SalesOrderItem | |||
| WBSElementInternalID | ||||
| Reservation | Reservation | |||
| SettlementReservation | SettlementReservation | |||
| OrderConfirmationGroup | MfgOrderConfirmation | |||
| NumberOfOrderConfirmations | NumberOfMfgOrderConfirmations | |||
| PlannedOrder | PlannedOrder | |||
| CapacityRequirement | CapacityRequirement | |||
| InspectionLot | InspectionLot | |||
| ChangeNumber | ChangeNumber | |||
| BasicSchedulingType | BasicSchedulingType | |||
| ObjectInternalID | ObjectInternalID | |||
| ProductConfiguration | ProductConfiguration | |||
| EffectivityParameterVariant | EffectivityParameterVariant | |||
| ConditionApplication | ConditionApplication | |||
| CapacityActiveVersion | CapacityActiveVersion | |||
| CapacityRqmtHasNotToBeCreated | CapacityRqmtHasNotToBeCreated | |||
| OrderSequenceNumber | OrderSequenceNumber | |||
| BillOfOperationsMaterial | BillOfOperationsMaterial | |||
| BillOfOperationsType | BillOfOperationsType | |||
| BillOfOperationsGroup | BillOfOperationsGroup | |||
| BillOfOperationsVariant | BillOfOperationsVariant | |||
| BOOInternalVersionCounter | BOOInternalVersionCounter | |||
| BillOfOperationsUsage | BillOfOperationsUsage | |||
| BillOfOperationsVersion | BillOfOperationsVersion | |||
| BOOExplosionDate | BOOExplosionDate | |||
| BOOValidityStartDate | BOOValidityStartDate | |||
| BillOfMaterialCategory | BillOfMaterialCategory | |||
| BillOfMaterial | ||||
| 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 | |||
| PlannedReleaseDate | 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 | |||
| OrderConfirmedReworkQty | MfgOrderConfirmedReworkQty | |||
| ExpectedDeviationQuantity | ExpectedDeviationQuantity | |||
| ActualDeliveredQuantity | ActualDeliveredQuantity | |||
| _Sequence | _Sequence | |||
| _Component | _Component | |||
| _Operation | _Operation |
@AbapCatalog.dataMaintenance: #RESTRICTED
//@AbapCatalog.extensibility: {
// extensible: true,
// dataSources: ['_Extension'],
// elementSuffix: 'ORD',
// quota: {
// maximumFields: 204, // calculated with formula for FINS_ORDER - 2* <Customer Percentage from SCFD_REGISTRY> * <max number of fields in SCFD_REGISTRY>
// maximumBytes: 2040 // calculated with formula for FINS_ORDER - 2* <Customer Percentage from SCFD_REGISTRY> * <number of chars as defined in SCFD_REGISTRY>
// }
//}
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations: true // ====> Ist erben OK ??
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
@ObjectModel.sapObjectNodeType.name: 'ProductionOrder'
@ObjectModel.representativeKey: 'ProductionOrder'
@Analytics.technicalName: 'RPRODNORDTP'
@ObjectModel.semanticKey: [ 'ProductionOrder']
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL // Still necessary???
@EndUserText.label: 'Production Order Header - TP'
//
// ************************ DO NOT USE ************************
// * This RAP BO is for testing purpose only *
// **************************************************************
define root view entity R_ProductionOrderTP
as select from I_ManufacturingOrder as Header
// BO relations
composition [0..*] of R_ProductionOrderSequenceTP as _Sequence
composition [0..*] of R_ProductionOrderOpComponentTP as _Component
association [0..*] to R_ProductionOrderOperationTP as _Operation on _Operation.ProductionOrder = $projection.ProductionOrder
and _Operation.ProductionOrderSequence = '000000'
// extension association
association [1..1] to E_ProductionOrder as _Extension on $projection.ProductionOrder = _Extension.ProductionOrder
{
key cast(ManufacturingOrder as vdm_manufacturingorder preserving type) as ProductionOrder,
cast(ManufacturingOrder as manufacturingorder preserving type) as ManufacturingOrder, // still needed for business event
// Category and Type
ManufacturingOrderCategory,
cast(ManufacturingOrderType as aufart preserving type ) as ProductionOrderType,
// Text
@Semantics.text: true
ManufacturingOrderText as ProductionOrderText,
ManufacturingOrderHasLongText as OrderHasLongText,
LongTextLanguageCode,
// Attributes
ManufacturingOrderImportance as OrderImportance,
IsMarkedForDeletion,
IsCompletelyDelivered,
@Semantics.booleanIndicator
MfgOrderHasMultipleItems as OrderHasMultipleItems,
@Semantics.booleanIndicator
MfgOrderIsPartOfCollvOrder as OrderIsPartOfCollectiveOrder,
MfgOrderHierarchyLevel as OrderHierarchyLevelValue,
@Semantics.booleanIndicator
OrderIsNotCostedAutomatically,
@Semantics.booleanIndicator
OrdIsNotSchedldAutomatically,
ProdnProcgIsFlexible,
// OrderIsEventBasedPosting, Invalid name as this is a code => Replace when new name is available
// 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,
StockSegment,
// Assignments
MfgOrderInternalID as OrderInternalID,
ReferenceOrder,
LeadingOrder,
SuperiorOrder,
Currency,
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,
MfgOrderConfirmation as OrderConfirmationGroup,
NumberOfMfgOrderConfirmations as NumberOfOrderConfirmations,
PlannedOrder,
CapacityRequirement,
InspectionLot,
ChangeNumber,
BasicSchedulingType,
ForecastSchedulingType,
ObjectInternalID,
ProductConfiguration,
EffectivityParameterVariant,
ConditionApplication,
CapacityActiveVersion,
CapacityRqmtHasNotToBeCreated,
OrderSequenceNumber,
// Assignments BOO
BillOfOperationsMaterial,
BillOfOperationsType,
BillOfOperationsGroup,
BillOfOperationsVariant,
BOOInternalVersionCounter,
BillOfOperationsUsage,
BillOfOperationsVersion,
BOOExplosionDate,
BOOValidityStartDate,
// Assignments BOM
BillOfMaterialCategory,
cast(BillOfMaterial as pph_stnum preserving type ) as BillOfMaterial,
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 PlannedReleaseDate,
MfgOrderScheduledStartDate as OrderScheduledStartDate,
MfgOrderScheduledStartTime as OrderScheduledStartTime,
MfgOrderScheduledEndDate as OrderScheduledEndDate,
MfgOrderScheduledEndTime as OrderScheduledEndTime,
MfgOrderScheduledReleaseDate as OrderScheduledReleaseDate,
MfgOrderActualStartDate as OrderActualStartDate,
MfgOrderActualStartTime as OrderActualStartTime,
// as mapped in CO03 (MfgOrderItemActualDeliveryDate is not directly visible there)
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'
MfgOrderConfirmedReworkQty as OrderConfirmedReworkQty,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
ExpectedDeviationQuantity,
@Semantics.quantity.unitOfMeasure: 'ProductionUnit'
ActualDeliveredQuantity,
// Associations
_Sequence,
_Component,
_Operation
}
where
ManufacturingOrderCategory = '10'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MANUFACTURINGORDER"
],
"ASSOCIATED":
[
"R_PRODUCTIONORDEROPCOMPONENTTP",
"R_PRODUCTIONORDEROPERATIONTP",
"R_PRODUCTIONORDERSEQUENCETP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/
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