How to get Quick Viewer reports through your SAP System landscape

Описание: In this tutorial Joris Alkemade, SAP Expert at iQibt, will demonstrate how you can get your SAP Quick Viewer reports throughout your system landscape.
SQVI reports are clients based and are not accessible by other users. This can be done using SQ00.

If you have any questions, please feel free to leave a comment or contact us via [email protected].

Video summary:

In one of our previous videos (   • How to use Transaction code SQVI (Quick Vi...  ), we demonstrated the basic principles of transaction SQVI,
Quick Viewer reports. But a Quick View report has two drawbacks: one is that it's only usable for the user that has created it and the second one is that you cannot easily transport it to your system landscape. In this video, Joris will demonstrate how to get your SAP Quick Viewer reports throughout your system landscape by using the SAP query transactions.

Before you can start creating this Quick Viewer into SAP Query, you first have to make sure that the User Group for the authorizations to users are equally distributed over the ‘Global Query Area’ and the ‘Standard Query Area’. for this be use transaction ‘SQ03 User Groups’.
First step: Make sure that you have the same User group created as the global User group. This is required to import your report into the global environment.

1. For this, we go to transaction SQ03 - user groups. In here we need to change the query area to ‘Standard Area’.
2. As you can see, we already have the local user group ZIQ, which is the same as the global user group ZIQ. If you don’t have it, create it.
3. Now we have the same User Group in both areas.

Now we have the User Group defined we can use the convert Quick View option in the transaction SQ00

1. Go to transaction ‘SQ00’ to import the SQVI Query to ‘SQ00’
2. We first need to change the area from ‘Global’ to ‘Standard’ to be able to use the convert option: ‘SQ00’, ‘Environment’, ‘Standard Area’ (client Specific)
3. Select the User Group you previously created by clicking on ‘Other User Group’. Select ‘ZIQ’
4. Go to Query and select ‘Convert from Quick View’. Now you will convert from ‘SQVI’ to ‘SQ00’
5. Select the Quick View report name by entering its name and the user who created it (usually yourself) and press ‘Ok’ or Enter’
6. Now fill in ‘Query’ the name of the query (usually same name you used in SQVI) and InfoSet. Enter the same name. Make sure ‘User Group’ is populated. For this demo, it's ‘ZIQ’. Press ‘Enter’ or ‘Ok’.
7. Now the SQVI query is imported to ‘SQ00’ but it's still in query area ‘Standard Area’ which is still client specific. We will transport/import it to ‘Global Area’ (cross-client).
To import the query from ‘Standard’ to ‘Global’ we will use transaction’ SQ02’.

1. Go to 'SQ02' than select ‘ZIQ’ in Standard Area and press the ‘Transport’ button. Program RSAQR3TR does the same.
2. On the top corner select 'Copy Standard', 'Global Area', uncheck test run.
Then select ‘Transport InfoSets and Queries’ Leave import option on ‘REPLACE’. Replace means create or replace.
Enter the InfoSet and Query names and press Execute.
3. You can select a local object, or you can create a transportable package to transport it across your landscape.
4. Now the query is available on all clients across the system and can be transported.

To check out the actual result. We can check SQ00 again to see that our Quick Viewer is now available as a query in the Global Query Area in User Group ‘ZIQ’.

If you want to change the User Group within this view you can do this with the option under ‘Menu’, ‘Edit’, ‘Other User Group’, select your User Group.

If you would like to move the transaction to another query area you can do this within the environments query areas and then select your query environment.

For now, you're basically there. You can use transaction code ‘SQ00’ together with User Group ‘ZIQ’ to incorporate this in user roles to allow users to access this report throughout your system landscape.

If you directly want to access the query, you can also look up the ABAP report which has been generated for this query by going to ‘Query’, ‘More functions’, ‘Display report name’. Therefore you can assign a transaction code also directly to this report and then include that transaction code in the user roles.


Credits:
Joris Alkemade, SAP Expert at iQibt
Emrah Ayar, SAP Expert at iQibt

Disclaimer:
The views, thoughts, and opinions expressed in the video belong solely to the author, and not necessarily to the author’s employer, organization, committee or other group or individual. No rights can be derived from any discrepancies or any contents of this video in general. The contents of the video are protected by copyright, the unauthorized use of which is forbidden.