Statistics Lists in the SAP Query Tool

Statistics lists allow you to produce summary analyses of data, including totals and averages. Statistics lists are similar to pivot tables in Microsoft Excel. To give you a better understanding of what a statistics list is all about, Table 12.1 shows an example of a basic list report from the HCM module that contains a report of some of the associates in the Mama Tricarico's company, used in earlier examples. This chapter compares this basic list to a statistics list to show the difference between the two.

Table 12.1. Day Shift Associates of Mama Tricarico's in SAP HR Module in Basic Report List

Last Name	First Name	Employee Group	Employee Group Text	Position Title	Hourly Rate	Shift	Personnel Area
Beato	Nicholas	1	Active	Menu Designer	$8.50	1	3640
Lariosa	Michael	1	Active	Chef	$14.50	1	3011
Layden	Stephanie	2	Leave	Waitress	$4.25	1	3640
Whalen	Kristen	1	Active	Hostess	$6.50	2	3866
Kaupp	Nicole	1	Active	Waitress	$5.65	1	3640
Hanna	Sherin	2	Leave	Pot Washer	$5.00	1	3640
Pearce	Brad	1	Active	Waitress	$5.65	1	3640
Brunsman	Kelly	1	Active	Waiter	$4.25	2	3591
Lewis	Nicolle	1	Leave	Chef	$16.50	2	3841
Whalen	Kylie	3	Terminated	Waitress	$4.25	2	3011
Count	= 10			Total	$75.05

Using this report as an example, you can create a statistics list that summarizes the information. For example, you can create a statistics list that shows the average hourly rate for each personnel area (see Table 12.2).

Table 12.2. Statistics List Example

Personnel Area	Count	Average Rate
3011	2	$9.38
3591	1	$4.25
3640	4	$4.68
3841	1	$16.50
3866	1	$6.50