topic Re: Sorting Character string numerically in Application Development and Automation Discussions

Sorting Character string numerically

Former Member — Tue, 26 Jul 2016 14:04:54 GMT

Hey guys, I have an ALV Grid that needs to display a column of numbers with units at the end. the unit may change example Kg, mm, cm. Within the ALV, if they click on the sorting buttons, it does not sort correctly.It is because as a string it sorts differently from how numbers sort.. Example data: 1. 850,000 mm 2. 77,000 mm 3. 740,000 mm It sorts the data as : 1. 740,000mm 2.77,000 mm 3. 850,000 mm Instead it should sort data as: 1. 77,000mm 2.740,000 mm 3. 850,000 mm. Please help me. I have checked the following discussion, but was not helpful. https://scn.sap.com/thread/3429747 Regards Dilip S

Re: Sorting Character string numerically

Ryan-Crosby — Tue, 26 Jul 2016 14:16:17 GMT

Hi Dilip,

I would suggest adding an additional numeric column that represents each of the number values and then sort the ALV table by that field but make it a hidden field. Treating the output as String instead of numeric will affect how the data is sorted.

Regards,

Ryan Crosby

Re: Sorting Character string numerically

Former Member — Tue, 26 Jul 2016 14:23:27 GMT

Hi Ryan,

Thanks for your quick response.

Adding one more column to the ALV is not feasible in my situation. It would be great , if there ais any other way.

Thanks in advance.

Regards

Dilip S

Re: Sorting Character string numerically

rosenberg_eitan — Tue, 26 Jul 2016 14:29:00 GMT

Hi,

I think that you can use Sorting Numeric Characters as numbers | SCN

as a base but in your case you need to format the data differently:

<unit measure> <SPACE> <numeric value> .

Regards.

Re: Sorting Character string numerically

Clemenss — Tue, 26 Jul 2016 15:26:29 GMT

It sorts the data as :

1. 740,000mm

2. 77,000 mm

3. 850,000 mm

Instead it should sort data as:

1. 77,000mm

2.740,000 mm

3. 850,000 mm

If the columns is of type QUAN for quantity field, it will sort as required.

Probably the ALV output field is type character.

Regards, Clemens

Re: Sorting Character string numerically

Sandra_Rossi — Tue, 26 Jul 2016 15:48:37 GMT


Dilip Kumar Subramaniam wrote:

I have checked the following discussion, but was not helpful. https://scn.sap.com/thread/3429747

(the thread is proposing a numeric field + a conversion routine)

May we know why you can't implement the solution in that thread, which is obviously the best choice?

Although I'm not fan of adding a column to the ALV, may we know why you can't add it?

I'd like to know, because it will avoid us proposing useless solutions again.

Re: Sorting Character string numerically

rosenberg_eitan — Wed, 27 Jul 2016 04:28:38 GMT

Hi,

For your knowledge the sorting is done using the internal format of the field .

For demonstration I formatted a date field using FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT' .

And I get:

Note that the months are sorted based on the actual value.

So it seems that you can format you internal data into a "sortable" format .

Using the exit you can present the internal data to the user as required .

Regards.

Eitan.