Symptom
Unable to filter a Production Model using an extension field.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Production Control work center.
- Go to Production Order By Order Header view.
- Select All Production Orders.
- Go to column Production Model and filter by ABC (ABC means Production Model ID).
- System doesn't find it and the following warning message is displayed: "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
"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."
As the warning message says, the filtering might not work due to the amount of records that displays in this particular view.
To maintain system performance, list will show 10,000 records by default if a search parameter is not entered in the Search field.
Resolution
Filtering for this particular field is not working due to the amount of data is available for this screen.
However, if the steps below are followed, filtering will work properly:
- Go to the Production Control work center and then Production Orders.
- Show All Production Orders.
- Open Advanced Search, icon nearby the Search field.
- Maintain the Product ID as DEF (DEF means Product ID).
- Click Go.
- System will return records.
- Perform the filter for the Production Model as ABC, for example.
- System will return records with this Production Model.
Keywords
Production Model, Production Order, Extension Fields, Product , KBA , AP-PMM-PM , Production Model , How To