P_PPM_AuthorizationByUserGroup

DDL: P_PPM_AUTHORIZATIONBYUSERGROUP SQL: PPPMAUTHUSRGRP Type: view BASIC

P_PPM_AuthorizationByUserGroup is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (aco_user_group, P_PPM_UserGroupHierarchy) and exposes 4 fields with key fields ReferncedObjectUUID, Activity, UserID.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
aco_user_group GroupAuth from
P_PPM_UserGroupHierarchy UserGroup inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPPMAUTHUSRGRP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ReferncedObjectUUID aco_user_group object_id
KEY Activity aco_user_group activity
KEY UserID P_PPM_UserGroupHierarchy UserID
ObjectType aco_user_group type 
@AbapCatalog.sqlViewName: 'PPPMAUTHUSRGRP'
@AbapCatalog.compiler.compareFilter: true

@VDM.viewType: #BASIC
@VDM.private:true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
// @EndUserText.label: 'PPM Object Authorization for a user via group assignment'

define view P_PPM_AuthorizationByUserGroup as select from aco_user_group           as GroupAuth
        inner join      P_PPM_UserGroupHierarchy as UserGroup   on GroupAuth.user_group_id = UserGroup.UserGroupUUID_1
                                                                or GroupAuth.user_group_id = UserGroup.UserGroupUUID_2
                                                                or GroupAuth.user_group_id = UserGroup.UserGroupUUID_3
{
  key GroupAuth.object_id   as ReferncedObjectUUID,
  key GroupAuth.activity    as Activity,

      @Semantics.user.id: true
  key UserGroup.UserID      as UserID,
      GroupAuth.type        as ObjectType
}

Learn More