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 Member · Accepted solution]

Hi Channappa,

in transaction SU01 you can add the user ID, and check the roles.

Regards

Laszlo

[Former Member]

Use FM: BAPI_USER_GET_DETAIL

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

if you want the otherway around

you can also use FM: RSRA_USERS_OF_AGR_GET

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

Thanks,

Surya

[Former Member]

HI,

Please check the tables AGR_USERS and AGR_USERT Assignment of roles to the users.

Thanks,

prasad.s