Show TOC

 Creating Ranked Lists

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.

  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.

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

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

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

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

  10. 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 S eats Economy Class field .

  11. Use the Test function to test the query.

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.