SAP Knowledge Base Article - Public

2739208 - Your Advanced Search Does not Return the Expected Values When you Include an Underscore

Symptom

When you look for values of an Extension field, including an underscore "_" in the Advanced Search, the results are not as expected.

Environment

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:

  1. Go to the Customers workcenter.
  2. Go to the Accounts view.
  3. Enter Advanced Search.
  4. Maintain the characters "A_X_123456578*" in ABC (ABC represents your Extension field).
  5. 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.

Cause

In the mentioned Extension field, you use the data type LANGUAGEINDEPENDENT_EXTENDED_Text.

For this data type, "_” is interpreted as a token separator.

Resolution

You may resort to another data type for your extensions field, or look up the records using different characters.

Keywords

Advanced Search, Underscore, "_", Data type. , KBA , LOD-CRM-ACC , Account , Problem

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications all versions