I_ProjectMgrOrgDet

@AbapCatalog.sqlViewName: 'IPROJMGRORGDET'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.serviceQuality : #D
@ObjectModel.usageType.sizeCategory : #XL
@ObjectModel.usageType.dataClass : #MASTER
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AccessControl.personalData.blocking: #REQUIRED
// to check if this has to be required or not. Scenario check. In Odata role anyways this would be handled

//@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }

@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Retrieve project details for the session user'
define view I_ProjectMgrOrgDet
  as select distinct from I_EngagementProjectRole as EngagementProjectRole
  inner join I_PersonWorkAgrmtForKeyDate(P_KeyDate : $session.system_date) as PersonWorkAgrmtForKeyDate on EngagementProjectRole.EmploymentInternalID = PersonWorkAgrmtForKeyDate.PersonWorkAgreement
  inner join I_PersonWorkAgreement_1 as PersonWorkAgreement on PersonWorkAgreement.PersonWorkAgreement =  PersonWorkAgrmtForKeyDate.PersonWorkAgreement
  inner join I_WorkforcePerson as WorkforcePerson on WorkforcePerson.Person = PersonWorkAgreement.Person
  left outer join I_User as User on User.BusinessPartnerUUID = WorkforcePerson.BusinessPartnerUUID
{
  //key _PersonWorkAgrmtForKeyDate(P_KeyDate : $session.system_date).

  //_Employment._Employee.PersonnelNumber,

  key EngagementProjectRole.EngagementProjectUUID,
      EngagementProjectRole.EngagementProject,
      EngagementProjectRole._EngagementProject.EngagementProjectName,
      EngagementProjectRole.EmploymentInternalID as ProjectManager
     // _PersonWorkAgrmtForKeyDate(P_KeyDate : $session.system_date).PersonWorkAgreement.

    //  User.UserID as BusinessUser

}

where ( EngagementProjectRole.EngagementProjectTeamRole = 'P001' or EngagementProjectRole.EngagementProjectTeamRole = 'P003' )
and User.UserID = $session.user
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGAGEMENTPROJECT",
"I_ENGAGEMENTPROJECTROLE",
"I_PERSONWORKAGREEMENT_1",
"I_PERSONWORKAGRMTFORKEYDATE",
"I_USER",
"I_WORKFORCEPERSON"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/