topic SAP Query User Groups in Application Development and Automation Discussions

SAP Query User Groups

Former Member — Thu, 25 Jul 2013 02:28:52 GMT

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?

Re: SAP Query User Groups

Former Member — Thu, 25 Jul 2013 02:41:12 GMT

Hi Castles,

You may want to take a look at table USGRP_USER

Hope it helps. Cheers!

Re: SAP Query User Groups

Former Member — Thu, 25 Jul 2013 02:57:22 GMT

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.

Re: SAP Query User Groups

Former Member — Thu, 25 Jul 2013 03:10:24 GMT

Well then how about table AQGDBBN?

Hope it helps. Cheers!

Re: SAP Query User Groups

Former Member — Thu, 25 Jul 2013 09:24:25 GMT

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

Re: SAP Query User Groups

Former Member — Thu, 25 Jul 2013 09:51:11 GMT

Hi,

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

Re: SAP Query User Groups

Former Member — Thu, 25 Jul 2013 10:37:59 GMT

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!

Re: SAP Query User Groups

Former Member — Thu, 25 Jul 2013 11:32:48 GMT

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.

Re: SAP Query User Groups

Former Member — Thu, 25 Jul 2013 11:33:36 GMT

That was the answer! Points awarded. Thanks!