Format Output 

You can format the output list before output. The output preview includes the following functions:

Function

Procedure/icon

What you need to know

Sort ascending

Sort descending

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

You can use several sort criteria.

To do so, do not select a column, and then choose or . This takes you to the Define Sort Order dialog box. You can select output fields as a sort criterion as required, and determine whether the sort performed in accordance with this criterion is ascending or descending.

  

Total

Select the required column, and choose .

A total is output at the end of the column.

You can only create totals 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 output.

You can only use columns as a criterion for subtotals if they contain non-numerical values. The list is automatically sorted in accordance with 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 all output fields

Choose .

Use this function if you want to reuse the selection fields but require different output fields.

Initialize formatting

Choose .

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

The column sequence and output type are not reset.

Determine output type

Use the list to choose the type of output required, for example:

  • Interactive list
  • Word processing
  

Change column sequence

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

  

Output / do not output currency or unit

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

To change the position of this column, choose the following in the context menu of the value column:

Currency ® Before the value or After the value

Unit ® Before the value or After the value

 

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

Currency ® Do not output

Unit ® Do not output

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

If you want to enter a reference currency to which all currency fields are converted, choose Edit ® Define output.

Enhance statistics

You can enhance statistics with the following columns:

  • Mean values
  • Percentage-based distributions
  • Number of processed data records

In the context menu of the value column, choose Output mean value, Output share in %, or Output total number.

These enhancements are only possible for numerical columns.

 

The various output lists include further options to enable you to edit output. For more information on how to edit output lists, see Interactive List Display Functions and Interactive Functions for Further List Processing. For more information on how to output data as an interactive list, see ABAP List Viewer (ALV): Grid Control.