I_PPM_TEAMMEMBERISINROLE

CDS View

returns X, when the user is in the given ProjectRoleCateg.

I_PPM_TEAMMEMBERISINROLE is a CDS View in S/4HANA. returns X, when the user is in the given ProjectRoleCateg.. 4 CDS views read from this table.

Used by 4 CDS view(s)

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_PPM_MyActvProjectsCostTable view inner CONSUMPTION My Projects - Cost Table (OVP)
I_PPM_MyActvProjCostOvrlPerd view inner COMPOSITE My Actv Projects Overall Cost in Fiscal Periods (continuous)
P_PPM_Project view left_outer COMPOSITE
P_PPM_Prstcm_ProjData view left_outer CONSUMPTION 
@EndUserText.label: 'returns X, when the user is in the given ProjectRoleCateg.'

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

@AbapCatalog: { 
    sqlViewName: 'IPPMTEAMMBRINRL',
    compiler.compareFilter: true,
    preserveKey:true
}

@ObjectModel: {
   representativeKey: 'ProjectUUID',
   usageType: {
     serviceQuality:  #C,
     dataClass:       #MIXED,
     sizeCategory:    #L
   }
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view I_PPM_TeamMemberIsInRole 
            with parameters P_ProjectRoleCategory : domvalue_l
    as select distinct from I_PPM_TeamMemberRoleStaffing as Staffing
            inner join I_User   as User on Staffing.BusinessPartnerUUID = User.BusinessPartnerUUID 
{
    key ProjectUUID,    
    cast( 'X' as boolean ) as IsInRoleCategory
} where ProjectRoleCategory = $parameters.P_ProjectRoleCategory
    and User.UserID = $session.user
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_TEAMMEMBERROLESTAFFING",
"I_USER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More