Show TOC

Creating and Executing a QuickViewLocate this document in the navigation structure

Use

You can use a QuickView to display information from different data sources. An InfoSet is not necessarily required to create a QuickView; the data can be directly read from a selected table, a table join, or a logical database instead. QuickViews are therefore the simplest way to quickly display data from a particular source.

Before you can create an execute a QuickView, the following basic prerequisite must be fulfilled (usually by the system administrator):

Prerequisite: You have the appropriate authorization

  • To execute a QuickView, you require authorization for transaction SQ01 or SQVI.

  • To be able to read data from specific data sources, you need authorizations for these sources.

If you do not have the authorizations you require, contact your system administrator.

Procedure

  1. Call transaction SQ01. The SAP Query initial screen appears. This screen shows a table of all queries that have been created and stored for your user group. To generate a QuickView, choose the QuickView button on this screen. You can also call the initial screen of the QuickViewer by calling transaction SQVI.

  2. If you want to execute an existing QuickView from the table displayed, select the QuickView and choose the Execute button. A new screen appears, on which you should fill out the input ready selection fields and then choose the Execute button (F8) again.

  3. If you want to create a new QuickView, enter a name for it and choose Create.

  4. A new dialog box appears, in which you should enter additional information about this QuickView. In the second step of this dialog, you select the type of data source.

    Table

    Enter the name of the database table.

    Table join

    After you have confirmed the dialog step, another screen will appear, on which you can create the table join. Use the Insert Table button to select at least two database tables, from which you want to create the join. Then exit this dialog by choosing the Back button.

    Logical database

    Select a logical database. The examples in the SAP Query document relate to the logical database F1S.

    SAP Query InfoSet

    You can also execute the QuickView on an existing InfoSet. To do this, select the required InfoSet. Note that, to use an InfoSet, you must be assigned to an authorized user group.

    Finally, define the display mode in which you want to structure the query. The contents of the displayed data will not change. Therefore select the mode that is better suited to your purposes. Confirm the create dialog.

  5. On the subsequent screen, select:

    1. Which fields of the data source are to be used for the selection of the values (selection fields)

    2. Which fields of the selection result are to be displayed in the list (list fields)

    This is displayed differently for each of the display modes: While in Basis mode, the list fields and selection fields are distributed over two different tab pages, in layout mode, they are organized in a tree structure at the left of the screen. More information about the different modes: QuickViewer.

    Example

    You want to display all available flight connections from database table SPFLI, depending on the departure city and arrival city. Choose the fields Departure city and Arrival city as selection fields. Choose, for example, the fields Departure airport, Destination airport, Departure time, and Arrival time as list fields.

  6. After selecting the selection fields and list fields, choose the Execute button (F8).

  7. The system automatically displays the selection screen, on which you can now fill the input-ready fields with selection values. Choose Execute (F8) again. The relevant list fields are displayed in a table.

    Example

    For the selection Departure city, you have selected/entered the value Frankfurt, and for the selection Arrival city, the value New York. The output is a list of all flight connections maintained in table SPFLI between these two cities.

  8. Before you exit the QuickViewer, you have the option of storing the QuickView that you have just created. This means that it will be available to you again, when you log on to the system later.

QuickViews are user-dependent. You can always execute only your own, stored QuickViews again. However, if you want to make QuickViews available to a larger group of users, you can generate SAP Queries from them.