Show TOC

Creating Ranked ListsLocate this document in the navigation structure


The following example demonstrates how to define a ranked list.


You are assigned to a user group, QD, for example.


Example scenario: You are looking for the 10 flights with the most free seats in economy.

  1. Use the DEMO_FLBOOKING (flight bookings) InfoSet to create a query (Query R1).

  2. Use the function to get to the Field Group Selection screen, and activate the checkboxes for the Flight Plan and Flight Table field groups.

  3. Use the function to get to the Field Selection screen, and activate the checkboxes for the Airline Carrier ID, Flight Connection ID, Flight Date, Maximum Capacity Economy Class, and Current Bookings Economy Class fields.

  4. Click on the Ranked List pushbutton to switch to the Ranked List screen.

  5. Give the ranked list a title.

    This is necessary, since one query can contain several ranked lists.

  6. Specify how many entries (rows in the display) you want the ranked list contain.

    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 can come to pass that more rankings are displayed than are allowed in the ranked list's 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.

  7. Specify the fields that you want to display and the order in which you want to display them.

    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.

  8. Use the Test function to test the query.


A ranked list is displayed containing the 10 flights with the least occupied seats in economy class.

Additional Functions

  • Ascending Asc

    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 Len

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