I_MstrProjTeamRespy

@AbapCatalog.sqlViewName: 'IMPTEAMRESP'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking:#REQUIRED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Project Team Responsibility'
define view I_MstrProjTeamRespy
    as select from I_MstrProjTeamMbrRespy as MPRespy
    inner join I_MstrProjTeamMember as MPTeamMember on MPRespy.MasterProjectUUID = MPTeamMember.MasterProjectUUID  and MPRespy.MstrProjTeamMemberUUID = MPTeamMember.MstrProjTeamMemberUUID                                                                
    inner join I_WBSElement as _WBSElementDetails on MPRespy.ControllingObject = _WBSElementDetails.WBSElementObject and _WBSElementDetails.WBSElement <> ''
    association [0..1] to I_MstrProjRoleID as _ProjectRole on $projection.ProjectRole = _ProjectRole.ProjectRole 
 //->NOTE:2921621   association [0..1] to I_Employee as _Employee on $projection.BusinessPartnerUUID = _Employee.EmployeeInternalID

  association [0..1] to I_WorkforcePerson as _Employee on $projection.BusinessPartnerUUID = _Employee.Person   //<-NOTE:2921621

    {

  key MPRespy.MasterProjectUUID,
  key MPRespy.MstrProjTeamMemberUUID,
  key MPRespy.ControllingObject,
  key MPTeamMember.BusinessPartner as BusinessPartnerUUID,
  key MPTeamMember.MasterProjectTeamRole as ProjectRole ,
  key MPTeamMember.EmployeePersonnelNumber as PersonnelNumber,
  _WBSElementDetails.WBSElement  as WBSElementExternalID ,
  _WBSElementDetails.WBSElementObject,
  _ProjectRole._Text[1:Language = $session.system_language].ProjectRoleName as RoleText,
  MPTeamMember.ProjectResponsiblePerson as Name,
  MPTeamMember.FirstName,
  MPTeamMember.LastName,
  MPTeamMember.UserID,
  MPTeamMember.CreationDate,
  MPTeamMember.ChangedDateTime,
  MPTeamMember.ChangedBy,
  MPTeamMember.CreatedByUser,
  _ProjectRole,
  _Employee,
  _MasterProject
}
where _Employee.IsBusinessPurposeCompleted <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MASTERPROJECTROLETEXT",
"I_MSTRPROJROLEID",
"I_MSTRPROJTEAMMBRRESPY",
"I_MSTRPROJTEAMMEMBER",
"I_WBSELEMENT",
"I_WORKFORCEPERSON"
],
"ASSOCIATED":
[
"I_MASTERPROJECT",
"I_MSTRPROJROLEID",
"I_WORKFORCEPERSON"
],
"BASE":
[
"I_MSTRPROJTEAMMBRRESPY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/