Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Report for User profile, user group and user name

Former Member

‎02-24-2009 12:48 AM

0 Kudos

Hello all,

Is there a report we can execute which gives a list of all the profiles attached to the users per user group?

USR04 gives us the profiles attached to the user but not the user group associated with the user.

Thanks

2 REPLIES 2

Former Member

‎02-24-2009 2:17 AM

0 Kudos

You'll have to use USR02 and USR04 both tables, either you can download data for both the tables and do a vlookup for the user groups from the USR02 data against the user name field of USR04

OR

you may write a adhoc JOIN query in SAP.

Cheers !!

Zaheer

RainerKunert
Active Participant

‎02-24-2009 1:38 PM

0 Kudos

Use the authorization info system (menu AUTH or transaction SUIM).

Start the report "users with complex authorization criteria". Run the report, then you can switch to the profile assignment. Because it is an ALV you can add the user group and sort the list.

Disadvantage: you can't start this report as a batch job because you have to press the "profile" button to get the profiles.