SQVI: Simplifying SAP Query Creation

​Are you looking to search Quick View (SQVI) for specific data directly from the SAP system with no programming at all and in the shortest amount of time? When you utilize SAP SQVI Query, you do not require any additional programs or servers. It is the QuickView tool is essential for functional consultants.

Thus, you can get accurate data straight via SAP Query. SAP software’s SAP Query. It is then used to generate analyses in real-time, without much effort. These analyses can be utilized to improve processes, master data, and aid in the management of corporate operations. Within the SAP ERP system, you are able to use these SAP Query capabilities without additional installation or license charges.

What is a SQVI?

The Quick Viewer(SQVI) can be described as a report Generating tool. Quick Viewer is developed for people who have little or no understanding of SAP. SAP programming language. It creates reports that are simple according to business requirements without the requirement for any ABAP code. It’s a simple and quick-to-use tool that allows quick gathering of data from SAP R/3 systems. This guide will show you how to make an individual report with the help of SQVI, the transaction.

SAP reporting tools SAP reports tools are utilized to produce reports based upon specific requirements and present data in response to the query of a client and also to create an ABAP report based on information from the system. These are the most frequently used tools for performing reporting to support the distribution and sales process:

  • QuickView
  • SAP Query
  • List and Report

A quick View is an essential tool that generates reports by simply entering data into the mySAP ERP system. mySAP ERP software, instead of writing SAP queries. This means that SAP consultants who don’t have the programming skills to write SAP queries are also able to generate reports by using this Quick View software. QuickView is a report-generating tool that can be used to create QuickViews specifically for the information for which the report will be developed. It is a QuickViewer tool that is identical to the ABAP Query, which is built using the ABAP programming language. QuickView is more effective when you require multiple tables, for instance, sets of master data to find the data you need. This way, QuickViewer helps you to gain access to multiple tables.

For the creation of a QuickView First, we must define an existing database that includes views, tables, or other data sources that allow access to information. Follow the steps below to create a QuickView by using QuickViewer. QuickView tool. We will go through steps-by-steps

After login to SAP System, enter transaction SQVI. SAP menu > Tools > ABAP Workbench Utilities and SQVI QuickViewerto begin the launch of QuickViewer.


The QuickViewer: Initial Screen appears.Enter the name of the QuickView Report (ZSALE_REP) and then click the Create button

sqvi tcode in sap
SQVI-Quick Viewer -Initials screen

It is the Create QuickView (ZSALE_REP): Choose the Data Source.It shows an image for the QuickView report that was added to the QuickViewer Initial Screen. Input the information required in the text boxes that are next to Title as well as the Data Source and Viewlabels/Tables. Within the box for text next to the Title label the text box is where we entered Test View, and in the data source box, we have chosen the Table option for the data source. It is one table or multiple tables in VBAK Sales Header and the VBAP Sales Item to access the information.

We have also selected Layout mode to be the mode for displaying information. This displays the QuickViewer Z002 layout screen. It shows how the Z002 layout is displayed.

QuickView. Beyond being able to display the QuickView in Layout Mode, it can show a QuickView when you are in the Basis mode

sap default table join sqvi viewer
SAP SQVI Query Creation
sqvi layout mode
SQVI layout mode

There are two methods to continue from this page. “Basic Mode” or “Layout Mode” are the options. Basic Mode employs GUI kind of screens to which SAP is well-known. However, Layout Mode has a little more of a visual interface. I like to begin with Basic Mode get things set up according to how I would like them to be, and later switch over into Layout Mode for final touches when needed.

SAP SQVI: Choose Data Source
SAP SQVI: Choose Data Source
SAP SQVI : Join Table & Conditions
SAP SQVI : Table Join

SAP automatically creates join conditions based upon the fields within every table. This seems like a good idea, but many times joining conditions can be not correct and if they are not rectified, the query will not function in a correct manner.

In our example, the upper join of the VBELN fields is right as this is the primary key in both tables VBAK and the ABAP. Because of a wrong join condition, Query is not functioning correctly at times.

It is something to keep an eye on when joining tables with Quick Viewer.

 SAP SQVI : Join Conditions
SAP SQVI : Join Conditions

In this next step, we’ll choose the fields we wish to include in the query, and the fields we would like to select in the initial screen of selection. On the left side of the screen, you’ll see the tables you have just completed joining. Open the table that is on top.

Choose the fields that you would like to include in the report, as well as the fields that you intend to select on the initial screen. After you have completed the first table, repeat the process for the second table.

SAP SQVI: Quick Viewer Field selection
SAP SQVI: Quick Viewer Field selection

List FLD. select-Gives information about different fields. For the display of fields as a table format, you can include the fields in the field available section to the Fields in List section.

  • Sort sequence– Gives information about the fields sorted in relation to ZSALE_REP QuickView.
  • Selection fields– Provides information about the fields of selection using the ZSALE_REP QuickView.
  • Data Source– Offers information related to the data source, like views or tables, to choose the data.
image 18

It is also possible to send the results from a QuickView to other sources, like Microsoft Excel or Word, to further analysis. The QuickView results include the name of the QuickView as well as the title and fields that will be presented in the format of a list. Additionally, to, the QuickView results contain the data source for the QuickView results, like master customer records. Based on the requirements for the SAP user The QuickView results are exported in a variety of formats.

SAP SQVI: Output Exports setting
SAP SQVI: Output Exports setting

Before any report is produced, it is crucial to save and generate an SQVI query.Close/save your report by pressing the Close button.

 SAP query Infoset
SAP query Infoset

It is now time to run the query. Choose the name of the query and click Execute Icon.

image 21

New Sales Reports Outputs with ALV reports made .which permits you to download in the same format. A report will be displayed and will include some fields.

How do I run SQVI?

how to use sqvi
How to use sqvi
Report extraction
Report extraction

How do I create a Tcode for SQVI query in SAP?

Go to SE93 to Creating Dialog Transaction for New Transaction code .Maintain the zee code you want and click Create

Maintain Transaction Codes
Maintain Transaction Codes

Maintain a short text relevant for Customized new Transaction code .& Select the button “Program and selection screen (report transaction)

Create New Transaction Codes
Create New Transaction Codes

Maintain TCode text and the relevant program name & Screen number & Maintain tick for all under the tab “GUI support”

Create Dialog Transaction
Create Dialog Transaction

Here are a few more articles you might be interested in reading.

Leave a Comment


Enjoy this blog? Please spread the word :)