I_MstrProjTeamMember

@AbapCatalog.sqlViewName: 'IMPTMMEM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Master Project Team Member'
define view I_MstrProjTeamMember  as select distinct 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
    inner join            I_BusinessPartner           as BPartner     on ProjMembers.BusinessPartner = BPartner.BusinessPartner

  association [0..1] to I_MstrProjRoleID as _ProjectRole on $projection.MasterProjectTeamRole = _ProjectRole.ProjectRole
//  association [1..1] to I_EmployeeWorkplaceAddress as _Employee on $projection.BusinessPartner = _Employee.EmployeeInternalID         //HRDecoupling

  association [1..1] to I_WorkforcePerson as _Employee on $projection.BusinessPartner = _Employee.Person                                //HRDecoupling                                             


{
     
  key Project.MasterProject,
      Project.MasterProjectUUID,
      ProjectRoles.EngagementProjectTeamRole                                      as MasterProjectTeamRole,
      concat_with_space(BPartner.FirstName, BPartner.LastName,1)                  as ProjectResponsiblePerson,
      BPartner.FirstName,
      BPartner.LastName,
     // _Text[1:Language = $session.system_language].ProjectRoleName                as ProjectRoleName,

     BPartner.IndependentAddressID,
//      BPartner._AddressIndependentEmail.EmailAddress,

//      case when BPartner._AddressIndependentMobile.PhoneNumberType = '3'

//      then

//      BPartner._AddressIndependentMobile.InternationalMobilePhoneNumber

//      end as InternationalMobilePhoneNumber,

//      case when BPartner._AddressIndependentPhone.PhoneNumberType = '1'

//      then

//      BPartner._AddressIndependentPhone.InternationalPhoneNumber

//      end as InternationalPhoneNumber,

      Project.StartDate,
      Project.EndDate,
      TeamMembers.EngmtProjTeamMemberUUID                                         as MstrProjTeamMemberUUID,
      TeamMembers.EngagementProjectMemberUUID                                     as MstrProjMemberUUID,
      ProjMembers.BusinessPartner,
      ProjMembers.BusinessPartnerType,
      ProjMembers.EmploymentInternalID,
      ProjMembers.EmployeePersonnelNumber,
      ProjMembers.CreationDate,
      ProjMembers.ChangedBy,
      ProjMembers.ChangedDateTime,
      ProjMembers.CreatedByUser,
      _Employee._BusinessUser.UserID,
      _ProjectRole._Text,
      _ProjectRole.ProjectRole,
      BPartner.IsBusinessPurposeCompleted,
      
  /////// Start of Datacontroller 10+1 fields -  Not to be consumed by any other views//////////      

        
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      BPartner.DataController10      


}

 
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_BUSINESSUSER",
"I_ENGAGEMENTPROJECTTEAM",
"I_ENGAGEMENTPROJECTTEAMROLE",
"I_ENGMTPROJTEAMMEMBER",
"I_MASTERPROJECT",
"I_MSTRPROJMEMBER",
"I_MSTRPROJROLEID",
"I_WORKFORCEPERSON"
],
"ASSOCIATED":
[
"I_MASTERPROJECTROLETEXT",
"I_MSTRPROJROLEID",
"I_WORKFORCEPERSON"
],
"BASE":
[
"I_MSTRPROJROLEID"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/