topic sort text internale table in Application Development and Automation Discussions

sort text internale table

Former Member — Tue, 11 Sep 2007 09:25:28 GMT

hi guys,

now i have an internal table with a field of 10 character type length, i need to sort by this field descending and its value could be numeric or character.

this is order i want ‘TR’‘10’‘9’, for example,

this the order i got now ‘TR’‘9’‘10’, 'cause by byte compare 9 is greater that 1.

so how to sort this kind of table, is there any FM?

thanks

Re: sort text internale table

Former Member — Tue, 11 Sep 2007 09:29:02 GMT

CATT_SORT_TABLE

use this FM...may it help u

Re: sort text internale table

Former Member — Tue, 11 Sep 2007 09:49:03 GMT

too complicated FM,hehe~~~

Re: sort text internale table

Former Member — Tue, 11 Sep 2007 09:49:17 GMT

Hi Derek,

Can you use a conversion exit before population your internal table like below:

DATA : BEGIN OF tab OCCURS 10,

field TYPE char10,

END OF tab.

CALL 'CONVERSION_EXIT_ALPHA_INPUT' ID 'INPUT' FIELD '9'

ID 'OUTPUT' FIELD tab-field.

APPEND tab.

CALL 'CONVERSION_EXIT_ALPHA_INPUT' ID 'INPUT' FIELD 'TR'

ID 'OUTPUT' FIELD tab-field.

APPEND tab.

CALL 'CONVERSION_EXIT_ALPHA_INPUT' ID 'INPUT' FIELD '10'

ID 'OUTPUT' FIELD tab-field.

APPEND tab.

SORT tab DESCENDING.

LOOP AT tab.

WRITE:/ tab-field.

ENDLOOP.

Regards,

Chester

Re: sort text internale table

varma_narayana — Tue, 11 Sep 2007 09:56:14 GMT

Try this..

SORT ITAB BY <FIELD> AS TEXT.

<b>reward if Helpful</b>

Re: sort text internale table

Former Member — Tue, 11 Sep 2007 10:08:50 GMT

Chester Drawers

thanks, gave u the points

as text is not working~~~