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.
Key Concept

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.

Danielle Larocca

Danielle Larocca is currently the Senior Vice President of Human Capital Management for EPI-USE Labs. Previously she was the Executive Vice President of Operations/Chief Knowledge Officer at a technology start-up. She has more than 20 years of strategic leadership experience in multi-national business, business process re-engineering, and project and people management. Danielle is an expert on SAP Human Resources (HR) and reporting and has authored four best-selling books on SAP. She is a regular speaker at numerous conferences around the world on topics such as HR, technology, change management, and leadership. She is an official SAP Mentor, a global designation assigned to less than 160 professionals worldwide, who serve as influential community participants in the SAP ecosystem. This group is nominated by the community and selected by the SAP Mentors’ Advisory Board to keep SAP relevant. Danielle also serves as an expert advisor for SAP Professional Journal.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.