Finding T-Codes Assigned to Users in SAP System

[pnagar]

This blog post is to help SAP basis Guy who need to provide T codes assigned to all the users in SAP System. Since it is very basic thing to get it done but there are lot of way to get it done out of which i am sharing with you the one that i prefer a lot .Earlier i was using Excel and lot of tables to get the required results and though a lot of time i was encountered with lot of inconsistency.

I will be using SQVI t code in this blog. But before that let me share you one authorization concept.
Whenever you add a t code in role then it is assigned to Object S_T code in Authorization Tab as below.





 

However you could find that whenever you find t codes executable for a user for suim report they are more in number then those of assigned in Menu of roles actually the logic behind the same is that suim reports calls object S_tcode and then paste the results. However their is a difference between adding a t code in Role menu and Under authorization object S_T CODE.

But in this blog we would be fetching the Data from S-T code. So lets quickly get started.

1.Use T code SQVI

below screen would get open.



 

Give the name of your Quick-view in my case i have given SOD and then click on Create, the below screen would open.



In data Source Click on Table Join and Give Title as above. then next screen would open.



Here click on this below button and includes the tables one by one.



 

I would be using two tables as agr_users and agr_1251 as below.



and Once you included both the tables then below screen would appear.



Now click F3 to go back to and save the SQVI script.once saved then go to the left corner and make setting as below.



and



Then again click on save and execute Now below screen would appear.



 

Now enter username and authorization object as S_t code and then execute you will get the required results as below.