I_PPM_TASKRELATIONSHIP

CDS View

Provide relationships between tasks

I_PPM_TASKRELATIONSHIP is a CDS View in S/4HANA. Provide relationships between tasks. It contains 2 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 2 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_PPM_TaskPredecessor view from CONSUMPTION Task Predecessor
C_PPM_TaskSuccessor view from CONSUMPTION Task Successor
P_PPM_SuccessorTskReadyToStart view from COMPOSITE
P_PPM_SuccessorTskReadyToStart view union_all COMPOSITE

Fields (2)

KeyField CDS FieldsUsed in Views
KEY PredecessorTaskUUID PredecessorTaskUUID,ReferencedObjectUUID 2
KEY SuccessorTaskUUID SuccessorTaskUUID,TaskUUIDRaw 2 
@EndUserText.label: 'Provide relationships between tasks'
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IPPMTASKREL'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

@ObjectModel.usageType.serviceQuality: 'B'
@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.dataClass: 'MASTER'
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

define view I_PPM_TaskRelationship
  as select from P_PPM_TaskRelationship
  left outer to one join I_EPPMGlobalSetting as _GlobalSetting on _GlobalSetting.EPPMUsageArea = '0007' and _GlobalSetting.EPPMGlobalSettingsCode = '0053'
  association [1..1] to I_PPM_Task as _PredecessorTask on $projection.PredecessorTaskUUID = _PredecessorTask.TaskUUID
  association [1..1] to I_PPM_Task as _SuccessorTask   on $projection.SuccessorTaskUUID = _SuccessorTask.TaskUUID

{
  key TaskRelationshipUUID,
      @ObjectModel.foreignKey.association: '_PredecessorTask'
      hextobin(PredecessorTaskUUID) as PredecessorTaskUUID,
      @ObjectModel.foreignKey.association: '_SuccessorTask'
      hextobin(SuccessorTaskUUID)   as SuccessorTaskUUID,
      TaskRelationshipType,
      _GlobalSetting.EPPMSettingsDefaultValue,
      _PredecessorTask,
      _SuccessorTask

}

Learn More