I_PPM_ISMYPROJECTASSUBSTITUTE

CDS View

All prjs a usr is rsp for as a subst

I_PPM_ISMYPROJECTASSUBSTITUTE is a CDS View in S/4HANA. All prjs a usr is rsp for as a subst. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PPM_MostCriticalProject view left_outer COMPOSITE My Projects - Critical
P_PPM_Project view left_outer COMPOSITE
P_PPM_ProjectList view left_outer COMPOSITE 
@EndUserText.label: 'All prjs a usr is rsp for as a subst'

@VDM.viewType: #COMPOSITE

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

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

@ClientHandling.algorithm: #SESSION_VARIABLE

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

@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API
define view I_PPM_IsMyProjectAsSubstitute as select from I_PPM_Substitute as Object
    inner join I_PPM_ProjectSummaryTask as Project 
        on Project.ProjectSummaryTaskUUID = Object.ReferencedObjectUUID
{
    key Project.ProjectUUID,
    cast( 'X' as boolean ) as IsMyProject    
} where Object.SubstituteUser = $session.user
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROJECTSUMMARYTASK",
"I_PPM_SUBSTITUTE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More