Use
The following example demonstrates how to define a ranked list.
Prerequisites
You are assigned to a user group, QD, for example.
Procedure
Example scenario: You are looking for the 10 flights with the most free seats in economy.
This is necessary, since one query can contain several ranked lists.
The default is 10.
Entries in ranked lists with the same value for the ranked list criterion are always given the same ranked list number (first column). The ranked list number is only displayed at the first entry. It may be that more rankings are displayed than have been determined in the ranked list definition. This is the case when entries with the same ranked list criterion values occur at the end of the ranked list. In this case, all the entries found that fulfill this same criterion are displayed.
To do this, type sequence numbers in the first column. You must select one of these fields as the ranked list criterion. In our example, this is the Occupied Seats Economy Class field.
Result
A ranked list is displayed containing the 10 flights with the least occupied seats in economy class.
Additional Functions
Ascending
The ranked list criterion is the sort criterion of the ranked list. The default sort sequence for the sort criterion is descending order, but ascending order is sometimes necessary. This would apply, for example, to vendor sales figures which are stored as negative amounts. In these cases, you select the Ascending (Asc.) column to set the sort direction for the ranked list.
Output length
You can specify an output length (Lngth: only for ABAP lists) and a rounding factor (Round.). As with statistics, you have to specify reference currencies and reference units for currency fields and quantity fields. All the amounts that are read are converted into these reference currencies or reference units. The procedure for conversion errors is also the same as it is for statistics (see
Analyzing Conversion Errors).Lead columns
All ranked lists contain lead columns. They are determined by the query itself. The Key color attribute is assigned automatically to all non-numeric fields. When you scroll horizontally, these fields always remain visible on the screen.
Headers and parameters for graphics
As with statistics, you can access the screens for maintaining headers and setting parameters for graphics by following the normal sequence of screens.
Next ranked list
Choose the Next Ranked List function if you want to define another ranked list.