Function documentationMaintenance of Queries

 

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

Prerequisites

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 PLM PCV Administrator (SAP_PLMWUI_PCV_ADMIN) role.

  • On the SAP NetWeaver Portal, you are assigned to the PCV Administrator 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.

    PCV comes 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 name space (by using an ID beginning with A to Z) changing them as needed. For more information, see SAP Business Content for the Analysis of Materials.

For each newly created query you have to 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, who 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 gives you information about which object is using the query.

Transport of Queries

You can transport queries between PLM systems.

Note Note

You have to transport a query header together with all of the query header’s dependent objects, such as query classification, query attributes and so on. When you create a formula, you have to 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.

End of the note.
Check of Queries

The system performs the following checks of 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 by using the Define Queries transaction.

  • 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 by using the Define Queries transaction. The consistency check considers changes in queries that you have not saved yet so that you can check consistency during query definition. You have to manually correct data inconsistencies that the system detects.

    • You can also check the consistency of one or multiple queries any time by using the Consistency Check program. You have to manually correct data inconsistencies that the program detects. For more information, see Consistency Check.

Activities

You can maintain queries in the following ways:

  • To maintain a query in Customizing, choose Start of the navigation path Logistics - General Next navigation step Product Lifecycle Management (PLM) Next navigation step PLM Web User Interface Next navigation step Product-Centric View Next navigation step Query Management Next navigation step Define Queries End of the navigation path.

  • To maintain a query on the SAP Easy Access screen, choose Start of the navigation path PCV Administration Next navigation step Define Queries End of the navigation path.

  • To maintain a query on the Web user interface, choose Start of the navigation path PCV Administration Next navigation step Define Queries End of the navigation path.