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.
SAP Cloud for Customer
SAP Business ByDesign
Reproducing the Issue
In this case, the behavior for the report Balance Audit Trail, for instance, can be reproduced as follows:
- Go to Business Analytics Work Center and choose Design Report view.
- Open the Balance Audit Trail (FINGLAU11_Q0001) report.
- Click on the Value selection for the G/L Accounts field and choose the Basic Select tab.
- 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 in reports and dashboards. in Dashboards the filter behaves like the selection in the report. The message will not be shown there yet but delivered in a future release.
The system behavior is as designed.
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.
value help; restriction; 200 records; selection; restricted; report selection; report; dashboards; filter , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To