I_MSTRPROJUSRAUTHLIST

CDS View

Authorized List of Master Project for logged in User

I_MSTRPROJUSRAUTHLIST is a CDS View in S/4HANA. Authorized List of Master Project for logged in User. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MasterProjectItemList view inner COMPOSITE Master Project Item List
I_MasterProjectVH view from COMPOSITE Master Project Value Help

Fields (5)

KeyField CDS FieldsUsed in Views
MasterProject MasterProject 1
MasterProjectType MasterProjectType 2
MasterProjectUUID MasterProjectUUID 1
MstrProjAccessPrflIsChecked MstrProjAccessPrflIsChecked 1
UserIsInvolved UserIsInvolved 2 
@AbapCatalog.sqlViewName: 'IMPUSRAUTH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
@ObjectModel.representativeKey: 'MasterProject'
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions:true
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Authorized List of Master Project for logged in User'

define view I_MstrProjUsrAuthList as select distinct from I_MasterProject as MpList
    inner join I_MasterProjectType as MPType on MpList.MasterProjectType = MPType.MasterProjectType
    left outer to many join I_MstrProjUser as MPUser on MpList.MasterProject = MPUser.MasterProject and MPUser.UserID = $session.user
    left outer to many join ( I_MstrProjTeamMember as MPTeamMember inner join I_MstrProjTypeViewAccOnRole as MPRole 
                      on MPTeamMember.ProjectRole = MPRole.MasterProjectRoleID and MPTeamMember.UserID = $session.user ) 
                      on MpList.MasterProject = MPTeamMember.MasterProject
    
{
   key MpList.MasterProject as MasterProject,
       MpList.MasterProjectUUID as MasterProjectUUID,
       MpList.MasterProjectType as MasterProjectType,
       MpList.MasterProjectName,
       MPType.MstrProjAccessPrflIsChecked,
       MpList.MasterProjectOrganization,
       MpList.MasterProjectIsConfidential,
    case when MPUser.UserID = $session.user
     then MPUser.UserID
     when MPTeamMember.UserID = $session.user
     then MPTeamMember.UserID
     else ' '
     end as UserID,
     case when MPUser.UserID = $session.user or MPTeamMember.UserID = $session.user
     then 'I'
     else 'N'
     end as UserIsInvolved
     }

Learn More