Create Statistics Lists in SAP Query for a Summarized Analysis of Your HR Data
- by Danielle Larocca, Senior Vice President, Human Capital Management, EPI-USE Labs
- July 15, 2006
Follow these steps to create a statistics list using SAP Query in SAP HR. You can use a statistics list to summarize data and create totals and averages.
You can create three types of reports with the SAP Query tool: basic lists, statistics lists, and ranked lists. The most common type of SAP Query report is a basic list report that displays individual line-item data across the columns of the report. The data displayed in a basic list report may contain an overall total at the bottom but is often not auto-summarized to display summary detail only. Generally speaking, the system displays data as it appears in the R/3 database. In contrast to basic lists, the data in statistics lists is output in a compressed, summarized format. A ranked list places items in order and ranks them in terms of highest to lowest or vice versa.
SAP Query, the most robust reporting solution delivered with SAP R/3 for end-user reporting, is most widely known for its basic list style of reporting. However, it can do more than create basic lists. I will explain how you can use it to produce statistics lists, including summary analyses of data with totals and averages. The only technical requirement for creating statistics lists in SAP is using SAP Query.
SAP Query statistics lists are ideal for analyzing average rate of pay for all associates by cost center. Instead of viewing a list of all associates in the cost center and their rates of pay, you can use statistics lists to view the averages by cost center. It is also helpful to view the total number of new hires in a yearly comparison. In other words, you can make a simple report that compares the total number of associates hired in 2004, 2005, and 2006.
To gain a better understanding of what a statistics list is all about, review Figure 1. It shows an example of a basic list report that you can create in SAP Query. This basic list gives line-item details of the salaries for associates in various organizational units. If you want to calculate the average annual salary of associates by organizational unit you can use a statistics list (Figure 2).
I’ll explain the steps to create your own statistics lists in SAP Query. You need to have access to SAP Query. If you have already been using SAP Query to create basic lists, then creating statistics lists requires no extra configuration.
Would you like to see this full item?