Symptom
You are searching for a product with the product name or id in the basic search filter in List price view, but system displays multiple records instead of specific product.
However in advanced filter, it displays only specific record.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Product Portfolio work center
- Select view List Prices
- Filter with all list prices
- Search with a product name or id
- System displays the correct product along with multiple other records.
Cause
The Basic search works on approximate string matching which is also known as fuzzy string searching which is a technique that matches a pattern approximately rather than exactly. Therefore, the search will pull up all items that have any mention to the search term within their records.
The basic search field is not referring to any specific field like product id or supplier id etc, here you can enter any text and search. It will try to find the matching records.
But in advanced filter, the fields are specific, so when you enter specific product id in the relevant field, it will search only for that product.
Resolution
Please use the advanced filter to get the exact product because here the search criteria is based on specific fields.
See Also
2587216 - Filter for Basic Search in Resource Management Does Not Work As Expected
Keywords
basic search, advanced filter, list price search not working, search field is not working as expected , KBA , basic search , advanced filter , search not working , product search , list price search , AP-PMD-PPS , Procurement Price Specification , How To