R_ProcessOrderPhaseCapacityTP

DDL: R_PROCESSORDERPHASECAPACITYTP Type: view_entity TRANSACTIONAL Package: PP_PROCESSORDER_RAP

Individual Capacity of Process Order Phase - TP

R_ProcessOrderPhaseCapacityTP is a Transactional CDS View that provides data about "Individual Capacity of Process Order Phase - TP" in SAP S/4HANA. It reads from 1 data source (I_ProcOrderOperationCapacity) and exposes 52 fields with key fields CapacityRequirement, CapacityRequirementItem. It has 2 associations to related views. Part of development package PP_PROCESSORDER_RAP.

Data Sources (1)

SourceAliasJoin Type
I_ProcOrderOperationCapacity IndividualCapacity from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_ProcessOrderOperationTP _Operation _Operation.OrderInternalID = $projection.OrderInternalID and _Operation.OrderOperationInternalID = $projection.SuperiorOperationIntIDOfPhase
[1..1] R_ProcessOrderTP _Order $projection.ProcessOrder = _Order.ProcessOrder

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Individual Capacity of Process Order Phase - TP view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY CapacityRequirement CapacityRequirement
KEY CapacityRequirementItem CapacityRequirementItem
ProcessOrder ProcessOrder
OrderInternalID OrderInternalID
OrderPhaseInternalID OrderOperationInternalID
ManufacturingOrderCategory ManufacturingOrderCategory
ProcessOrderType ProcessOrderType
Plant Plant
ProcessOrderPhase ProcessOrderOperation
SuperiorOperationIntIDOfPhase SuperiorOperationIntIDOfPhase
WorkCenterInternalID WorkCenterInternalID
WorkCenterTypeCode WorkCenterTypeCode
CapacityRqmtConfirmation CapacityRqmtConfirmation
CapacityInternalID CapacityInternalID
CapacityRequirementDistrKey CapacityRequirementDistrKey
SuperiorOperationInternalID SuperiorOperationInternalID
CapacityRequirementUnit CapacityRequirementUnit
ScheduledCapReqOpSegProcgDurn ScheduledCapReqOpSegProcgDurn
RemainingCapReqOpSegProcgDurn RemainingCapReqOpSegProcgDurn
OperationEarliestStartDate OperationEarliestStartDate
OperationEarliestStartTime OperationEarliestStartTime
OperationEarliestEndDate OperationEarliestEndDate
OperationEarliestEndTime OperationEarliestEndTime
OperationLatestStartDate OperationLatestStartDate
OperationLatestStartTime OperationLatestStartTime
OperationLatestEndDate OperationLatestEndDate
OperationLatestEndTime OperationLatestEndTime
ActualStartDate ActualStartDate
ActualStartTime ActualStartTime
ActualEndDate ActualEndDate
ActualEndTime ActualEndTime
ErlstSchedldProcStrtDte ErlstSchedldProcStrtDte
ErlstSchedldProcStrtTime ErlstSchedldProcStrtTime
ErlstSchedldTrdwnStrtDte ErlstSchedldTrdwnStrtDte
ErlstSchedldTrdwnStrtTime ErlstSchedldTrdwnStrtTime
LtstSchedldProcStrtDte LtstSchedldProcStrtDte
LtstSchedldProcStrtTime LtstSchedldProcStrtTime
LtstSchedldTrdwnStrtDte LtstSchedldTrdwnStrtDte
LtstSchedldTrdwnStrtTime LtstSchedldTrdwnStrtTime
_OrderInternalID _OrderInternalID
_ProcessOrderType _ProcessOrderType
_ProcessOrderOperation _ProcessOrderOperation
_Plant _Plant
_WorkCenter _WorkCenter
_CapacityRequirement _CapacityRequirement
_CapacityRequirementItem _CapacityRequirementItem
_CapacityRequirementConf _CapacityRequirementConf
_Capacity _Capacity
_UnitOfMeasure _UnitOfMeasure
_Order _Order
_Operation _Operation
_Phase _Phase
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Individual Capacity of Process Order Phase - TP'

define view entity R_ProcessOrderPhaseCapacityTP
  as select from I_ProcOrderOperationCapacity as IndividualCapacity

  // BO relation

  association        to parent R_ProcessOrderPhaseTP as _Phase     on  $projection.OrderInternalID      = _Phase.OrderInternalID
                                                                   and $projection.OrderPhaseInternalID = _Phase.OrderPhaseInternalID

  association [1..1] to R_ProcessOrderOperationTP    as _Operation on  _Operation.OrderInternalID          = $projection.OrderInternalID
                                                                   and _Operation.OrderOperationInternalID = $projection.SuperiorOperationIntIDOfPhase

  association [1..1] to R_ProcessOrderTP             as _Order     on  $projection.ProcessOrder = _Order.ProcessOrder

{
      // Key

  key CapacityRequirement,
  key CapacityRequirementItem,
      -- representative key
  key CapacityRqmtItemCapacity,

      // Order Data

      ProcessOrder,
      OrderInternalID,
      OrderOperationInternalID as OrderPhaseInternalID,
      @Consumption.hidden: true
      ManufacturingOrderCategory,
      ProcessOrderType,
      Plant,
      ProcessOrderOperation    as ProcessOrderPhase,
      SuperiorOperationIntIDOfPhase,
      WorkCenterInternalID,
      WorkCenterTypeCode,

      // Assignments

      CapacityRqmtConfirmation,
      CapacityInternalID,
      CapacityRequirementDistrKey,
      SuperiorOperationInternalID,

      // Only processing duration in process order phase / No Capacity split

      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      CapacityRequirementUnit,
      ScheduledCapReqOpSegProcgDurn,
      RemainingCapReqOpSegProcgDurn,

      // Dates and Times

      OperationEarliestStartDate,
      OperationEarliestStartTime,
      OperationEarliestEndDate,
      OperationEarliestEndTime,
      OperationLatestStartDate,
      OperationLatestStartTime,
      OperationLatestEndDate,
      OperationLatestEndTime,
      ActualStartDate,
      ActualStartTime,
      ActualEndDate,
      ActualEndTime,

      // Time Events

      ErlstSchedldProcStrtDte,
      ErlstSchedldProcStrtTime,
      ErlstSchedldTrdwnStrtDte,
      ErlstSchedldTrdwnStrtTime,
      LtstSchedldProcStrtDte,
      LtstSchedldProcStrtTime,
      LtstSchedldTrdwnStrtDte,
      LtstSchedldTrdwnStrtTime,

      // Order Data

      _OrderInternalID,
      _ProcessOrderType,
      _ProcessOrderOperation,
      _Plant,
      _WorkCenter,

      // Associations

      _CapacityRequirement,
      _CapacityRequirementItem,
      _CapacityRequirementConf,
      _Capacity,
      _UnitOfMeasure,

      // BO relation

      _Order,
      _Operation,
      _Phase

}
where
  OperationIsPhase is not initial