topic Re: Sort internal table with char components in Application Development and Automation Discussions

Sort internal table with char components

wolfgang_brunneder — Tue, 17 Mar 2009 13:15:10 GMT

Hello!

I have a question concerning sorting internal tables. I have a table with two components of type char:

A B

space space

248 BA

273 space

I tried to sort the table by 'SORT itab BY a b DESCENDING' - the result I expected is ...

A B

273 space

248 BA

space space

... but the computed result is ...

A B

space space

248 BA

273 space

I assume that the computed result is due to the initial char-values (space). How are initial char-values (space) handled by the sort statement?

I appreciate any advice!

Greetings

Wolfgang

Re: Sort internal table with char components

sarbajitm — Tue, 17 Mar 2009 13:22:23 GMT

hi,

would you please explain your requirement elaborately?

Regards.

Sarbajit.

Re: Sort internal table with char components

wolfgang_brunneder — Tue, 17 Mar 2009 13:24:11 GMT

Sorry, I accidently hit the post button before having finished g.

Re: Sort internal table with char components

sarbajitm — Tue, 17 Mar 2009 13:32:12 GMT

To get the expected result..........

what you have to do is...

'SORT itab BY a DESCENDING b DESCENDING'

because the above statement sort itab by a 's descending order first then if two row contain same valu for a then column b help to take the decision which one come first. if row one has smaller value in B than that of row two.then row one come next to row two.

thanks.

Re: Sort internal table with char components

faisalatsap — Tue, 17 Mar 2009 13:33:55 GMT

Hi,

Test the Code Bellow it is working as per you requirement

data: BEGIN OF it OCCURS 1,
  a(10),
  b(10),
  END OF it.

  it-a = '273'. it-b = ' '. APPEND it.
  it-a = '248'. it-b = 'BA'. APPEND it.
  it-a = ' '. it-b = ' '. APPEND it.

  SORT it by a DESCENDING b DESCENDING.

Best Regards,

Faisal

Re: Sort internal table with char components

wolfgang_brunneder — Tue, 17 Mar 2009 13:38:12 GMT

Thank you two very much - it works!

Greetings

Wolfgang

Re: Sort internal table with char components

Peranandam — Tue, 17 Mar 2009 13:43:06 GMT

Hello,

Dont use coloum having property of charactor.

if you sort internal table based on field having charactor then you will get result as per your computed result.

change your field properties from char to n. then you will get you expected answer.

example if you have internal table with one coloum 'A'.

let us assume value of that coloum is 1,6,12,7,14,7,19

if you sort result will be 1,12,14,6,7,19. so in this case you have to define coloum with numeric property.

Regards,

Peranandam