List of SAP T-codes for users

Tags:
SAP administration
SAP Transaction Codes
SAP user accounts
SUIM
Hi, I need a list of SAP users and their corresponding T-code access. I can do it via SUIM user by user but this is too slow. Are their any other T-codes that can do it? Cheers

Answer Wiki

Thanks. We'll let you know when a new response is added.

Go into SE16 or SE16N
Put in table AGR_USERS
Put in whatever ID + * to pull all users that are dialog based on your companies user id standards
Put in all the roles you are looking for in the Role fields, or put in *
Uncheck everything but Role and User
(also probably need make the maximum number greater than the default)

There is a complete list of all roles and their users, which you can export into an excel spreadsheet and sort.

Runs in about a minute, much quicker than SUIM ;)

– This gives a list of all roles a user has, or a list of all users a role has.

Hi!

I try to use the SUIM T_CODE but it doesn’t show me the relation <b>USER-ROL-T_CODE</b>.
So a query was the way I found it.
1. Go into SQ00
2. Put Quick Viewer button
3. In the box QuickView name your Query
4. Put Create button
5. In Choose Data Source Window write the Query Title and some comments
6. In data Source Combo Box Choose Table Join option and then Press ENTER
7. Go to Menu>Edit >Insert Table.

I use the following tables:

1. TSTCT: Transaction Code Text
2. TSTCA: Values for transaction code authorization
3. UST10S: User Master: Single Profiles
4. UST04: User Masters
5. V_USERNAME: Generated Table for View V_USERNAME
6. AGR_USERS: Assignment of roles to users

If you follow this sequence the keys will join automatically.
You can find other ways to make this join .. this the way I found.

7. Go to Back Button
8. In data Field Layout Choose the list Fields and Selection Fields in order to show in the query <b>USER-ROL-T-CODE.</b>
9. Execute
10. Query!

I hope this could be useful.

Discuss This Question: 4  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Tcolema
    AGR_TCODES
    10 pointsBadges:
    report
  • Tabl
    It is a great query but how to make it with s-tcode and t-code together . Thanks,
    10 pointsBadges:
    report
  • TcodeAuthorisation

    Hello Experts,

    I am an end user. I want to know what are all the T codes which I can use in my authorisation. Can we get any such list?

    Regards

    Dhananjay

    10 pointsBadges:
    report
  • TomLiotta
    Can we get any such list?   You can probably can if you look in your SAP documentation or 'help' system. This isn't a SAP support site.   Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following