Modifying an InfoSet (Ad Hoc) Query


Modifying an InfoSet (Ad Hoc) Query

After you create an InfoSet (Ad Hoc) Query, you might want to return to the design screen to make changes and modifications. You can click the green Back button to return to the design screen from the SAP List Viewer display of your report output. In addition, you can change the format of your report from the SAP List Viewer output screen by selecting Settings, Layout, Change.



Saving an InfoSet (Ad Hoc) Query

On the design screen in the InfoSet (Ad Hoc) Query tool, you can click the Save button on the Application toolbar to save a query. After designing an InfoSet (Ad Hoc) query, you can change it as often as you like and execute the updated query.

If and where you can save a query depends on your authorizations and on the reporting you are authorized to carry out. (See Chapter 18, "Security Concepts in SAP R/3 Query-Based Reporting Tools," for more information.) If you are authorized to save queries (authorization object S_QUERY with the value 02 for the field ACTVT), you can save from either the Application toolbar or the File menu. The way these functions work depends on your previous work with the InfoSet (Ad Hoc) Query tool.

The following sections describe the various options for saving InfoSet (Ad Hoc) queries.

Save (First Usage)

The first time you use the Save function, SAP takes you to a dialog box where you can enter a short name and description for your InfoSet (Ad Hoc) query. This dialog box is a bit confusing. The system proposes a new name if the template you call up is an InfoSet; if it is a query, the system proposes a query name. If you save a query under the same name again (that is, if you overwrite it), the query is locked for other users. That is, other users of the InfoSet (Ad Hoc) Query tool can continue to use the locked query as a template, but they cannot overwrite it.

If you are a member of a query group and your configuration follows the recommendations in Chapter 2, "One-Time Configuration for Query Tool Use," you can also select from the dialog box a query group to which you want to assign the query to easily group your saved queries as recommended. As with the SAP Query tool, with the InfoSet (Ad Hoc) Query tool you can belong to multiple query groups.

Save (Not First Usage)

If you use the Save function again with a changed query during a session with the InfoSet (Ad Hoc) Query tool, the query you saved before is overwritten. The dialog box is not shown again. Locks that already exist remain valid.

Save As

As with the Microsoft family of products, using the Save As function allows you to save an open item under a new name to distinguish it from the original item. This function primarily exists so that you can copy queries and edit them afterward. With this function, the dialog box is always shown so you can enter the query name and a description. The system proposes the name of the query that you used as template. The query is saved and locked under the name entered. If you have already saved and therefore locked the template, this lock is removed.

If you are configured to be a member of a query group, you can also select from the dialog box a query group to which you want to assign the query. At this point, you can switch between query groups to which you are assigned and that have access to the current InfoSet. Again, as with the SAP Query tool, with the InfoSet (Ad Hoc) Query tool you can belong to multiple query groups. It is important to note that if you select an existing query from the list of available InfoSet (Ad Hoc) queries, that query is overwritten when you confirm.

Note

The query is locked when you save it. In other words, other users can continue working on the query at the same time as you, but they end up using the old (unchanged) version as a template in the current session with the InfoSet (Ad Hoc) Query tool. It is important to note that they can no longer save the query under its original name. This also means that you can save a query under a certain name only if the query is not locked by another user. If you have locked a query by saving it and then you select a new template for your InfoSet (Ad Hoc) Query tool, the lock on the query used before is removed, and another user can save the query in a changed version.