Procedure documentation Creating a Visual Query Locate the document in its SAP Library structure

Use

In the Visual Query dialog, you can create and save SQL statements in a number of different isolation levels.

Procedure

  1. In the user settings, select the isolation level of your SQL statements.
  2. Choose View ® Visual Query. The system opens a window for the Visual Query dialog. The window consists of the following areas:
  1. In the Catalog Manager, select the tables that you want to work with, and use the Drag&Drop function to copy them to the area of the window for selecting tables. For each of the tables copied, the system opens a window containing the names of the table columns.

Note

You can copy up to 16 tables to the area for selecting tables. To rearrange the tables, choose Visual Query ® Arrange Tables or Visual Query ® Cascade Tables. To remove a table from the table selection, close the relevant window.
  1. Select the names of the table columns that your database query relates to, and use the Drag&Drop function to copy them to the area for defining the result.

Note

By double clicking on *, you copy all table columns of a table into the area for defining the result. To remove a table column from the result definition, select the column and choose Delete Column in the context menu.
  1. You can link table columns with JOINS, enter search conditions for the data records, and define the result view.
  2. To use or edit your Visual Query again later, save it as an SQL Studio object by choosing Visual Query ® Save As.

Note

To export the SQL statement of your Visual Query dialog to the SQL dialog, choose Visual Query ® Export to SQL Dialog.