I_MstrProjUsrAuthList

DDL: I_MSTRPROJUSRAUTHLIST SQL: IMPUSRAUTH Type: view COMPOSITE

Authorized List of Master Project for logged in User

I_MstrProjUsrAuthList is a Composite CDS View that provides data about "Authorized List of Master Project for logged in User" in SAP S/4HANA. It reads from 2 data sources (I_MstrProjTypeViewAccOnRole, I_MasterProjectType) and exposes 9 fields with key field MasterProject.

2 data source(s) 9 fields

Data Sources (2)

SourceAliasJoin Type
I_MstrProjTypeViewAccOnRole MPRole inner
I_MasterProjectType MPType inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMPUSRAUTH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.representativeKey MasterProject view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Authorized List of Master Project for logged in User view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MasterProject MpList MasterProject
MasterProjectUUID MpList MasterProjectUUID
MasterProjectType MpList MasterProjectType
MasterProjectName MpList MasterProjectName
MstrProjAccessPrflIsChecked I_MasterProjectType MstrProjAccessPrflIsChecked
MasterProjectOrganization MpList MasterProjectOrganization
MasterProjectIsConfidential MpList MasterProjectIsConfidential
UserIDelseendasUserID
userthenIelseNendasUserIsInvolved 
@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
     }

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MASTERPROJECT",
"I_MASTERPROJECTTYPE",
"I_MSTRPROJTEAMMEMBER",
"I_MSTRPROJTYPEVIEWACCONROLE",
"I_MSTRPROJUSER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More