Report for SAP Authorization matrix

[Former Member]

Hi Experts,

Is there any report/tool to find out the current user authorization matrix in SAP?

We want a report in which I can get:

a) User Name and User ID

b) Role assigned,

c) User status,

d) Transaction limitations,

e) Module assigned,

f) SAP IDs including ID description from system (if possible)

Please help me ASAP.

Thanks

Asad

[sumeetkaushal]

Yes it is possible with SQ01/SQVI by linking tables where these data are stored in SE16N Table Display. You can download these report from Database table into a excel sheet and combine it to your requirement.

You can also create a customize report as per your requirement with help of ABAP team.

[Former Member]

Hi Asad,

Please find below tables which can help you.

If you want consolidated report please create SQ01 report or quick view through SQVI.

If you do not have access to these you can also use Microsoft access to link these table data

a) User Name and User ID -->  V_USERNAME

b) Role assigned --> AGR_USERS

c) User status --> USR02

d) Transaction limitations --> AGR_USERS and then AGR_1251 (limited to authorization object S_TCODE)

e) Module assigned --> What do you mean by module assignment wrt user ID

f) SAP IDs including ID description from system (if possible) -->  SAP ID? you mean user ID in SAP system or you meant S User ID?

Regards

Abhijit Mishra

[Former Member]

Hi Asad,

Such an exhaustive report can be taken out from table.

You can check tables in SE16 and download in spreadsheet format.

AGR_USER will give you details about roles assigned to each user.

USR21 and USR03 will give you User details.

AC

[former_member314331]

you can Create Query with SQ01 linking USR02, USR03 and  AGR_USERS Tables

Regards,

Phani

[Former Member]

Hi Asaduzzaman,

I think graham said correct and also using t-code - SUIM then generate a report n get the output to excel file

Note for JAVA : 

https://help.sap.com/saphelp_nwce72/helpdata/en/e3/79033eb33b4160b941947646a6e00c/content.htm

[Former Member]

Suim is for single entity. I am asking for single report with full matrix.

Thanks

Asad

[Former Member]

Hi Asad,

Try the reports in the following menu path:

You should find one that meets your needs.

Regards,

Graham