Tansaction SQVI: Which queries does a specific user use?

[former_member399530]

Dear all

In transaction SQVI I see only my own queries (see picture).

But we need to know for some specific users, which queries has he/she created or does he/she use.

Therefore we need to know the transparent table names behind the transaction SQVI.

Yes, I did already some research on SCN and on the web. I browsed already a lot of AQ* tables without any luck ...

Any hints and suggestions are highly appreciated.

Regards,

M.

[SuhaSaha]

Hello Markus,

I activated a ST05 trace before starting SQVI & found the following:

• function 'RSAQ_QUICK_VIEW_USER_GROUP' gives the QuickView(QV) user group
• Once you get the QV user group go to table AQLQCAT and get the query name, where AQLQCAT-NUM = QV user grp from above

BR,

Suhas

[former_member399530]

Some more information.

a) Use FM RSAQ__QUICK_VIEW_USER_GROUP to find out the user group of a SAP user.

b) Use report RSAQDEL0 to see the tables and field per query per user.

Regards,
Markus

[former_member399530]

Many thanks, Suhas.

This works.

Regards,
Markus