Displaying and Changing Existing Queries in the Query Designer (SAP Library - Enterprise Reporting, Query, and Analysis)

Displaying and Changing Existing Queries in the Query Designer

Prerequisites

You must have created at least one query.

Displaying Queries

You open the Query Designer from Start Programs Business Explorer Query Designer.

You can also call up the BEx Query Designer from the following components:

From the BEx Web Application Designer:

In the Query Designer symbol toolbar, choose Open Query. The BEx Open Dialog appears.
From here, select a query from the queries in your history, favorites or roles, or from queries assigned to the InfoAreas.

You can display them in the Query Designer:

From the BEx Analyzer:

Choose Open ® Queries in the BEx toolbar. The BEx Open Dialog appears.
From here, choose a query from the queries in your history, favorites or roles, or from queries assigned to the InfoAreas. Then select it.
Choose Change.

Changing Queries

Display the query in the Query Designer.

You can now make changes in the query definition. The procedure for changing the query is the same as for creating a new query (see also: Defining New Queries).

You have two options for saving the query:

You can save the changed query. From the toolbar, choose Save Query.
You can save the changed query as a new query. From the toolbar, choose Save Query As. Enter a new technical name, a new short text and a new description.

You can also delete the query. From the toolbar, choose Delete Query. You can delete the query only if it is no longer being used (that is, if it is not being used in any workbooks, Web templates, Crystal Reports or Reporting Agent settings).

Note

Using the function Display <-> Change , you can toggle between the display and change modes.

See also:

Saving Queries