Entering content frameProcedure documentation Creating Basic Lists with the Query Painter Locate the document in its SAP Library structure

Use

Before it is able to create a new query, the system needs information that enables it to generate the corresponding report. The following information is required:

Prerequisites

You are in the initial screen of the Queries component.

Procedure

Proceed as follows to use the Query Painter to create a basic list:

  1. Use the Switch User Group This graphic is explained in the accompanying text function to select the user group, to which you want the new query to belong.
  2. Specify a name for the query.

    3. Note

    Query names are a maximum of 14 characters in length. The name of the query must be unique, that is there must not be a query with this name in the user group already.

  3. Choose the Create This graphic is explained in the accompanying text function.

    4. A list of InfoSets belonging to the user group is displayed.

  4. Select the InfoSet appropriate for your query and click on This graphic is explained in the accompanying text.

    5. You are taken to the Create Query: Title, Format screen.

    To find out how to create InfoSets, see Creating and Changing InfoSets.

    Note

    If there are a lot of InfoSets with many fields assigned to one user group, use the search function to find the InfoSet you need. You can search for any term within the selected InfoSets. The result is a list of all the InfoSets and fields that match the search criterion.

  5. Type the appropriate information into the dialog fields.
  6. Choose Settings ® Settings to specify that you want to use the Query Painter to define the basic list.
  7. In the Settings dialog box, activate the Graphical Query Painter check box and click on This graphic is explained in the accompanying text.

    8. The Settings dialog box closes.

  8. Click on the Basic List pushbutton to open the Query Painter. You can select the fields you want from the Query Painter directly,.

Alternatively, choose Next Screen This graphic is explained in the accompanying text, and choose the fields that you want to use to build your query before you start the Query Painter. This procedure is useful if you want to define local fields.

Note

Defining local fields allows you to generate new information from the fields in an InfoSet, without having to include an additional field.

See also:

Leaving content frame