Comparing the Query Tools to Decide Which to Use

As described earlier in this chapter, in version 4.6C and above of the SAP R/3 enterprise solution, SAP delivers the following Query tools: the SAP Query tool, the InfoSet (Ad Hoc) Query tool, and the QuickViewer. Each of these tools has a different purpose.

The best end user reporting solution is the SAP Query tool, because it has the broadest range of features, is very easy to use, and can be used to create complex reports with no programming skills whatsoever. Because this tool is the most robust, it is often used by power users, functional and business analysts, and savvy end users. The InfoSet (Ad Hoc) Query and QuickViewer tools are often used by a casual user performing a single lookup or inquiry.

You should select a tool for primary and exclusive use by your organization and train your end users on it. That way, you avoid any possible data inconsistencies due to the use of different or multiple tools. I always recommend the use of the SAP Query tool above all other tools because it has the most features and flexibility. The SAP Query tool has the most coverage in this book. Throughout this book, you will learn about each of the SAP R/3 Query tools and will be able to decide for yourself which is an appropriate fit for your organization.