R_ProcessOrderTP

DDL: R_PROCESSORDERTP Type: view_entity TRANSACTIONAL Package: PP_PROCESSORDER_RAP

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 122 fields with key field ProcessOrder. It has 10 associations to related views. Part of development package PP_PROCESSORDER_RAP.

Data Sources (1)

SourceAliasJoin Type
I_ManufacturingOrder Header from

Associations (10)

CardinalityTargetAliasCondition
[0..*] R_ProcessOrderPhaseTP _Phase $projection.ProcessOrder = _Phase.ProcessOrder
[0..*] R_ProcOrderItemSerialNumberTP _SerialNumber _SerialNumber.ProcessOrder = $projection.ProcessOrder
[0..*] R_EventBasedOrderPostingRuleTP _PostingRule _PostingRule.OrderID = $projection.ProcessOrder and _PostingRule.OrderItem = '0000'
[0..1] R_VariantConfigurationTP _VariantConfiguration $projection.VarConfigurationBusObjectType = _VariantConfiguration.VarConfigurationBusObjectType and $projection.VarConfigurationBusObjectKey = _VariantConfiguration.VarConfigurationBusObjectKey
[0..*] R_ProcOrdOperationCapacityTP _OrderOperationCapacity _OrderOperationCapacity.CapacityRequirement = $projection.CapacityRequirement
[0..*] R_ProcessOrderPhaseCapacityTP _OrderPhaseCapacity _OrderPhaseCapacity.CapacityRequirement = $projection.CapacityRequirement
[1..1] E_ProcessOrder _Extension $projection.ProcessOrder = _Extension.OrderID
[1..*] R_ProcessOrderItemTP _Item
[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 (122)

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
SchedulingIsAllowingForBreaks SchedulingIsAllowingForBreaks
ObjectInternalID ObjectInternalID
CapacityRqmtHasNotToBeCreated CapacityRqmtHasNotToBeCreated
MasterRecipeProduct BillOfOperationsMaterial
BillOfOperationsType BillOfOperationsType
MasterRecipeGroup BillOfOperationsGroup
MasterRecipe BillOfOperationsVariant
MasterRecipeInternalVersion BOOInternalVersionCounter
MasterRecipeUsage BillOfOperationsUsage
MasterRecipeExplosionDate BOOExplosionDate
MasterRecipeValidityStartDate 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
OverheadCode OverheadCode
ResultAnalysisInternalID ResultAnalysisInternalID
VarianceKey VarianceKey
EventBasedProcessingKey EventBasedProcessingKey
EventBasedPostingMethod EventBasedPostingMethod
OrderSettlementTriggerType OrderSettlementTriggerType
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
_Item _Item
_SerialNumber _SerialNumber
_Operation _Operation
_Phase _Phase
_Component _Component
_PostingRule _PostingRule
_VariantConfiguration _VariantConfiguration
_OrderOperationCapacity _OrderOperationCapacity
_OrderPhaseCapacity _OrderPhaseCapacity
@AbapCatalog.dataMaintenance: #RESTRICTED
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: [ '_PostingRule' ]
@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 [1..*] of R_ProcessOrderItemTP           as _Item
  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
  association [0..*] to R_ProcOrderItemSerialNumberTP  as _SerialNumber           on  _SerialNumber.ProcessOrder = $projection.ProcessOrder

  association [0..*] to R_EventBasedOrderPostingRuleTP as _PostingRule            on  _PostingRule.OrderID   = $projection.ProcessOrder
                                                                                  and _PostingRule.OrderItem = '0000'
  association [0..1] to R_VariantConfigurationTP       as _VariantConfiguration   on  $projection.VarConfigurationBusObjectType = _VariantConfiguration.VarConfigurationBusObjectType
                                                                                  and $projection.VarConfigurationBusObjectKey  = _VariantConfiguration.VarConfigurationBusObjectKey
  association [0..*] to R_ProcOrdOperationCapacityTP   as _OrderOperationCapacity on  _OrderOperationCapacity.CapacityRequirement = $projection.CapacityRequirement
  association [0..*] to R_ProcessOrderPhaseCapacityTP  as _OrderPhaseCapacity     on  _OrderPhaseCapacity.CapacityRequirement = $projection.CapacityRequirement

  // 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,
      SchedulingIsAllowingForBreaks,
      ObjectInternalID,
      CapacityRqmtHasNotToBeCreated,

      // Variant Configuration

      case when ProductConfiguration is not initial
        then
          cast ('ProcessOrder' as sbo_node_type)
        else
          null
      end                                                            as VarConfigurationBusObjectType,
      case when ProductConfiguration is not initial
        then
          cast ( ManufacturingOrder as ibobjkey )
        else
          null
      end                                                            as VarConfigurationBusObjectKey,

      // Assignments BOO

      BillOfOperationsMaterial                                       as MasterRecipeProduct,
      BillOfOperationsType,
      BillOfOperationsGroup                                          as MasterRecipeGroup,
      BillOfOperationsVariant                                        as MasterRecipe,
      BOOInternalVersionCounter                                      as MasterRecipeInternalVersion,
      BillOfOperationsUsage                                          as MasterRecipeUsage,
      //      BillOfOperationsVersion,  // only supported in shopfloor routings - PEO

      BOOExplosionDate                                               as MasterRecipeExplosionDate,
      BOOValidityStartDate                                           as MasterRecipeValidityStartDate,

      // 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,
      OverheadCode,
      ResultAnalysisInternalID,
      VarianceKey,
      EventBasedProcessingKey,
      EventBasedPostingMethod,
      OrderSettlementTriggerType,

      // 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

      _Item,
      _SerialNumber,
      _Operation,
      _Phase,
      _Component,
      _PostingRule,
      _VariantConfiguration,
      _OrderOperationCapacity,
      _OrderPhaseCapacity
}
where
  ManufacturingOrderCategory = '40'