I_PPM_STDTASKHIERARCHYDATA

CDS View

I_PPM_StdTaskHierarchyData

I_PPM_STDTASKHIERARCHYDATA is a CDS View in S/4HANA. I_PPM_StdTaskHierarchyData. It contains 1 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 1 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PPM_ProjectTask view left_outer COMPOSITE Milestone Information

Fields (1)

KeyField CDS FieldsUsed in Views
ParentObjectUUID ParentObjectUUID 1 
@AbapCatalog.sqlViewName: 'IPPMSTDTSKHIERDT'
@VDM: {
    viewType: #BASIC,
    lifecycle.contract.type: #SAP_INTERNAL_API
}

@AbapCatalog.compiler.compareFilter: true

@AccessControl: {
    authorizationCheck:     #PRIVILEGED_ONLY,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED 
} 

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
   representativeKey: 'HierarchyNodeUUID',
   alternativeKey: [ { id : 'ReferencedObjectUUID', uniqueness: #UNIQUE, element : 'ReferencedObjectUUID' } ],
   dataCategory: #HIERARCHY,  
   usageType: {
     serviceQuality:  #A,
     dataClass:       #TRANSACTIONAL,
     sizeCategory:    #L
    }
} 


// the hierarchy has two directoryies, one directory for project type elements and one directory for task like elements

// fir the standard task hierarchy, we only request data for Type T, which goes up to PST only

@EndUserText.label: 'I_PPM_StdTaskHierarchyData'
define view I_PPM_StdTaskHierarchyData as select from /s4ppm/hierarchy as hierarchy 
// to_parent will fail by intention for the PST (as this points to an oibject outside the task hierarchy (Project)

    association [0..1] to I_PPM_StdTaskHierarchyData as _ToParentObject 
        on  $projection.ParentObjectUUID          = _ToParentObject.ReferencedObjectUUID
// the root object can not be found here, as it is already a portfolio object (ProjectUUID)        

    association [0..1] to I_PPM_StdTaskHierarchyData as _ToRoot
        on  $projection.RootObjectUUID      = _ToRoot.ReferencedObjectUUID
        and _ToRoot.HierarchyType           = 'P'
// cannot get draft data, comment this

// to avoid display milestone in planning app        

//    association [0..1] to /s4ppm/task as _ToTask on $projection.ReferencedObjectUUID = _ToTask.guid

{
//hierarchy 

key guid                as HierarchyNodeUUID, 
    hierarchy_type      as HierarchyType, 
    object_guid         as ReferencedObjectUUID, 
    root_object_guid    as RootObjectUUID,
    up                  as ParentObjectUUID, 
    sort_number         as OrdinalNumber, 
    
     _ToParentObject,
     _ToRoot
} where hierarchy_type = 'T' // and _ToTask.milestone <> 'X'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/S4PPM/HIERARCHY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More