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 without empty.
Prefer typing out
count(distinct [myfield]) in the