R_ProcessOrderTP

DDL: R_PROCESSORDERTP Type: view_entity TRANSACTIONAL

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)

SourceAliasJoin Type
I_ManufacturingOrder Header from

Associations (4)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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'