Entering content frameProcedure documentation Creating New Queries Locate the document in its SAP Library structure

Use

With the InfoSet query, you can use a variety of selection and output fields to define data analyses and to allow them to display results lists. You can repeat this process as often as you like. You do not require programming skills to create reports using the InfoSet query.

You can also save queries, make queries you have saved available for other users to use, and transport queries, providing you have the relevant authorization.

Prerequisites

You are in the InfoSet query screen. Depending on how you have started InfoSet query,

Procedure

  1. In the column Selection, select the relevant selection fields and, if necessary, remove the selection fields you do not need by clicking the relevant check box.

    2. The system transfers the selected fields to the selection field list. The selection fields that you have removed are no longer in the list.

  2. In the column Output, select the relevant output fields and, if necessary, remove the output fields you do not need by clicking the relevant check box.

    3. The system transfers the selected fields to the output preview. The output fields that you have removed are no longer in the output preview.

    Note

    You can also add the fields to the relevant area (selection or output area) using Drag&Drop. If you use Drag&Drop, you can insert the fields directly into the correct position in the output preview.

    Depending on the default settings, fields with texts have only their text or their value transferred when you select them by ticking the check boxes or by using Drag&Drop. However, you can also select fields by using the context menu of the relevant field. Here you can choose whether you want to use the value, the text, or both.

  3. Enter the relevant selection values for the selection fields in the column Value.

    4. The value types (numeric, alphanumeric, date) that you can enter for the selection fields depend on the type of selection field.

  4. In the Options column, choose selection options (such as < or =).
  5. To execute the query, choose This graphic is explained in the accompanying text or This graphic is explained in the accompanying text Output.

Result

The query is executed. If you started it by choosing This graphic is explained in the accompanying text, the results list is displayed in the lower part of the screen. If you started it by choosing This graphic is explained in the accompanying text Output, the results list is displayed in full screen.

Caution

The default output works in the standard setting such that no selection screen is displayed, and the specified selections are taken into account when outputting. You can change the standard settings (see Settings).

You can save the query, if you are authorized to do so.

You can find more information under Saving Queries, Reporting Type, and Rights to Access the InfoSet Query.

 

 

Leaving content frame