I'm updating my users with their correct User Type for the User Audit. Is there any listing that identifies which...
tcodes are for which User Type? (Example: MM03-Informational, MM02-Operational)
As you know everything is in R/3 tables. So, you can get a list of "users by type" by querying table USR02. The field 'USTYP' indicates the type of user (Dialog, Background, CPIC). Once you get a list of users by type, you can use transaction SUIM to get the list of transactions assigned to users. After running SUIM, select Transactions->Transaction Lists According to Selection With User, Profile or Object->Executable for user. You can create your own SQL script to get everything in a pretty automated way. Tip: declare cursors To help you out, see the following SQL queries (which you can then improve by declaring cursors). -- This query lists all user accounts that are type Background in client 400 select * from USR02 where USTYP='B' and MANDT='400' -- This query lists all activity groups in client 400 assigned to the user JOHND select * from AGR_USERS where MANDT='400' AND UNAME='JOHND' -- This query lists all transactions assigned to activity group 'AP_CLERK' in client 400 select TCODE from AGR_TCODES where MANDT='400' and AGR_NAME='AP_CLERK'
Dig Deeper on SAP Basis administration and NetWeaver administration
Related Q&A from Giovanni Davila
Learn how to transfer a client from one server to another in this administration tip from Basis guru Giovanni Davila. Continue Reading
Read expert advice on implementing an SSO solution for SAP in this expert tip from Giovanni Davila. Continue Reading
Learn how to return a list of 1,000 transport requests in SAP R/3 PRD in this tip from SearchSAP.com's Basis expert. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.