SAP Knowledge Base Article - Public

1884963 - Value help result is restricted to 200 records

Symptom

You want to fetch all existents records using the the Value Selection for a particular characteristic, however the selection restricts the number of result displayed in that screen and shows the information message: Value help is restricted to 200 records.

 Use Case: You want to see all existents records available from the Value selection for a specific object which has more than 200 records.

Reproducing the Issue

In this case, the behavior for the report Balance Audit Trail, for instance, can be reproduced as follows:

  1. Go to Business Analytics Work Center and choose Design Report view.
  2. Open the Balance Audit Trail (FINGLAU11_Q0001) report.
  3. Click on the Value selection for the G/L Accounts field and choose the Basic Select tab.
  4. The list will provide a maximum of 200 records and the following information message: Value help is restricted to 200 records.

Note: You we'll be able to reproduce such behavior if the object you are selecting has more than 200 records.

Cause

The system behavior is as designed.

Resolution

The value selection result is restricted to 200 records however you can show/find any additional records, out of this range, using the advanced search options or other search criteria, such as asterisk (*) to search for objects. For example *XYZ*, *XYZ etc.

Keywords

KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer all versions