Skip to Content
Personal Insights
Author's profile photo Atılay CANERKEK

Create SQVI reports for SAP users

In the SAP system, checking some of the data for the data you want and you want to be easily accessible or in a field that you want to display the data in different areas. This reporting method with users is quick and easy.

 

Transaction: SQVI

 

First, we will define your report’ s name, and then create the bottom.

 

When you click to create the bottom of the popup window. The title is a required field. This field is the name of the report. Then select the data source, writing titlte.

If you select a table, you will find all of the table’s fields with a non-hierarchical list; This means that the format of the ALV. But if you want to use more than one table, table join. This is very important.

, And then click OK.

Initially, the table join screen is blank. Add adds the table under tables.

When you add a table, select the popup window. What’s the name of the table you want to use after that will add.

The first table

This is the most important step in quickviewer. You must connect using the right areas. If you look carefully, 2 fields connected and 2 is the same as the field names. This means that 2 different table’s fields the same data. When you finish to join tables, you will go back.

In the last step, you select the fields to see what do you need. When you select anything in the field list, you see this field data on the report screen. Also, when you select the selection area, you will see the report input screen and fills this field or fields.

 

When you’re done to select fields, click “Execute”

 

Now fill in the fields and then click execute.

Report screen

 

By following the steps above, it is very easy to create a report that is easy to use and can be easily prepared for your business or department users.

 

Best Regards.

 

Atılay

 

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kamlesh Kumar Arya
      Kamlesh Kumar Arya

      Hi Atilay,

      Very nice document, easy to understand.

      Thanks for sharing. Keep it up!

       

      Author's profile photo Kamlesh Kumar Arya
      Kamlesh Kumar Arya

      Hi Atilay,

      Nice blog.

      Thanks for sharing.  Keep it up!

      Author's profile photo Jelena Perfiljeva
      Jelena Perfiljeva

      It’s nice of you to share but going forward please search the existing blogs first. In Google, “SQVI site:blogs.sap.com” finds this blog which has practically the same content. There are also many other blogs about different aspects of SQVI.

      But the main issue is not the redundancy. Unfortunately, what you’re suggesting is not actually a good practice or even accurate information, for that matter. By default, SQVI queries are specific to the user who created them. If someone else goes to SQVI transaction they won’t see there what you’ve just created in this blog. (If you’re writing a blog on SCN please make sure what you’re suggesting an actually be used as blog title promises.)

      SQVI queries can be either converted to “normal” queries (to be accessed in SQ01) or they can be accessed using the trick in this blog. These are rather workarounds and it should not be a regular process to use SQVI for anything other than quick (that’s Q in the name) personal use queries.

      If there is a need to create a query report for other users then it makes more sense to create it properly in SQ01/SQ02. Those transactions also offer more functionality.

      There are many SCN blogs on queries available and can be found on Google (this is a very old technology). This one is just from the top of the list: https://blogs.sap.com/2013/04/29/sap-query-user-guide/

      This one also briefly explains difference between SQVI and SQ01: https://blogs.sap.com/2012/04/18/guidelines-to-create-quickviewer-and-sap-query/