How to get lsit all active SAP users with transactions assigned to them

[Former Member]

Hi,

I would like to get a report of all active SAP users and the transactions currently assigned to them in SAP 4.6c ver.

RSUSR002 and other reports are not fulfilling this requirement.

Thanks,

Srinivas

[Former Member]

Hi ,

You can get list of users with transactions by browsing the table AGR_TCODES & AGR_UESRS through se16 Transaction

[Former Member]

Hi

these tables provide information for users with roles, like rsusr002 report.

But users wtih access tcodes is not available from these tables.

Srinivas

[manohar_kappala2]

Hi Srinivas,

Use the Table AGR_USERS to get the details of USers with their roles

And AGR_1251 with Object Field as S_Tcode to give you the list of all tcodes for Roles

So based on this u can get the final report which u can create by using excel formulas...

the AGR_TCODEs doesnt take the entries form S_Tcode but takes from Role MEnu so its risky to use it if there are some S_Tcode entries manually attached

Regards,

Manohar

[Former Member]

Hi Srinivasa,

You can table AGR_USERS which would display the list of users and their assigned roles.

Use table AGR_1251, here you enter the role name in AGR_NAME filed and S_TCODE in OBJECT filed, this would bring up all the transactions that are present in that role.

You may even create a Infoset Query to bring up the output from these 2 different tables at once.

Please award points if is useful.

Thanks n Regards,

santosh