topic Re: SAP Query User Group in Application Development and Automation Discussions

SAP Query User Group

former_member566284 — Fri, 13 Aug 2010 11:33:20 GMT

Is there a way to find out the mapping between a User and a SAP Query usergroup? If yes, which table has this mapping?

I know that we can assign query user groups to users in SQ03 but I need to extract a report which displays all Query Usergroups and their users assigned to them.

Thanks,

Kashif

Re: SAP Query User Group

Former Member — Fri, 13 Aug 2010 11:48:24 GMT

AQGDBBN is the table you are looking for

Re: SAP Query User Group

former_member566284 — Fri, 13 Aug 2010 11:55:36 GMT

The table AQGDBBN seems to display a mapping of User Group with use rindeed but the results are less than the actual assignment. And the mapping does not have the Z query usergroups that have users assigned in SQ03.

Anything that I may be missing?

Thanks,

Kashif

Re: SAP Query User Group

Former Member — Fri, 13 Aug 2010 13:02:36 GMT

Try using the Function Module RSAQ_IMPORT_USERGROUP_CATALOG, check for the values in resut field of O_DBBN