Question Re: Table for sap query users group and assigned user in Enterprise Resource Planning Q&A

Table for sap query users group and assigned user

Former Member — Tue, 24 Aug 2010 05:57:32 GMT

Hi all,

Is there any table that will show me a list of users assigned to user groups instead of using transaction code SQ03.

I have table AQGDBBN, but it'll only shows Global Area (Cross-client) groups and assigned users,

but I need to see the groups used in Standard Area(Client-Specific) also.

Thanks,

Anuj jain

Re: Table for sap query users group and assigned user

Former Member — Tue, 24 Aug 2010 07:12:02 GMT

In all query transactions

Environment->Query areas

))

Re: Table for sap query users group and assigned user

Former Member — Tue, 24 Aug 2010 07:23:29 GMT

Hi,

Check table AQGDBBG

regards,

Re: Table for sap query users group and assigned user

Former Member — Tue, 24 Aug 2010 07:25:48 GMT

Dear Pauls,

Thanks for Your reply,

I want to extract these details through SAP table, so pls can You give me some ideas abt related tables.

Regards,

Anuj jain

Re: Table for sap query users group and assigned user

Former Member — Tue, 24 Aug 2010 07:28:26 GMT

Dear Thien ,

Table AQGDBBG give only user group with created/updated person user id not assigned user in SQ03.

Regards,

Anuj

Re: Table for sap query users group and assigned user

Former Member — Wed, 25 Aug 2010 03:08:29 GMT

Dear Anuj,

Kindly check report RSAQUSGR. It will show you what you want, table AQLDB will store user group assign role but it's a cluster table. You have to find method to read data from it.

hope it helps,

thanks

Edited by: Thien M. Pham on Aug 25, 2010 10:08 AM

Re: Table for sap query users group and assigned user

Former Member — Wed, 25 Aug 2010 05:09:17 GMT

Thanks thien ,

You Solved my problem for certain limit

Regards,

Anuj jain

Re: Table for sap query users group and assigned user

former_member1370893 — Tue, 08 Aug 2023 14:29:40 GMT

Hello community, Is there a table or report where I can view a list of user groups and the queries/infosets assigned to the specific user group? I wan to identify what user group has queries assigned to the group and especially if there is a user group which dont have any assigned.

thank you

Re: Table for sap query users group and assigned user

michele_williams — Tue, 08 Aug 2023 15:35:24 GMT

Hello. In general, it's best not to reply to a thread that is as old as this one! But I happened to be searching for the same reason today and found the answer above in this thread. Report RSAQUSGR.

Re: Table for sap query users group and assigned user

Worrell — Wed, 17 Apr 2024 09:00:10 GMT

Just in case other users are looking for similar information. I just came across this program in SA38 while looking for last execution and usage for SQ01 queries. You can find assigned user to each user group in SQ03 using SA38 and then execute RSAQUSGR. Enter either name or user group to receive the information.