Saving Queries (Biblioteca SAP

Saving Queries

After starting InfoSet Query you can change a template as often as you like and execute the corresponding query. If and where you can save a query depends on your authorizations and on the reporting you are authorized to carry out. If you require further information, see Rights to Access InfoSet Query and Type of Reporting.

If you are authorized to save queries (authorization object S_Query with the value 02 for the field Actvt) you can use the functions Save and Save as. The way these functions work depends on your previous work with InfoSet Query.

Save (first usage)

This function will take you to a dialog box where you can enter a new query name and a description. The system proposes a new name if the template you called up was an InfoSet; if it was a query, then the system proposes the query name. If you save a query under the same name again (meaning, overwrite it) then it is locked for other users. That is, other users of InfoSet Query can continue to use the locked query as a template, but cannot overwrite it.

If you are working in a context, which uses the SAP Query user groups, you can also select, from the dialog box, a user group to which you want to assign the query. At this point, you can switch between user groups to which you are assigned and which have access to the current InfoSet.

Save (if not the first time)

If you are using the function again with a changed query during a session with InfoSet Query, the query you saved before is overwritten. The dialog box is not shown again. Locks that already exist remain valid.

Save as

This function primarily exists for you to copy queries and edit them afterwards. With this function the dialog box is always shown to 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 working in a context, which uses SAP Query user groups, you can also select, from the dialog box, a user group to which you want to assign the query. At this point, you can switch between user groups to which you are assigned and which have access to the current InfoSet.

If you select an existing query from the list, it is overwritten when you confirm.

The query is locked when you save it. This means that other users, who may be working on the query at the same time, can continue to use the old version as a template in the current session with InfoSet Query, but they can no longer save the query under its original name. This also means that you can only save a query under a certain name if this query is not locked by another user.

If you have locked a query by saving it and then select a new template for InfoSet Query (InfoSet or query) the lock on the query used before is removed and another user can save the query in a changed version.

If you are not authorized to change queries, you can start the InfoSet with templates, change and execute queries, but you cannot save the changes.

See also:

Saving a Query