Procedure documentation Defining the Result View Locate the document in its SAP Library structure

Use

In the Visual Query dialog, you can specify how SQL Studio displays the result of your database query.

Prerequisites

When you created the Visual Query, you copied the table columns that your database query relates to into the area for defining the result.

Procedure

  1. To assign a synonym for a column name, enter the required synonym name in the field Synonym, and confirm with Enter.
  2. To hide a column in the result view, set the entry to No by double clicking on the field Visible.

Note

This is particularly useful if you only need the column in order to formulate search conditions.
  1. To group the result by column values, set the entry in the field Group by double clicking on Yes in the column that you want to use for grouping.

Note

You can use this grouping feature to define average values, maximum values, minimum values, totals, and the number of found data records in the result view.
  1. To sort the data records in ascending or descending order, in the field Sort select Ascending or Descending in the column that you want to use for sorting, and confirm with Enter.