SAP Knowledge Base Article - Public

2292748 - The Between Search Option for External ID Returns Unexpected Result Which Appear To Be Outside The Entered Number Range

Symptom

While Searching for Customers by their External ID via the Advanced Search using the Between option, results are returned that appear to be outside the range entered for the search.

Reproducing the Issue

  1. Go to the Customers work centre.
  2. Go to the Account view.
  3. Select All and click the icon for Advanced Search.
  4. For the field External ID, select the option Between.
  5. Provide a Value from 100000000 (100000000 is the value) which is smaller than the value entered for Value to 100001000 but has the same amount of characters.
  6. Click Ok and then Go.
  7. Go to the last page of your results.

Result:

Results are returned with are higher than the Value to amount.

Cause

This is expected system behaviour.

Resolution

The External ID is a character field (alphanumeric External ID's allowed/max length 100), not an integer field.
For character fields a range/ between search works like this:
External ID between 100000000 and 100001000
1000002222 is stored one the data base like 10000022220....00000 (in sum 100 char)
1000000000...000
<=
1000002222...000
<=
1000010000...000
therefore a result larger than the Value to can be found, example 1000002222 is found.

It is also possible in some systems, that some External ID's have one amount of characters 123 (123 representing the amount of characters) and others have 456 characters which can make the result of the search confusing.

Keywords

KBA , LOD-CRM-ACC , Account , How To

Product

SAP Cloud for Customer core applications 1602 (old) ; SAP Cloud for Customer core applications 1605 (old) ; SAP Hybris Cloud for Customer 1708