topic Re: SQ00 sap queries in Application Development and Automation Discussions

SQ00 sap queries

Former Member — Fri, 16 May 2014 08:10:11 GMT

Hi guys,

I am trying to add SQ00 queries to my sap favorites however struggling to find a way of doing it.

does anyone know of this is possible?

Re: SQ00 sap queries

Former Member — Fri, 16 May 2014 08:16:13 GMT

Hi Robbert ;

In the main page, right click to the favourites folder and select the add Tcode tab.After that you can enter the SQ00 Tcode here,save it.Thats all.

Regards

Özgün

Re: SQ00 sap queries

Former Member — Fri, 16 May 2014 08:21:14 GMT

Right click Favorites -> Insert transaction-> In that give ur tcode SQ00........

Re: SQ00 sap queries

Former Member — Fri, 16 May 2014 08:47:35 GMT

Guys, I am sorry if I am not being clear.

We have loads of user groups in SQ00 which house like 50 queries each.

My question is can I add a specific query from a user group direct in my sap favorites?

This way I don't need to run SQ00 look for the user group and query.

look forward to hearing back from you

Re: SQ00 sap queries

Former Member — Fri, 16 May 2014 09:53:32 GMT

Hi,

probably, you could create a new transaction (Z or Y) and link with your query.

Query is a program. You can see this link in this way from SQ01

Query --> More functions --> Display report name

Ivan

Re: SQ00 sap queries

Jelena_Perfiljeva — Fri, 16 May 2014 19:11:14 GMT

Other than creating a custom transaction, as suggested above, there is no way to add a query to Favorites, to my knowledge. There might be a way to shorten the query list within he group by applying a filter in the ALV layout (query list itself is an ALV grid), but that's about it.

It does seem though that the query user groups are not maintained very well in this case, perhaps it'd make sense to revise them to align with the user roles better. We use queries a lot, but only a few users even have access to more than one group, so this has never been an issue.