SAP: make you own queries with Quick Viewer (transaction SQVI)

For sure, many times, you needed to search data in certain tables, by combining them at the same time. Perhaps you downloaded the tables to an Excel file and obtained the data you needed by using some specific formulas in your spreadsheets.

Well, to avoid this, you have the SQVI transaction, that allows to make your own reports for one or more tables at the same time.

Have a look to see how it works! Let′s do an easy example first. Suppose you want to list all vendors from a specific country. First of all, you need to know which table to use. For our example the table is LFA1.

Access transaction SQVI, give your report a name and press the “Create” button.

Give your report a Title, a Description, select the table you want and press the “Enter” button.

Select on the first tab which fields you want to see in your report. For our example we select from the right column the fields “Country Key”, “Name 1” and “Postal Code” and press the “Arrow to the left”, so these fields are available for the report, by being displayed on the left column. You may also press “SHIFT + F5” to see the technical names for the fields instead of their descriptions.

Select on the second tab the sort order. Mark the fields you want and choose the desired criteria. In our case we will order the vendor by their names.

On the third tab you must define the selection fields. Choose from the right column the fields you need. You may also change the order in which they may appear later on the transaction.

Once you are ready with the 3 tabs, press the “Save” button.

Then press the “Execute” button.

You will see a screen, like one from a standard program, but with your own description and specifically for the fields you have defined. For our example we select a specific country and press the “Execute” button.

Now, you see the result! The specific list that you were looking for is now available!

Easy, right? Well, let′s do a more complex example. We will choose 2 tables now, instead of just one. We will combine tables LFA1 and LFB1, to obtain General Data and Company Specific Data for vendors.

For this, create a new Quick Viewer, like before, but when you define now the characteristics, select for “Data Source” the value “Table Join” instead of “Table”.

You will access a new screen, where you need to enter the tables and their connections between each other. Hit on the “Insert Table” button and enter the first table.

Select then the second table.

You will see now how both tables connect to each other. Key fields with the same characteristics (like vendor number in our case) are automatically proposed, but you may change the connection fields if you need.

Now, go back with the green arrow and define, like before, the data for the first, second and third tab. You will see now, that you have both tables available and not just one for all the three tabs.

Tab 1 (fields to appear on the report):

Tab 2 (sort order):

Tab 3 (selection fields):

Now, save your selection and execute the program. You will see as the selection fields, the fields you have chosen from both tables. Enter the parameters you need and execute the program.

And here it is!!! The report you needed, with information from 2 or more tables is here!

The best think is that since you saved your report, you can run it as many times as you want, by accessing transaction SQVI and selecting the specific report. I hope this helps!

Adrián Wilder (www.infoaval.com). 

Follow me on Twitter for more Tips and Tricks: @adrianwilder