A different query execution type is used to search for documents in the SAP KM portal. The KM query search criteria are passed to the KM web service. The search results are stored in a work table. Similar to a query with an SQL execution type, it contains an SQL statement. This SQL statement joins the results of the KM search with other SAP Sourcing business object data.

Currently, for every KM query, two well-known KM search parameters should be defined on the Filter Prompts page: KmTrexSearchText (String) and KmContextType (String; Hidden). It is most likely that the set of required KM search parameters will be changed in the future.

If any filter prompts are defined for the SQL statement, they must be represented in the query string by named parameters: <%?(ParamName)%>.