P_PPM_USERGROUPHIERARCHY

CDS View

User group hierarchy resolution for user

P_PPM_USERGROUPHIERARCHY is a CDS View in S/4HANA. User group hierarchy resolution for user. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PPM_AuthznByUsrGrpH view inner BASIC Project Authorizations by User Group
P_PPM_LocalAuthorizations view inner BASIC Local Authorizations (Activities not yet resolved)

Fields (1)

KeyField CDS FieldsUsed in Views
KEY UserID UserID 2 
@VDM.private:true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PPPMUSERGRPHIER'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

//@EndUserText.label: 'User group hierarchy resolution for user'


//@ObjectModel.representativeKey: 'UserGroupUUID_1'


define view P_PPM_UserGroupHierarchy

  // User groups hierarchy resolution

  // Returns all users with all the user groups they are in , in a table with 3 group columns

  // currently up to a nesting level of 3

  // bottom up


  as select from    aco_group_user as group_user
    left outer join aco_group_hier as gh1 on gh1.child_group_id = group_user.user_group_id

    left outer join aco_group_hier as gh2 on gh2.child_group_id = gh1.user_group_id
  //     left outer join aco_group_hier as gh3 on gh3.child_group_id = gh2.user_group_id


{

      @Semantics.user.id: true
  key group_user.user_id       as UserID,
  key group_user.user_group_id as UserGroupUUID_1,
      gh1.user_group_id        as UserGroupUUID_2,
      gh2.user_group_id        as UserGroupUUID_3
      
}

Learn More