Show TOC

Function documentationQuery Groups Locate this document in the navigation structure

 

Query groups are used to integrate queries into the list pages and picker windows of the SAP Sourcing application. After a query is defined, it must be integrated into the application to make it available to users. These actions are performed using the Query Group option in Setup.

A query group contains a list of queries. These queries are all made available to the user through a drop-down list, with the one marked in the query group as a default initially selected. SAP Sourcing provides an extensive set of query groups by default. You can edit list and picker query groups by adding queries to them, by hiding standard queries, and by changing the default query.

This section describes how to create and edit a query group.

Query Group Page

You use the Query Group page to enter basic query group information.

Query Group Queries Page

The Queries page displays a list of contained queries. You use the Queries page to delete, reorder, and add queries.

For more information, see Reports and the sections below entitled Editing a Query Group for a List or Picker and Field Help for Query Group: Query Reference Dialog Box.

Query Group Access List Page

You use the Access List page to add collaborator information to a query group access list. For details, see Add Collaborator.

Note Note

By default, no collaborators are specified for the query group. In this case, all users are granted default access rights. Once one or more collaborators are specified, however, other users are denied access to the query group. When the query group is used as a list page, this hides the list page from those other users. When the query group is used as a picker, the picker is not hidden

End of the note.

Features

Field Help for Query Group Page

Function

Description

Inactive

Select this box to indicate that this query group is inactive and unavailable for use. An inactive report query group does not appear in a Lookup window of available reports. A picker or list query group for a business object can be made inactive and replaced with a custom query group for the same object, but we do not recommend this. It is preferable to customize a standard picker or list query group. It can then be updated when upgrading to a future release.

Internal Name

Enter a unique identifier for the query group. During the import of new versions of queries into a database, this value is used to find and replace old query group versions, and therefore should not be changed. Default queries begin with “FCI-”, but custom query groups must not use this prefix.

User View

Select the perspective of the user who is to see this query group, either buy-side or sell-side.

Query Use

Queries can be grouped for different uses. Select the use of this query group from the drop-down list.

Class ID

For list, picker, or selection query groups, enter the integer class ID that corresponds to the object being listed or picked. (A selection query group is essentially a special-purpose picker.)

Display Name Resource

Choose the Lookup icon to select a display name for the query group from the list of localized resources. If the query group name is not in the list, choose Create in the dialog box to create a new localized resource.

Description Resource

Choose the Lookup icon to select a query description.

Context Sensitive Toolbar

Choose the Lookup icon to select a toolbar for the context-sensitive action to be specified at the row level in the result table.

List View Result Table Toolbar

Choose the Lookup icon to select a business-object-specific action toolbar to be added in the result table toolbar.

Help Page ID

Enter an identifier for the Help Page created for the business-object-specific advanced list page.

Category

A classification of the query group used for administrative purposes, particularly for standard query groups. If you are creating a query group, select the module for which the group is to be used.
Field Help for Query Group: Query Reference Dialog Box

You access the Query Reference dialog box by choosing Edit for a query reference on the Query Group Queries page. The following provides help for the fields in the Query Reference dialog box.

Function

Description

Default Query

Select this box to designate the query as the default query. For list and picker queries, we recommend that one query in each query group is designated as the default query to execute when the list or picker page is displayed. If no default query is selected, the first query in the list is executed. Only one query in a group can be set as the default query.

Remove Query from Selection List

If a standard query is to be replaced by a (presumably similar) custom query, the custom query is typically added to the same query group as the one to be replaced. Standard queries may not be removed from a query group, however. Choose this box to prevent the standard query name from appearing in a list or picker page's selection list.

Include in E-Sourcing Navigation

Choose this box to add the query to the SAP Sourcing navigation bar.

Activities

Editing a Query Group for a List or Picker

Query groups are used to integrate queries into the SAP Sourcing application. You can integrate new list or picker queries by adding them to an existing query group or by replacing members of an existing query group.

Note Note

To add or replace a list or picker query, find the query group whose Query page contains the correct User View (Buy Side or Sell Side), the correct Query Use (List or Picker), and the correct Class ID of the target object to be queried (for example, RFPs are class ID 900). For a list of class IDs, see the Class Reference of the online Reference Guide.

End of the note.

Note Note

A Query Use value of Selection creates a picker query with stringent filters tailored to specific documents. We do not recommend that you use this value or edit query groups containing this value.

End of the note.

To edit a query group:

  1. Choose Setup in the toolbar at the top of the page.

  2. In the Queries and Reports section of System Setup, select Query Groups from the drop-down list and choose OK.

  3. On the Query Group List page, do one of the following:

    • From the drop-down list, select Search Query Groups by Name or Search Query Groups by Queries Used, search for the group to edit, and select the group.

    • From the drop-down list, select All Query Groups, All Inactive Query Groups, or Query Group Review, and choose the group to edit.

  4. On the Query Group page, choose Save.

  5. Edit any fields.

  6. Choose the Queries tab

  7. Choose Edit for a query reference to edit the query reference.

  8. In the dialog box, edit any fields and choose OK.

    Recommendation Recommendation

    For list and picker queries, we recommend that you check the Default Query box for one query in the group. This query is executed when the list or picker page is displayed. If no default query is selected, the first query in the list is executed. Only one query in a group can be set as the default query.

    End of the recommendation.

    Note Note

    A standard query can be replaced by a custom query, but it cannot be removed from a query group. To prevent it from being displayed, check the Remove from Selection List box.

    End of the note.

  9. Optionally, add or delete queries.

  10. Optionally, choose Reorder List to reorder queries. For lists and pickers, the order controls the order the queries will appear in the drop-down list of available queries.

  11. Choose the Access List tab.

  12. On the Query Group Access List page, add or remove collaborators.

  13. Save your entries.