Chapter 7: 'Creating advanced reports with the SAP query tool'

Once you have a handle on the basic report structure, you'll probably want to kick it up a notch with more specialized reports for your organization. This chapter explains the tools and functionalities you can use to create good reports for a variety of levels, departments and output formats.

Download chapter 7: 'Creating advanced reports with the SAP query tool'

Excerpted from the book "SAP Query Reporting," ISBN 0672329026, Copyright 2006. Written permission from SAMS Publishing is required for all other uses. Copyright © 2006 SAMS Publishing. All rights reserved.

Chapter Excerpt:

The SAP Query tool, in its standard form, is designed so that an end user who has no technical skills can create a report from scratch. It has five basic screens that you can utilize to create a report. In addition to the five basic screens, seven advanced screens give you more options and functionality when creating reports with the SAP Query tool:

  • Control Levels—You use this screen to add subtotals to a report. SAP uses the term control level to indicate subtotals.

  • Control Level Texts—You use this screen to change subtotal texts.

  • List Line Output Options—You use this screen to format the list line.

  • Field Output Options—You use this screen to alter the column widths, add colors, hide leading zeros, and create templates.

  • Field Templates—You use this screen to insert text to appear before output for each line.

  • Basic List Header—You use this screen to create custom headers and footers.

  • Graphics—You use this screen to create graphics (such as charts and diagrams).

This section explains the functionality available on each of the advanced screens in the SAP Query tool. I’ll use an SAP Human Capital Management (HCM) query report, DLS_Query_07, to display the impact that each of these advanced screens can have on an SAP query report. If you want to follow along on your own system, you can do so by selecting any existing SAP query from your list or creating one from scratch. You will want to have at least a half dozen fields in your output, including a combination of text fields and number fields (for example, Last Name and Age of Employee; see Figure 7.1)

To navigate to the advanced screens of the SAP Query tool, you begin by navigating to the Queries from User Group: Initial screen by using the transaction code /nSQ01. You select one of your existing queries by selecting the gray tab to the left of the query or by typing the query name into the top of the screen in the SAP Query entry box (for example, DLS_Query_07). Then you click the Change button to get to the first screen of the SAP Query tool (that is, the Title, Format screen). To navigate to the advanced screens, you have a couple of options:

  • Click the Basic List button on the Application toolbar and then click the Next Screen button (that is, the white navigational arrow) on the Application toolbar.

  • Use the toolbar menu Goto, Basic List and then select one of seven advanced screens to jump directly to it.

In SAP terms, there is no real distinction between basic and advanced screens. I have coined these terms to make it easier for you to implement, teach, and use the SAP Query tool at your organization. After years of teaching the SAP Query tool, I found that it was helpful for users to first learn and master the five basic screens before moving on to these screens.

Chapter 7: 'Creating advanced reports with the SAP query tool'

Visit for a detailed description and to learn how to purchase this title.

Dig Deeper on SAP development and programming languages