Manage Learn to apply best practices and optimize your operations.

Chapter 20: 'Reporting tools in SAP'

Get a crash course in the most common SAP reporting tools; SAP Query, InfoSet Query, Ad Hoc Query and QuickViewer. This chapter will teach you to easily configure tools, create basic and advanced reports, run Ad Hoc queries and create QuickViews.

Chapter 20: 'Reporting tools in SAP' Excerpted from the book "Teach Yourself SAP in 24 Hours, 2nd Edition," ISBN...

0672328224, Copyright 2006. Written permission from SAMS Publishing is required for all other uses. Copyright © 2006 SAMS Publishing. All rights reserved.

Chapter Excerpt:


Understanding the QuickViewer

Unlike the SAP Query, which is a complete reporting solution tool, the SAP QuickViewer Tool delivered with a 4.6 system is a "what-you-see-is-what-you-get" utility for quick collection of data from your R/3 system. To define a report with the QuickViewer, you simply enter texts (titles) and select the fields and options that define your QuickView. Unlike with SAP Query, whereby you create queries, you create QuickViews. QuickViews are not queries and they cannot be exchanged among users. The good news is that they can be converted to queries to be used with SAP Query.

Like with the InfoSet (Ad Hoc) Query, you can use the QuickViewer to quickly answer simple questions.

By the way:
In contrast to using SAP Query and InfoSet (Ad Hoc) Query, you do not need to configure User Groups and InfoSets to use QuickViewer. However, if they have already created, you can use them. Users simply select a data source (table, database view, table join, logical database, or InfoSet) when building their QuickView.

Like SAP queries, InfoSet (Ad Hoc) queries are built on the foundation of Query Areas, Query Groups, and InfoSets. Earlier in this hour, you created an InfoSet based on the test logical database F1S, which corresponds to SAP's test system. You can use the same data source used in earlier examples for creating a QuickView or you can create a new InfoSet using an HR logical database. The following example uses the one created earlier in the chapter.


Creating a QuickView

After the one-time configuration is completed, Creating a QuickView is also a relatively elementary task. To begin creating your first QuickView, follow these steps:

  1. Like the SAP Query explained earlier, QuickViews can be run in Basis or Layout (Graphical) mode. In Basis mode, the system automatically renders the report from parameters. In Graphical mode, a user can tweak the report's interface via a visual tool. Like the SAP Query, QuickViews are easier to work with in Basis mode.

  2. You can access SAP R/3 QuickViewer in three ways: by using transaction SQVI, by using the QuickViewer button on the main screen of the SAP Query (transaction SQ01), or by using an application-specific role from the Easy Access menu.

  3. On the main screen, enter a name for your QuickView followed by the Create button. You will be prompted to select a data source. For this example, I use the F1S data source.

  4. There are three main tabs that you use to specify your QuickView.

  6. The first tab is your list of output fields. Simply select fields listed in the Available Fields column and select the arrow keys to move them to the output column. The second tab enables you to dictate the sort sequence for your selected fields. The third tab enables you to indicate selection fields for specifying your final output.
  7. Note in the middle of the screen that you have different Export options for your QuickView. Select one from the drop-down box and then select the Execute button to see the Reports Selection screen. You can further specify your selections. Next, select the Execute button to see your completed QuickView.

Chapter 20: 'Reporting tools in SAP'

Visit the SAMS Publishing website for a detailed description and to learn how to purchase this title.

Dig Deeper on SAP analytics software

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.