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
Requires Free Membership to View
When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.
Hannah Smalltree, Editorial Director
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:
- 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.
- 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.
- 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.
- There are three main tabs that you use to specify your QuickView.
-
- 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.
- 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.
This was first published in April 2007
Join the conversationComment
Share
Comments
Results
Contribute to the conversation