Entering content frameProcedure documentation Formatting the Output Locate the document in its SAP Library structure

Use

You can format the output preview in the InfoSet Query screen. When you execute the query, the formatting applies to the output list display in the InfoSet Query screen and to the output in the full screen.

Procedure

You can use the following options:

Function

Procedure/Icon

What you need to know

Sort ascending

Sort descending

Select a column, and sort ascending by choosing This graphic is explained in the accompanying text or descending by choosing This graphic is explained in the accompanying text.

You can use several sort criteria.

You don’t need to select a column, choose This graphic is explained in the accompanying text or This graphic is explained in the accompanying text. 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 This graphic is explained in the accompanying text.

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 This graphic is explained in the accompanying text.

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 This graphic is explained in the accompanying text.

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

Initialize Formatting

Choose This graphic is explained in the accompanying text.

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 This graphic is explained in the accompanying text.

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
  

Colors

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.

The various output lists include further options to enable you to edit the 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 in the SAP List Viewer, see Structure linkSAP List Viewer (ALV): Grid Control.

 

 

Leaving content frame