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 executing them as required.
Query management is available both in specification management and in the specification information system.
Note
You can save search criteria that you frequently use for a simple search on the initial screen of the specification search using the
function with the quick info text
Save Search Criteria
and load the search criteria again using the
function with the quick info text
Load Search Criteria
. You can save one search per specification category as user-dependent. The entries you made for the key date and change number are not saved.
Prerequisites
In Customizing for
Basic Data and Tools
, you have processed 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 for creating a query:
You 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 for executing a query:
You can execute a query directly from the group overview.
With the help of the drilldown reporting job , you can execute a query of the system in the background and automatically save the set of hits that results. You can do this from the initial screen of the specification search.
From outside the SAP
Environment, Health and Safety
component you can use the external caller function to call the specification information system and execute a query.
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: