Limit Size of result sets

By default in business layers, SAP BO limits result sets to 5000 rows. You may need to override this limit and allow users to get more results. You can do it in Query Options inside the "Business layer".

Avoid some projection functions

The following projections are not recommended:

  • Count.
  • Count without empty.

Prefer typing out count(distinct [myfield]) in the select box.