SAP Query User Groups

[Former Member]

I need to find all the User Groups a given User is assigned to.    The user has changed userids and I need to take the old ID out of the user groups to which she was assigned and add the new ID to the same groups.  Her old ID is no longer valid.

Is there a standard SAP program that will list the user groups to which a specific user is assigned?

[Former Member]

Hi Castles,

You may want to take a look at table USGRP_USER

Hope it helps. Cheers!
 
 

[Former Member]

Sorry.. that didn't work.   I think that's somehow classifies logons to a different kind of user group.   I am looking to find a user in a SAP Query User Group.

[Former Member]

Well then how about table AQGDBBN?

Hope it helps. Cheers!

[Former Member]

That's closer.  However that's for client independent user groups.   This is for client dependent user groups.   Thanks for trying though.

[Former Member]

Okay my last attempt

Run FM RSAQ_IMPORT_USERGROUP_CATALOG and filter out the User ID you are looking for in table parameter O_DBBN.

Hope it helps. Cheers!

[Former Member]

That was the answer!  Points awarded.  Thanks!

[Former Member]

Hi,

Try with the table AQGDBBG which stores all user groups.Hope it helps u..

[Former Member]

I think that table holds only cross-client usergroups.   I was looking for client dependent user groups.  Points awarded for helpful answer.  However Nguyen found the ultimate solution.