P_PPM_USERGROUPHIERARCHY

CDS View

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

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PPM_AuthznByUsrGrpH view inner BASIC Project Authorizations by User Group
P_PPM_AuthorizationByUserGroup view inner BASIC
P_PPM_LocalAuthorizations view inner BASIC

Fields (1)

KeyField CDS FieldsUsed in Views
KEY UserID UserID 3 
@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
      
} 
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACO_GROUP_HIER",
"ACO_GROUP_USER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More