PortSAP, Quick Viewer, Ray Hornbrook, SAP, SQ00, SQ01, sqvi
On my first pass at this Blog I started to get deep into “why”, with proper training, Quick Viewer and SAP Query are great tools. But things started to go way off track and the Blog got really long. I will save why I believe Quick Viewer and SAP Query to be great tools and how companies can benefit from both for another blog.
For now let’s just say I’m a huge fan of both Quick Viewer (SQVI) and SAP Query. With proper training they are both great tools. One of the big benefits of both tools is that they do not require ABAP programming. And can developed and implemented in production in a lot less time than a custom ABAP report.
If you are at a company that uses Quick Viewer and SAP Query there will come a time when someone will ask, “Can I convert my Quick Viewer Query into an SAP Query?” And now you will be able to say yes and show them how.
On several occasions I have seen where an end user has created a really good Quick Viewer (SQVI) query that other on their team would benefit from using. You can either recreate the query from scratch in SAP Query, which at best is a two or three step process or you can quickly convert the Quick Viewer Query into an SAP Query.
Note: This Blog post assumes you already know the difference between Quick Viewer (SQVI) and SAP Query. Along with why there could be a requirement to convert a Quick Viewer Query created by an individual to an SAP Query that is made available to a group of users.
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.
Convert an SQVI Query into an SAP Query
- Transaction SQ01/SQ00 – SAP Query: Maintain queries
Important note: You will need to know the Quick Viewer Query name along with the User ID of the person who created the Quick Viewer Query. You should also be in the SAP Query User Group to which you wish to copy the query.
Again, an understanding of Quick View & SAP Query is advised.
In this example:
- Quick Viewer Query: ZPIR
- Quick Viewer User ID: RH108
- SAP Query: PI
Once the transaction is executed follow menu path: Query > Convert QuickView…
- A Pop Up box will appear.
- Transaction SQ01/SQ00 – First Pop Up Box
- Enter: Quick View name
- Enter: User Name
- Hit enter Icon
- Transaction SQ01/SQ00 – Second Pop Up Box
- Enter TO Query Name: ZPIR
- Enter TO InfoSet name: ZPIR_InfoSet (You create name)
- Hit Enter
After hitting Enter the SAP Query will appear in the PI User Group query list.
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.
You must be logged in to post a comment.