I_MasterProjectRole

@AbapCatalog.sqlViewName: 'IMSTRPROJROLE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Project Role'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
@AccessControl.personalData.blocking: #REQUIRED
define view I_MasterProjectRole
  as select from    I_MasterProject             as Project

    inner join      I_EngagementProjectTeam     as ProjectTeam  on Project.MasterProjectUUID = ProjectTeam.EngagementProjectUUID

    left outer join I_EngagementProjectTeamRole as ProjectRoles on ProjectTeam.EngagementProjectTeamUUID = ProjectRoles.EngagementProjectTeamUUID
    left outer join I_EngmtProjTeamMember       as TeamMembers  on ProjectRoles.EngagementProjectTeamRoleUUID = TeamMembers.EngagementProjectTeamRoleUUID
    left outer join I_MstrProjMember            as ProjMembers  on TeamMembers.EngagementProjectMemberUUID = ProjMembers.MstrProjMemberUUID

 association [0..1] to I_DistinctEmployee      as _Employment on $projection.EmploymentInternalID = _Employment.EmploymentInternalID

  //                                                 and $projection.StartDate     >= _Employment.StartDate

  //                                                 and $projection.EndDate       <= _Employment.EndDate

  association [1..1] to I_MstrProjRoleID as _ProjectRole       on $projection.ProjectRole = _ProjectRole.ProjectRole
  association [1..1] to I_User                  as _User       on $projection.BusinessUser = _User.UserID
{

  key Project.MasterProject,
      //  @ObjectModel.text.association: '_Text'

      @Search.defaultSearchElement: true
  key ProjectRoles.EngagementProjectTeamRole                                            as ProjectRole,
      Project.StartDate                                                                 as StartDate,
      Project.EndDate                                                                   as EndDate,
      // @ObjectModel.foreignKey.association: '_User'

      @Semantics.user.id: true
//    _Employment._Employee.BusinessUser                                                as BusinessUser,            NOTE:2921621

      _Employment.BusinessUser                                                          as BusinessUser,            //NOTE:2921621

      Project.MasterProjectUUID                                                         as ProjectUUID,
      ProjectTeam.EngagementProjectTeamUUID,
      ProjectRoles.EngagementProjectTeamRoleUUID                                        as ProjectRoleUUID,
      TeamMembers.EngmtProjTeamMemberUUID                                               as MstrProjTeamMemberUUID,
      TeamMembers.EngagementProjectMemberUUID                                           as MstrProjMemberUUID,
      @ObjectModel.text.element: 'EmployeeFullName'
      ProjMembers.BusinessPartner                                                       as EmploymentInternalID,
//      _Employment.PersonnelNumber                                                       as PersonnelNumber,       NOTE:2921621 *removing PersonnelNumber without replacement              

      ProjMembers.BusinessPartnerType                                                   as BusinessPartnerType,
      @Semantics.name.fullName: true
//      _Employment._Employee.EmployeeFullName                                            as EmployeeFullName,      NOTE:2921621

      _Employment.EmployeeFullName                                                      as EmployeeFullName,        //NOTE:2921621

      Project.MasterProjectType,
      Project.MasterProjectOrganization,
      Project.MasterProjectIsConfidential,
      //associations

      _ProjectRole,
      _Employment,
//      _Employment._Employee,                                                                   NOTE:2921621

      _Employment.Person,                                                                        //NOTE:2921621

      _Employment._WorkforcePerson,                                                              //NOTE:2921621

      _User

}