I_PPM_PROJECTROLE

CDS View

Project Role

I_PPM_PROJECTROLE is a CDS View in S/4HANA. Project Role. It contains 13 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 13 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_PPM_ProjectRoleText view from COMPOSITE Project Role Text
I_PPM_ProjectRoleTP view from TRANSACTIONAL Project Roles Transactional Object View
I_PPM_TeamMemberRoleStaffing view from COMPOSITE Team Member Role Staffing
P_PPM_TaskRelatedSeverity view left_outer COMPOSITE

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ProjectRoleUUID ProjectRoleUUID 3
_AuthGroup _AuthGroup 1
_AuthRole _AuthRole 1
_AuthSubst _AuthSubst 1
_AuthUser _AuthUser 1
_I_Project _I_Project 1
_ProjObj _ProjObj 1
ProjectInternalID ProjectInternalID 1
ProjectRole ProjectRole 1
ProjectRoleType ProjectRoleType 2
ProjectSummaryTaskUUID ProjectSummaryTaskUUID 3
ProjectUUID ProjectUUID 1
WBSElementInternalID WBSElementInternalID 1 
@EndUserText.label: 'Project Role'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED

@AbapCatalog: { 
    sqlViewName: 'IPPMPROROLE',
    compiler.compareFilter: true,
    preserveKey:true
}

@ObjectModel: {
     representativeKey: 'ProjectRoleUUID',
     usageType: {
     serviceQuality:  #D,
     dataClass:       #MIXED,
     sizeCategory:    #S
    }
}

@VDM.viewType: #BASIC

@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API 

define view I_PPM_ProjectRole
    as select from   dpr_part      as role 
    left outer join  cgpl_hierarchy                      as hier on hier.guid = role.guid
    left outer join  I_PPM_Task                          as pst on pst.TaskUUID = hier.up
    association [1..1] to I_PPM_ProjectRoleText          as _ProjectRoleText           on $projection.ProjectRoleUUID = _ProjectRoleText.ProjectRoleUUID     
    association [1..*] to I_PPM_ProjectRoleTypeText      as _ProjectRoleTypeText       on $projection.ProjectRoleType = _ProjectRoleTypeText. ProjectRoleType 
    association [1..1] to I_PPM_ProjectRoleType          as _ProjectRoleType           on $projection.ProjectRoleType = _ProjectRoleType.ProjectRoleType 
  {
  @ObjectModel.text.association: '_ProjectRoleText'
  key cast( role.guid as /s4ppm/tv_entity_guid )              as ProjectRoleUUID,
     role.participant_role   as ProjectRoleType,
      'MTG'                  as ObjectType,
      // hier.up             as TaskUUID,

      pst.TaskUUID                      as ProjectSummaryTaskUUID,
      pst.ProjectUUID,
      role.participant_id          as ProjectRole,
      _ProjectRoleText,
      _ProjectRoleTypeText,
      _ProjectRoleType,
 //Authorization check relevant data     

      ProjectInternalID,
      WBSElementInternalID,
      pst._I_Project,
      pst._I_Project.ProjectProfileCode as ProjectProfileCode, 
      pst._I_Project.FunctionalArea     as FunctionalArea,
      pst._I_Project.CompanyCode        as CompanyCode,
      pst._ProjObj,
      pst._AuthUser,
      pst._AuthSubst,
      pst._AuthRole,
      pst._AuthGroup 
}
where
  role.concrete_role = '' 
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_TASK",
"I_PROJECTBASICDATA",
"CGPL_HIERARCHY",
"DPR_PART"
],
"ASSOCIATED":
[
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH",
"I_PPM_PROJECTROLETEXT",
"I_PPM_PROJECTROLETYPE",
"I_PPM_PROJECTROLETYPETEXT",
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_PPM_TASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More