Skip to Content
Technical Articles
Author's profile photo Sumit Holey

SQVI Reporting | Easiest and Fastest Way to Create Reports Without Technical Skills.

Hello Everyone,

Although ABAP programmers are typically credited with creating custom reporting, this may not necessarily be the case for straightforward and general reporting that isn’t heavily dependent on calculations.

SAP has a robust reporting tool that anyone, regardless of technical proficiency, may utilize to easily create reports.

Go to transaction SQVI

  • Give Viewname anything you want
  • Click on Create
  • Give the Title
  • Provide data source as Tabel Join
  • Click on Tick to move to the next step

Various Possible Data Sources:

Tables (Single or connect): To get data, you can pick individual tables or connect multiple tables together. This approach is appropriate when you need to directly extract data from specific tables.

Infosets: Infosets allow you to construct a customized view by combining tables and fields from various SAP modules. They allow you to connect similar tables and extract data based on your individual requirements.

QuickViews are pre-defined data sources provided by SAP for typical reporting scenarios. These are reusable data sources that have been performance optimized. If it meets your reporting needs, you can choose a QuickView.

For preparing reports in SAP SQVI, there are two options: Basic Mode and Layout Mode.

SQVI’s Basic Mode provides a simplified interface for preparing simple reports that lack complex formatting and style options. It is appropriate for users who need to extract data from SAP tables rapidly and generate basic reports. You can select data sources, specify selection criteria, and customize the display fields for your report in Basic Mode. However, formatting, sorting, and layout customization capabilities are limited as compared to Layout Mode.

SQVI’s Layout Mode provides more extensive options for preparing reports with greater formatting and layout features. It has a full range of tools for defining the report structure, such as field formatting, sorting, grouping, subtotal calculations, and others. You have more control over the visual presentation of the report with Layout Mode, and you can customize the design and structure to meet your individual needs. It enables you to produce more sophisticated reports with a more professional appearance and feel.

To switch between Basic Mode and Layout Mode in SQVI:

  1. When creating a new report or editing an existing one, you will initially be in Basic Mode.
  2. To switch to Layout Mode, click on the “Layout” button in the toolbar.
  3. The interface will change, providing additional options for formatting and layout settings.
  4. In Layout Mode, you can define the report structure, customize field properties, apply sorting and grouping, and set up subtotals and other advanced features.
  5. If you want to switch back to Basic Mode, click on the “Basic Mode” button in the toolbar.

Note that Layout Mode offers more extensive capabilities and flexibility for designing complex reports, while Basic Mode provides a streamlined approach for quick and straightforward reporting needs.

You will redirect to the next screen, there click on Add Table button as shown

Add as many database tables as you required considering Key Feilds

To illustrate I am adding 2 tables i.e MARC and T001W for material, Plant, and Plant Address

Click on the Back button, and you will redirect to the next screen for List Field selection for Output Screen and Selection screen for the Input screen

Highlighted fields are selected for output

In the selection fields ( Input Screen) field has been added

Click on save and go back to SQVI, select the newly created view, and click on Execute

Your work is done, Give the input and get the output

Input Screen:

Output Screen:


SQVI is a basic query tool in SAP that enables you to choose a data source, define selection criteria, and layout for ad-hoc reports. The report can be run, with the option to export it or analyze the results on-screen. You may store and reuse report definitions using SQVI.

For more articles like these, kindly like, share, follow, and leave comments.

LinkedIn :

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Rainer Lindemann
      Rainer Lindemann

      True, vastly underused in most places I've been. Thanks for bringing it up.

      Being the killjoy that I am, though, I think that some substantial drawbacks need to be addressed:

      • Query and Quick Viewer will bypass any and all functional authorization checks. So, unless you have a very solid authorization concept that also covers direct table access (with restrictions on S_TABU_DIS, S_TABU_NAM and the likes), this will tear a massive hole in your data security
      • when dealing with large tables, suboptimal selection conditions and (even worse) table joins will bring your system to a standstill. I've seen an entire ERP system brought to a stop through badly made queries.

      The first issue can be addressed, to some extent and with substantial work. As for the second... that's harder. But for anybody interested, I'd like to recommend "Workshop SAP Query" by Nico Manicone, he shows how to deal with these challenges.