Creating Queries (SAP Library

Creating Queries

Prerequisites

You are in the initial screen of the Queries component.

Procedure

Click on the This graphic is explained in the accompanying text

Switch User Group icon to get to the User Groups dialog box. Choose the user group that you want the new query to belong to.

Specify the query name.

Note

The name of the query

can be up to 14 characters long
must appear in a user group only once

Choose

Create.

You get to a dialog box containing a list of the InfoSets that are assigned to the user group you have chosen.

For more information on creating additional InfoSets, see Creating and Changing InfoSets.

Select the InfoSet that is suitable for the new query. Choose This graphic is explained in the accompanying text

OK.

Note

There are various search functions that you can use to find the right InfoSet from a large number of InfoSets with many fields.

Find Specify the name or description of the InfoSet that you want to find The system searches list of InfoSets.
InfoSet Search Specify a field name or a table name. The system searches the list of InfoSets.

If you have chosen an InfoSet, you get to the Create Query: Title, Format screen.

Specify the required texts in the Title and the Description fields.

You might need to change the settings under the following group headers:

List format
Table format
Output format
Special attributes
Print list

Define your query in the sequences of screens designed for this purpose. Alternatively, you can use the Query Painter to define your basic list (see Creating Basic Lists with the Query Painter).

There are sequences of screens for

field selections see Field Selections

basic lists see Defining Basic Lists

statistics see Defining Statistics

ranked lists see Defining Ranked Lists

Within each of these sequences of screens, you have the following navigation options:

Click on the Next Screen and Previous Screen options to browse backwards and forwards.
Use the Back function to get to

the first screen in the sequence, if you are not already in this screen
another screen sequence, if you are in the first screen in the sequence.

The functions in the Goto menu take you directly to the individual screens in the current screen sequence or to the screens in another screen sequence.

The following diagram shows the most important navigation options.

This graphic is explained in the accompanying text

In a query, you are able to define the following:

a basic list
up to nine statistics
up to nine ranked lists

You can combine the various list types in any way that you like.

You can also add sublists to existing queries.

When you execute a query, in the list overview, you see by default the basic list first, followed by the statistics, and finally the ranked lists. You can adjust the sequence if you want to.