Skip to Content

Collective DATABASE Table Name Required

Oct 09, 2017 at 03:46 PM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Matt Fraser
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.


Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Matt,

Thanks for spending time on my question.I will check this once..-:)