I_PPM_ProjectRole

@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":""
}
}*/