I_MSTRPROJTYPEVIEWACCONROLE

CDS View

Master Project Type View access on Roles in Role Profile

I_MSTRPROJTYPEVIEWACCONROLE is a CDS View in S/4HANA. Master Project Type View access on Roles in Role Profile. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MstrProjUsrAuthList view inner COMPOSITE Authorized List of Master Project for logged in User 
@AbapCatalog.sqlViewName: 'IMPTYVIEWONROLE'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'MasterProjectType'
@Metadata.allowExtensions:true
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Master Project Type View access on Roles in Role Profile'
define view I_MstrProjTypeViewAccOnRole as select from I_MasterProjectType as MpType
inner join /cpd/pwsc_rolpid as MpRoleProfileAuth on MpType.MasterProjectRoleProfileValue = MpRoleProfileAuth.rol_prf and MpType.MstrProjAccessPrflIsChecked is not initial
inner join /cpd/ac_prf_acc as MpPrfAccSpecifier on MpRoleProfileAuth.acc_prf_id = MpPrfAccSpecifier.acc_prf_id
left outer to many join /cpd/ac_acc_supr as MpPrfSuperAccSpecifier on MpPrfSuperAccSpecifier.super_acc_spec_id =  MpPrfAccSpecifier.acc_spec_id

 {
   key MpType.MasterProjectType as MasterProjectType,
   key MpRoleProfileAuth.role_id  as MasterProjectRoleID

}

  where MpPrfAccSpecifier.acc_spec_id ='003'  or   MpPrfSuperAccSpecifier.acc_spec_id  = '003'



/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MASTERPROJECTTYPE",
"/CPD/AC_ACC_SUPR",
"/CPD/AC_PRF_ACC",
"/CPD/PWSC_ROLPID"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More