Formatting the Output

Sort ascending

Sort descending

Select a column, and sort ascending by choosing or descending by choosing .

You can use several sort criteria.

You don't need to select a column, choose or . The Define Sort Order dialog box appears. You can select any output fields as a sort criterion, and decide whether to sort according to this criterion in ascending or descending order.

Total

Select the column you want, and choose .

A total is outputted at the end of the column.

You can create totals only for columns that contain numerical values.

If you also want to output subtotals, you must first create totals using the numerical column.

Subtotals

Select the column that contains the criterion for subtotals, and choose .

If the criterion for subtotals changes, a subtotal is outputted.

You can use columns as a criterion for subtotals only if they contain non-numerical values. The list is automatically sorted according to this criterion.

If you report on the annual salaries of your employees, for example, you can create totals for the Annual Salary column and output a subtotal for each organizational unit.

Delete Field(s)

Select the column you want to delete from the output list.

Choose .

If you do not select a column, this function deletes all output fields.

Initialize Formatting

Choose .

Resets output formatting to its original state. Use this function if you no longer need to create subtotals or totals.

The column sequence is not reset.

Update data

Choose .

The query is executed and the results list is displayed in the lower part of the InfoSet Query screen.

After the query has been executed, you can use the ALV functions from the output on the InfoSet Query screen, for example, Excel Inplace display or the export for text processing programs.

If you change the output list in such a way that a new selection must take place (when you add a new field, for example,) you see the example dates in the output list again. You need to re-update the data so that the query is executed again.

Change Column Sequence

Select the column whose position you want to change, and use drag & drop to move it to the required position.

Output / No Output Currency or Unit

In the basic list, currencies or units are automatically outputted in an additional column after the value column.

Choose the following in the context menu of the value column, to change the position of this column:

 Currency  Before the Value  or After the Value

 Unit  Before the Value  or After the Value

Choose the following in the context menu of the value column, to prevent the currency or unit column from being output:

 Currency  No Output 

 Unit  No Output 

An additional column for currencies or units is not outputted in statistics or ranked lists.

Choose  Edit  Settings  on the tabstrip Statistics/Ranked List if you want to enter a reference currency to which all currency fields are converted.

Enhance Statistics

You can enhance statistics with the following columns:

• Mean values

• Percentage-based distributions

• Number of processed data records

  Choose Output Mean Value, Output Share in %, or Output Total Number in the context menu of the value column.

These enhancements are only possible for numerical columns.

Rounding

Select a column containing the numerical values and choose Rounding from the context menu.

You have the following options:

• Display value unchanged

• Value in tens

• Value in hundreds

• Value in thousands

• Value in ten thousands

• Value in hundred thousands

• Value in millions

• Value in ten millions

• Value in hundred millions

• Value in thousand millions

Color

Select a column and from the context menu, choose Color.

Dark blue has a special significance as a color for a key. Its effect is that, when scrolling horizontally, the dark-blue column and all columns to the left of it remain fixed. When scrolling horizontally, only columns to the right of the dark blue column move.

All other colors are used to denote a column. The color definition corresponds to the SAP standard – for example, lighter yellow for a subtotal, darker yellow for a total.