Tags

, , , , , ,

This trick is handy for executing or copying another users Quick View query.  Especially if someone is on vacation or has left the company.  This can also be useful when training a backup and you want to share your Quick Viewer query with them.

This functionality is also helpful if someone is having problems creating an SQVI query and has asked you to look at their query when you have a chance.

As always, my goal is that anyone can use the following information but this is not a step by step instruction manual and will require a good understanding of SAP.

A setting in transaction SQ02 is critical to accessing other users Quick Viewer Queries.  Some companies limit access to this transaction.  If you do not have access to SQ02 then you will not be able to follow along with this document at home.

Important Note: Do not make changes when in someone else’s user group / queries unless they have specifically asked you to.  These changes will be saved to that user IDs Quick Viewer Queries.  If you would like to make changes copy the query to your user group.  See end of Blog for copying query.

Accessing other User’s Quick Viewer Queries

  1. Transaction SQ02 – Info Set: Initial Screen

Once the transaction is executed follow menu path: Settings > Settings…

A pop up box will appear.

Blog 9 - Pic 1

In pop up box select “Display system objects” and then hit Enter.

Blog 9 - Pic 2

While still in SQ02 execute the follow menu path: Environment > Query areas

A pop up box will appear.

Blog 9 - Pic 3

In pop up box select “Standard area (client-specific)

Hit Enter.

Blog 9 - Pic 4

  1. Transaction SQ01 – SAP Query: Maintain queries

Select the Other User group icon.

Blog 9 - Pic 5

A pop up box will appear.

Each SAP User has its own user group for Quick Views.

The Quick Viewer name starts with “SYSTQV”. The user group name says Quick view followed by the User-ID.  In the following example the first user ID is JD101

  • Select the User ID/Group.

Blog 9 - Pic 6

A list of the users Quick Viewer Queries will appear.

Notice that the SAP User ID is displayed right above the list of queries, see red arrow.

Blog 9 - Pic 7

Copy Quick View Query from one user group / User ID to another

Copying a Query from one user group to another is a little tricky.

Transaction SQ01

First go to user group you wish to copy query from and document the query name, user group name and the info set.

In our example:

  • Query: OMD0CHECK
  • User group: SYSTQV000575
  • Info Set: SYSTQV000000000000004236

Transaction SQ02

Enter Info Set and hit Role/User Group Assignment icon

Blog 9 - Pic 8

Find the user group / user ID you are coping to and select Assigned table.

Save.

Blog 9 - Pic 9

Transaction SQ01

Make sure you are “in” the user group you plan to copy to.  In this example user group SYSTQV000438.

In this example we will be copying Query OMD0CHECK from user group SYSTQV000575 to user group SYSTQV000438.  In this example we will keep same query name but you can change it.

Select the Copy Icon and a pop up box will appear.   See following screen shot.

  • Enter: From query name and user group
  • Enter: To Query name.
  • The To User group defaults to the user group you are currently displaying and cannot be changed.
  • Hit enter

Blog 9 - Pic 10

Query will now be in new user group.  Assumable yours so feel free to change away.

Blog 9 - Pic 11

If you have question on this or any other PortSAP Consulting blog please feel free to contact us at Blog@PortSAP.com.  Or if you are looking for Top Quality SAP Consultants please feel free to contact us.

The author, Ray Hornbrook, has over 16 years of SAP functional and technical experience.  Ray started his career in SAP as a Subject Matter Expert (SME) for a SAP implementation in 1998 and is now a senior level SAP Consultant.  Since Ray has worked both sides of SAP, business end user and IT professional, he is able to communicate effectively with both IT and Business team members.  Having a background as an SAP business end user has helped Ray greatly in his consulting career to better communicate with the business members of the team.  As well as helping bridge gaps in communication between the IT and Business team members.

To find out more about Ray Hornbrook please check out his LinkedIn profile by clicking HERE.

End of document – www.portsap.com

Neither PortSAP Consulting nor the author of this Blog is associated with SAP AG or with any of its subsidiary or alliance company. Trademarks used in our website are registered trademarks of respective companies and neither PortSAP Consulting nor the author of this Blog is associated affiliated with these companies.

Advertisements