Definition of Queries

You can use this function to define a new query (see Query) from scratch for Product-Centric View (PCV). To define a query, you have to specify which objects the system selects in which data source, which attributes of these objects the system returns and how the system processes the returned data. The existence of queries is a prerequisite for the definition of query views (see Query View) that the system uses to display the results of query processing (see Processing of Queries).

Prerequisites

You can define a new query only if the following applies:

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.
You have defined a search connector or you use one predefined by SAP. For more information, see Definition of Search Connectors.
Optional prerequisite: You have defined meanings or use ones predefined by SAP. Fore more information, see Definition of Meanings.

Features

The definition of queries includes the following:

The definition of result attributes and selection criteria can include formulas. For more information, see Definition of Query Formulas.

PCV comes delivered with the following predefined queries:

Query	Search Connector	Number of Variables	Number of Result Attributes	Description
1MAT01_MAIN_IN_ATTR	1MAT01	7	37	Material (via Enterprise Search) Query - Main Input Attrib.
1MAT02_STANDARD	1MAT02	13	13	Material (via SES) Standard Query
1MATCOST01_STANDARD	1MATCOST01	6	30	Material Cost Analysis (via BI) Standard Query
1QN01_STANDARD	1QN01	5	27	Quality Notification (via BAPI) Standard Query
1SALESORDER01_STANDARD	1SALESORDER01	4	20	Sales Order (via BAPI) Standard Query
1STOCK01_STANDARD	1STOCK01	2	20	Stock Overview (via BI) Standard Query

For more information, see SAP Business Content for the Analysis of Materials.

Activities

You can define queries in the following ways:

To define a query in Customizing, choose Logistics - General Product Lifecycle Management (PLM) PLM Web User Interface Product-Centric View Query Management Define Queries .
To define a query on the SAP Easy Access screen, choose PCV Administration Define Queries .
To define a query on the Web user interface, choose PCV Administration Define Queries .

Recommendation

For more information about the setting of individual fields, see the field helps and input helps.

End of the recommendation.

More Information

Query Management