Maintenance of Queries

Use

You can use this function to create, display, change, delete, and transport queries (see BCV Query). The system processes queries to collect and analyze data from a data provider (see Processing of Queries).

Prerequisites

You can maintain queries only if you have the necessary authorizations, which are granted to you in one of the following ways:

In the Role Maintenance (PFCG) transaction, you are assigned to the BCV User (SAP_BCV_USER) role.
In SAP NetWeaver Portal, you are assigned to the BCV User (com.sap.pct.bs_fnd.BCV_USR) role.

Features

Creation of Queries

You can create new queries in the following ways:

You can create a query by defining a completely new query (see Definition of Queries).
You can copy and change an existing query.

BCV is delivered with a set of predefined, standard queries (all standard query IDs begin with the number 1). You can use these queries directly or copy them to the customer namespace (by using an ID beginning with A to Z) changing them as needed. For more information, see Business Content for Business Context Viewer.

For each newly created query, you must specify a unique query ID. The system fills the header of the new query with administrative information (for example, who created the query and the time of creation). Furthermore, the system performs a consistency check of the query definition before saving it.

Display and Change of Queries

You can display and change existing queries. When you change a query, the system updates the header of the query with administrative information (for example, the person who last changed the query and the time of change). Furthermore, the system performs a consistency check of the query definition before saving it.

Deletion of Queries

You can delete existing queries. The system performs a where-used check to determine whether the system is using the query in other objects (for example, in query views) before deleting it. If the system is using the query in another object, the system does not delete it and provides you with information about which object is using the query.

Transport of Queries

You can transport queries.

Note

You must transport a query header together with all of the query header’s dependent objects, such as query classification, query fields, and so on. This means that when you create a formula, you must select a transport request (if the client settings require that the system transports Customizing settings). You have to transport the request containing the formula (BRFplus objects) together with the query. Transports are not necessary in a single-system landscape.

Check of Queries

The system performs the following checks on queries:

Where-Used Check

Before deleting a query, the system automatically performs a where-used check. You cannot delete a query that another object (for example, a query view) is using.

You can manually perform a where-used check of a query any time as follows:

In the configuration center, choose Define BCV Queries Where Used .
In Customizing, under Cross-Application Components Processes and Tools for Enterprise Applications Business Context Viewer Query Management Define BCV Queries , chooseWhere-Used List.

Recommendation

Using the configuration center is the recommended approach to making configuration settings in BCV. You should use Customizing only in exceptional cases. For more information, see Configuration Center.

Consistency Check

Before saving a query, the system automatically performs a consistency check. If the check results in at least one error or warning (which means that an inconsistency exists or might exist), the system asks you whether you want to save the query. Temporary inconsistencies can occur in cases where, for example, you cannot finish the query definition but do not want to discard the incomplete query.

Before processing a query, the system performs a consistency check to prevent data inconsistencies. The system can only process consistent queries.

You can manually perform a consistency check of a query any time as follows:

In the configuration center, choose Define BCV Queries Check Consistency .
In Customizing, under Cross-Application Components Processes and Tools for Enterprise Applications Business Context Viewer Query Management Define BCV Queries , choose Check Consistency. The consistency check considers changes in queries that you have not saved yet so that you can check their consistency during query definition. You have to manually correct data inconsistencies that the system detects.
In Customizing, under Cross-Application Components Processes and Tools for Enterprise Applications Business Context Viewer Maintenance Perform Consistency Check . You have to manually correct data inconsistencies that the system detects. For more information, see Consistency Check.

Recommendation

Activities

You can maintain queries in the following ways:

To maintain a query in the configuration center, choose Define BCV Queries.
To maintain a query in Customizing, choose Cross-Application Components Processes and Tools for Enterprise Applications Business Context Viewer Query Management Define BCV Queries .
Directly form the search connector maintenance.