Query Management
Purpose
Query management supports you with creating specification searches that you require frequently and that are as complex as you like in the form of
queries and execute them as required.
Query management is available both in specification management and in the specification information system.
Prerequisites
In Customizing for Product Safety, you have carried out the following IMG activities:
- In the IMG activity Specify Groups you have defined groups.
The groups are used to store and edit queries in query management.
- In the IMG activity Specify Group Trees and Assign Groups you have assigned groups to the group tree for queries.
Process Flow
You can choose from one of the following methods of creating a query:
create a specification search directly as a query after you have executed the search.
- You can also create a query explicitly step by step in a tree structure, the query overview (see
Creating and Editing Queries). The query steps comprise individual search criteria, other queries, or sets of hits. In the query steps you also specify whether the search result is to be extended, refined, or reduced by the query step. You can use an existing query as the template for a new query or copy and move individual query steps between queries and within a query.
- Every query belongs to a query group. In the
group overview you can display queries, copy or move queries between the groups, or delete them completely. You can also edit the header data of the queries from the group overview.
- You can choose from one of the following methods of executing a query:
execute a query directly from the group overview.
From the initial screens of specification management and the specification information system, with the help of drilldown reporting, you can execute a query of the system in the background and automatically save the set of hits that results (see Executing Drilldown Reporting Jobs.
From outside the SAP component Environment, Health and Safety you can call the specification information system and execute a query using the external caller function.
Result
After you have executed a query, you are shown the results as a set of specification hits in the form of a hit list from which other functions are available to you.
See also:
Specification Management Hit List
Specification Information System Hit List
Basic Functions in the Hit List
Set of Hits Management