When you look for values of an Extension field, including an underscore "_" in the Advanced Search, the results are not as expected.
SAP CLOUD FOR CUSTOMER
Reproducing the Issue
We can take the example of an extension field you created in the Customers workcenter view, and with which you want to filter Accounts:
- Go to the Customers workcenter.
- Go to the Accounts view.
- Enter Advanced Search.
- Maintain the characters "A_X_123456578*" in ABC (ABC represents your Extension field).
- Launch the query.
Results: The system returns more results that expected, some including the first part ("A")some others including the middle or last part ("123456578") of the searched characters.
In the mentioned Extension field, you use the data type LANGUAGEINDEPENDENT_EXTENDED_Text.
For this data type, "_” is interpreted as a token separator.
You may resort to another data type for your extensions field, or look up the records using different characters.
Advanced Search, Underscore, "_", Data type. , KBA , LOD-CRM-ACC , Account , Problem