Skip to Content
avatar image
Former Member

Report for SAP Authorization matrix

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


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Nov 18, 2014 at 09:39 AM

    Hi Asad,

    Try the reports in the following menu path:

    You should find one that meets your needs.

    Regards,

    Graham


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 18, 2014 at 11:36 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 19, 2014 at 06:45 AM

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

    Regards,

    Phani

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 19, 2014 at 11:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 20, 2014 at 01:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded