Skip to Content
-7

Alphanumeric sorting

How does ABAP handle sorting on alphanumeric column ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jul 01, 2019 at 06:46 AM

    Character-like columns are sorted by default by their binary representation, encoding in the code page of the current text environment.

    You can force a 'textual' sort using option AS TEXT to use locale text environment, which depends on Language, Operating System and Kernel (e.g. rules fo upper/lower case or accented characters, or characters that don't belong to the language...) Can you guess performance impact of this option...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 01, 2019 at 07:51 AM

    It will sort

    • ABC1234
    • ABC7865
    • ABC0859
    • ABB9999
    • 90
    • ANHYT

    alphanumerically. It seems you don't know what "alphanumerically" means, so I suggest you write a short program and find out exactly how this data will be sorted on your system..

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.