C_PPM_MPPTaskRelationship

DDL: C_PPM_MPPTASKRELATIONSHIP SQL: CPPMTASKRELATION Type: view CONSUMPTION

Relationship in Monitor Project Progress

C_PPM_MPPTaskRelationship is a Consumption CDS View that provides data about "Relationship in Monitor Project Progress" in SAP S/4HANA. It reads from 1 data source (I_PPM_Task) and exposes 9 fields with key fields PredecessorTaskUUID, SuccessorTaskUUID.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_PPM_Task PredecessorTask inner

Annotations (9)

NameValueLevelField
EndUserText.label Relationship in Monitor Project Progress view
AbapCatalog.sqlViewName CPPMTASKRELATION view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality X view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.dataClass MIXED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PredecessorTaskUUID
KEY SuccessorTaskUUID
ProjectUUID
TaskRelationshipType Relationship TaskRelationshipType
TaskUUID I_PPM_Task TaskUUID
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup 
@EndUserText.label: 'Relationship in Monitor Project Progress'
@AbapCatalog.sqlViewName: 'CPPMTASKRELATION'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE            
@ObjectModel.usageType.serviceQuality: 'X'
@ObjectModel.usageType.sizeCategory: 'L'
@ObjectModel.usageType.dataClass: 'MIXED'

//@Search.searchable: true

define view C_PPM_MPPTaskRelationship as 
select distinct 
  from       I_PPM_TaskRelationship      as Relationship
  inner join I_PPM_Task                  as PredecessorTask on PredecessorTask.TaskUUID = Relationship.PredecessorTaskUUID
{
  @Consumption.semanticObject: 'Task Relationship'
  @UI.hidden: true
  key bintohex(Relationship.PredecessorTaskUUID) as PredecessorTaskUUID,
  
  @UI.hidden: true
  key bintohex(Relationship.SuccessorTaskUUID) as SuccessorTaskUUID,
  
  @UI.hidden: true
  bintohex(PredecessorTask.ProjectUUID) as ProjectUUID,
  
  @UI.hidden: true
  Relationship.TaskRelationshipType,


// never expose the following associations, only used for authorization checks

  @UI.hidden: true
  PredecessorTask.TaskUUID  as TaskUUID,
  
  @UI.hidden:true
  _AuthUser,
  @UI.hidden:true
  _AuthSubst,
  @UI.hidden:true
  _AuthRole,
  @UI.hidden:true
  _AuthGroup

}                                                             
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_TASK",
"I_PPM_TASKRELATIONSHIP"
],
"ASSOCIATED":
[
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH"
],
"BASE":
[
"I_PPM_TASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More