Skip to Content
avatar image
Former Member

Collective DATABASE Table Name Required

Hi Guys,

Can anyone please suggest a single database table name,where we can find all the list of users in SAP standard system,which also have the corresponding Auth. objects,Roles and TCodes assigned accordingly to user.

if not,can you please suggest a different table names where i can pull the data from different table by building a relationship between them.

please help me ASAP.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 06, 2017 at 09:21 PM

    Hi Jay,

    There is a standard set of reports within SAP which will do what you're asking. Have a look at transaction code SUIM and go through the various options. For instance, if you choose User -> Users by Complex Selection Criteria you will see options for listing users by all the things you mention: by Role, by Authorizations (including by Authorization Values), and by Transaction Authorizations, or even by complex combinations of these options, among others.

    FYI, I added a secondary tag to your question for NW ABAP User Administration and Authorization.

    Cheers,
    Matt

    Add comment
    10|10000 characters needed characters exceeded