Skip to Content
Author's profile photo Jürgen Lins

How to find and execute or work with other users quick views (or quick views created with old user-id)?

Preparation:

Execute SQ02

QV1.jpg

Choose from menu Settings > Settings   to get this Pop-up for your settings

QV2.jpg

Activate “Display system objects”, and then press Enter to adopt the changes.

Make sure that your work area is set to “Standard area” in menu Environment > Query areas:

QV3.jpg

Operation:

Execute transaction SQ01

QV4.jpg

  Click Change Usergroup

QV5.jpg

 

Each User has its own user group for Quickviews. 

The name starts with SYSTQV followed by a sequential number. The user group name says Quick view followed by the User-ID

Choose a desired User group and you get the following view with all the quick views from the chosen user and can execute them

QV6.jpg

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Craig S
      Craig S

      Thanks for the blog!  I haven't used the process that way.  Maybe you could do a follow-up blog on the reverse sometime.  I don't often have a need to use other people's queries but I have often written a query for either a user or a developer.  Sometimes to help the developers with the data set they need to use for a report under development, or for a user to review a prelimanary report under development.  Since a lot of environments are highly regulated such as my industry, (pharma), many wouldn't be a able to look up and run my query due to security.  Most of the clients I have had, only allow read access to most users for SQVI and never let them write their own queries.  That's limited to a handful of developers and support personnel.

      But I, (or the appropriate person), can assign a user to my queries, (or anyone else's) using SQ03.  Once they have run it, reviewed it and commneted on it, I switch them back to their original query group. 

      It's a very similar process to what you explained just from the opposite direction.

      FF

      Author's profile photo Jürgen Lins
      Jürgen Lins
      Blog Post Author

      Good idea, just tested it an it worked well. I will extend the blog showing this alternative.

      We had the problem that one guy had created a quick view to extract data for migration. Then he became sick and we needed to execute this quick view. So he was not able to add actively a user to his quick views.

      The usage is very restrictive in our company as well. But it was not meant for endusers, I had consultants in focus.

      Author's profile photo Craig S
      Craig S

      I knew you did, (have consultants in mind). 

      The illness thing could very easily come in play during a project!  I'm going to keep that in mind!

      Thanks!

      FF

      Author's profile photo Former Member
      Former Member

      This question has been asked many times and this is the first time it has been correctly answered. Most "correct" answers claim that it is not possible.

      Author's profile photo ashish desai
      ashish desai

      How can we restrict SQVI to Execute only option? I have created some roles to make it execute only, but I CAN still create query and able to save them as well. Need some input - if any one can.

      Author's profile photo Jürgen Lins
      Jürgen Lins
      Blog Post Author

      I dont think there is any authorization setting for this. As you can see from this blog it is quite tricky to get to the quickviews of another user.

      With SU24 transaction you can check which authorization objects are assigned to transaction SQVI and SQ02 . Discuss this with a authorizations expert.

      Author's profile photo ashish desai
      ashish desai

      Thank you sir for the quick reply. I really appreciate it.

      Regards

      Ashish

      Author's profile photo Former Member
      Former Member

      Thanks a lot for your help !

      Wonderful !

      Author's profile photo Igor Veriaev
      Igor Veriaev

      Thanks for sharing!

      It seems like user who would like to run someone else's query is supposed to have authorization for query maintenance (S_QUERY-ACTVT = 23). Otherwise other user groups remain invisible for him/her.

      Author's profile photo Sathyan Neerattil
      Sathyan Neerattil

      Thanks for sharing!