topic Re: Alphanumeric sorting in Application Development and Automation Discussions

Alphanumeric sorting

debanjan48 — Fri, 28 Jun 2019 11:41:58 GMT

How does ABAP handle sorting on alphanumeric column ?

Re: Alphanumeric sorting

Tomas_Buryanek — Fri, 28 Jun 2019 12:17:31 GMT

SELECT ORDER or "ABAP" (ITAB) sort? Both are described in ABAP documentation...

Re: Alphanumeric sorting

Sandra_Rossi — Fri, 28 Jun 2019 13:14:24 GMT

I would answer "as any other programming language". Can you explain what is your doubt?

Re: Alphanumeric sorting

Jelena_Perfiljeva — Fri, 28 Jun 2019 20:11:38 GMT

Gently. 🙂 I'm also curious what exactly is the concern here.

Re: Alphanumeric sorting

matt — Sat, 29 Jun 2019 07:12:40 GMT

It sorts it alphanumerically.

Re: Alphanumeric sorting

RaymondGiuseppi — Mon, 01 Jul 2019 06:46:16 GMT

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...

Re: Alphanumeric sorting

debanjan48 — Mon, 01 Jul 2019 07:15:00 GMT

My question is how are alphanumeric data sorted. For example:

ABC1234

ABC7865

ABC0859

ABB9999

ANHYT

How will the above get sorted ?

Re: Alphanumeric sorting

RaymondGiuseppi — Mon, 01 Jul 2019 07:22:35 GMT

Result will be different in a UNICODE or ASCII system vs an EBCDIC system, why didn't you try with a simple report (check online documentation for such program, look for 'Executable Examples')

Re: Alphanumeric sorting

matt — Mon, 01 Jul 2019 07:51:49 GMT

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..

Re: Alphanumeric sorting

debanjan48 — Mon, 01 Jul 2019 08:30:04 GMT

Hi Matthew,

I guess alphanumeric means a combination of characters and numeric data. Can you please explain the reason for keeping 90 in between after sorting and not at the either extreme ends i.e. top or down.

Regards,

Debanjan Das

Re: Alphanumeric sorting

matt — Mon, 01 Jul 2019 09:09:34 GMT

I have just written a program, as I suggested you did, that takes those values in and sorts them. The '90' record comes at one of the extreme ends. It does not come in between. Why do you think it does?

Re: Alphanumeric sorting

Sandra_Rossi — Mon, 01 Jul 2019 20:28:56 GMT

Raymond Giuseppi as far as I can see in the documentation, with Unicode systems, SORT without AS TEXT doesn't depend anymore on the code page but only on the Unicode code point, and SORT with AS TEXT depends on the locale (based on the logon language or the one set by SET LOCALE).

Debanjan Das Concerning SORT with AS TEXT, for example the locales for languages Serbian, Chinese and Thaï, have characters sequenced as follows, here from the 4900th position; both the glyph and its Unicode code point are represented; it's done by a custom program:

SAP online example gives this result (1st sorting is based on the Unicode code points, 2nd and 3rd on the order of characters in the current locale):

Re: Alphanumeric sorting

DoanManhQuynh — Tue, 02 Jul 2019 00:28:04 GMT

so in general, the alphanumeric would be understood by computer in term of sequence of 2 bit 0 & 1. then sort is compare those sequence.