topic Re: Sort in Application Development and Automation Discussions

Sort

former_member125931 — Tue, 24 Jun 2008 14:33:37 GMT

Hi All,

I am doing sum using collect statement,

here I am having two fields one is text and another one is numeriacal

I done like below

text field numerial field

a 1

b 2

c 2

a 2

a 8

a 3

so here I got a = 14,b = 2,c = 2.

I done sort by using text field

but what my problem is I need show the values in desending order of numerial field,

for that I done again sort by taking all these values into another internal table,

but again the data chaged as it is how before adding these field,

pls any one help me.

Thanks&regds,

Nicky.

Re: Sort

Former Member — Tue, 24 Jun 2008 14:37:16 GMT

Hello,

Though, it is very difficult to understand what exactly U are looking for..

I'm assuming that there is some problem and for that try using the below logic:

SORT by text field numeric field DESCENDING.

Let us know, if this helps.

<removed_by_moderator>

Rgds,

Raghu.

Edited by: Julius Bussche on Jun 24, 2008 7:04 PM

Re: Sort

Former Member — Tue, 24 Jun 2008 14:38:35 GMT

Snicky,

No need of another itab.

after doing SUM you can sort by decending at numeric field.

Amit.

Re: Sort

Former Member — Tue, 24 Jun 2008 14:38:42 GMT

You can first sort by text field and then by numerical field DESCENDING.

<removed_by_moderator>

Edited by: Julius Bussche on Jun 24, 2008 7:10 PM

Re: Sort

former_member125931 — Tue, 24 Jun 2008 14:41:47 GMT

Hi,

I done that,it became same as earlier before done sum,it means it sorted as desending order but no sum on similar fields.

Thanks&regds,

Nicky.

Re: Sort

Former Member — Tue, 24 Jun 2008 14:41:49 GMT

Hi,

After your Collect Statement write the following statement.

sort <second_internal_table> by text field.

<removed_by_moderator>

Warm Regards

R Adarsh

Edited by: Julius Bussche on Jun 24, 2008 7:11 PM

Re: Sort

Former Member — Tue, 24 Jun 2008 14:42:46 GMT

hiiii

just use AT NEW fieldname.

& SUM..it will give you correct result.

like below

loop at..

at new field1.

sum.

write

endloop.

<removed_by_moderator>

thx

twinkal

Edited by: Julius Bussche on Jun 24, 2008 7:11 PM

Re: Sort

Former Member — Tue, 24 Jun 2008 14:44:39 GMT

Hi,

You can do the desired output like below way-

First sort the internal table by numerical field(Field 2) Descending in Descending Order.

After that sort Internal table again By Text Field (Field 1)

in Ascending order.

<removed_by_moderator>

Regards,

Sujit

Edited by: Julius Bussche on Jun 24, 2008 7:09 PM

Re: Sort

former_member125931 — Tue, 24 Jun 2008 14:47:36 GMT

Hi,

I used as you suggested but no nuse.

Thanks&regds,

Nicky.

Re: Sort

former_member125931 — Tue, 24 Jun 2008 14:48:23 GMT

Can you expalin me how it is pls.

Thanks&regds,

Nicky.

Re: Sort

JozsefSzikszai — Tue, 24 Jun 2008 14:50:57 GMT

hi,

this is what you need at the end?

a 14

b 2

c 2

(numbers in descending order)

in this case you have to do:

SORT itab BY text.
COLLECT itab.
SORT itab BY number descending.

hope this helps

Re: Sort

former_member125931 — Tue, 24 Jun 2008 14:52:37 GMT

Hi Adarsh,

Can you expalin me bit,I tried as u suggested but no use.

Thanks&regds,

Nicky.

Re: Sort

former_member125931 — Tue, 24 Jun 2008 14:58:09 GMT

Hi,

Here I am using like below

Sort itab by text.

loop at itab into wa.

collect wa into itab.

sort itab by num.

endloop.

but here numerical value became increment.

can u suggest me how to proceed.

Thanks&regds,

Nicky.

Re: Sort

JozsefSzikszai — Tue, 24 Jun 2008 15:01:22 GMT

-if the internal table has header line, than forget the LOOP and just do, what I suggested above

-if the internal table has NO header line, than you'll need a 2nd internal table (same as the first) and you have to code like:

Sort itab by text.

loop at itab into wa.

collect wa into itab2.

endloop.

sort itab2 by num DESCENDING.

pls. see the differences to your code:

COLLECT into itab2

SORT outside the LOOP and DESCENDING

Re: Sort

former_member125931 — Tue, 24 Jun 2008 15:23:05 GMT

Hi Eric,

It is not doing any sum.

Thanks&regds,

Nicky.

Re: Sort

JozsefSzikszai — Tue, 24 Jun 2008 15:34:12 GMT

how did you define the internal table? probably the number field is not defined as type n/p/i ?

Re: Sort

former_member125931 — Tue, 24 Jun 2008 15:38:08 GMT

HI Eric,

collect statement is not working.

thanks&regds,

Nicky.

Re: Sort

JozsefSzikszai — Tue, 24 Jun 2008 15:39:22 GMT

just copy here the internal table definition.

Re: Sort

former_member125931 — Tue, 24 Jun 2008 15:44:19 GMT

Hi Eric,

Numeric field is decimal type.

Re: Sort

JozsefSzikszai — Tue, 24 Jun 2008 15:45:31 GMT

I ask you third time: Copy here the definition of the internal table! The whole table, not just the number field!