SAP Note 20214 - Unexpected sort sequence .

Symptom

Strange sort sequence for numbers when numeric and alphanumeric data is mixed.
Example: G/L account number
SAKNR CHAR 10
external internal
1 '0000000001'
123 '0000000123'
123A '123A '
A123 'A123 '

It is sorted by the internal representation.

Can be seen in matchcode and all other sorted lists

Cause and prerequisites

The problem is conversion routine "ALPHAEXIT", which is attached to many domains. It handles numeric data differently than alphanumeric data. You cannot remove the conversion routine, however.

The conversion routine is required in many places to guarantee that the system sorts 1,2,9,10, and not 1,10,2,9.

Solution
A) Fill the identifier ("numbers) to the full internal length

B) Have at least one letter in all identifiers

C) Have no letters or special characters in the identifier

D) Get accustomed to the special sort sequence.

Key words: Sort, Account number