I_PROJECTMGRORGDET

CDS View

Retrieve project details for the session user

I_PROJECTMGRORGDET is a CDS View in S/4HANA. Retrieve project details for the session user. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PMPROJSUPPLYDATA view from COMPOSITE
P_PMPROJSUPPLYDATAKPI view from COMPOSITE 
@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

Learn More