SAP Knowledge Base Article - Public

1913181 - Slow Performance While Executing the Activities Query

Symptom

Slow performance while executing the Activities query.

Reproducing the Issue

  1. Go to the Account Management work center.
  2. Go to the Activities view.
  3. Show All Activities and choose Go button.
  4. The display of list takes more time than your expectation.
  5. You also get a warning message: The data cannot be displayed completely. Sorting and Filtering are not reliable since the number of hits is too large. Reduce the number of search hits by restricting the search criteria.

Cause

On a particular query screen (e. g, Activities), if the data is huge and you try to query with All parameter then performance will be relatively slow and the system will throw below warning message:
The data cannot be displayed completely. Sorting and Filtering are not reliable since the number of hits is too large. Reduce the number of search hits by restricting the search criteria.

Resolution

In case of such warning message & slow execution, it is always advisable to use the Advanced query, optimize your search criteria then try to view the data. In Advanced query you have many parameters to optimize the query e. g. Date, Activity Type, Employee Responsible, Status, Account Name, Account ID etc.

  1. Go to the Account Management work center.
  2. Go to the Activities view.
  3. Show All Activities and choose the Advanced option.
  4. Select the required parameters and choose the Go button.
  5. The duration for the display of list will be optimized as per your expectation.

Keywords

KBA , AP-SLO , Sales Order Processing , How To

Product

SAP Business ByDesign all versions