SORT

[radhushankar]

Moderator message: please use a more informative subject in futuer

Hi All,

I am having a entries in my table like this

Field1(TYPE C)

8

9

10

11

12.

When i use SORT ITAB DESCENDING BY FIELD1.I am getting out put like this.

9

8

12

11

10

But i want the output like this.

12

11

10

9

8.

Can any one tell me how to acheive this..

Edited by: Matt on Nov 18, 2008 7:55 AM

[Former Member]

declare field1 type as number nd sort descending by field1

[radhushankar]

Yeah now i have changed to N.

But still i am facing the same error

Thanks

[radhushankar]

Can any one take this up???

Thanks in advance

[Former Member]

Now ay it cant be wrong , are you using any other field in addition.

use this statement .

SORT ITAB DESCENDING FIELD1 . ( Dnt add any other field )

[radhushankar]

Hi

I have done like this SORT INT_UPLOADED DESCENDING BY SEQUENCE.

SEQUENCE IS MY FIELD NAME AND I HAVE DECLARED IT AS

data: sequence(4) type n.

Still i am facing the same error.

Thanks

[Former Member]

how can you so sure that its getting sorted wrongly !!!! it cant go wrong . Are you writing it out or r u seeing in debugging mode . If debugging make sure the cursor passes the sort command. As per the above code nothing is wrong , it should work.

[Former Member]

Hi,

Use type i (Integer). It will work fine.

If you are using type N. keep value like 09,08,11,12

use FM conversion_exit_alpha_input to convert value 9 to 09

then use sort command