Collective DATABASE Table Name Required

[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.

[Matt_Fraser]

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

[Former Member]

Hi Matt,

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