From which table we can get the Role of the User in SRM

[Former Member]

Hi All,

I need to prepare a report which displays the user and his role in srm. So from which table i can get the role of the user if i have the Userid.

Thanks

-

---

Channappa Sajjanar

[former_member183819 · Accepted solution]

Hi

t- code

SUIM->rOLES->BY USER ASSIGNMENT

SELECT WITHASSIGNMENT OF USER = username

AS A OUTPUT YOU MAY GET ROLE ASSIGNED TO THAT USER.

if you want which FM - you debug while executing this report.

regards

Muthu

[Former Member]

use FM: RSRA_USERS_OF_AGR_GET

with I_AGR_NAME= role and you can retieve Table: ACTIVITY_GROUPS_USERS Field: UNAME(usr Id)

also user FM: BAPI_USER_GET_DETAIL

with USERNAME= user id and can retrieve Table: ACTIVITYGROUPS Field:AGR_NAME

Thanks,

Surya

[Former Member]

HI,

User tables

AGR_USERS

AGR_USERT

Thanks,

prasad.s