topic Re: processing internal table in Application Development and Automation Discussions

processing internal table

Former Member — Wed, 07 Dec 2005 15:24:58 GMT

Hi all,

In internal table i have data with vornr matnr and other fields.

My requirement is for each material number i have to sort the internal table descending with vornr for furthur processing.

My code is working fine with one material.but with more than one its not working.

ex:

internal table itab.

vornr matnr

1200 18

1800 18

1300 18

1100 19

900 19

1800 19.

Result table should be like this:

vornr matnr

1800 18

1300 18

1200 18

1800 19

1100 19

900 19.

Please help me.

regards

Chandu.

Re: processing internal table

Former Member — Wed, 07 Dec 2005 15:27:00 GMT

use "sort itab by vornr" statement..

oops i didn't read it throroughly..

first move the contents to another itab.

say itab1

whose structure is Matnr|Vornr

move the contents of itab to itab1.

sort itab1 by matnr vornr.

then move the contents bacl to itab.

Message was edited by: Ravi Kanth Talagana

Re: processing internal table

FredericGirod — Wed, 07 Dec 2005 15:28:15 GMT

and matnr

so -> sort itab by vornr matnr

Re: processing internal table

Former Member — Wed, 07 Dec 2005 15:29:14 GMT

sort itab by matnr

vornr descending .

Alexandre Nogueira

Re: processing internal table

Former Member — Wed, 07 Dec 2005 15:29:23 GMT

hi ravi,

i used the statement but its working fine for only one material.

Re: processing internal table

Former Member — Wed, 07 Dec 2005 15:33:05 GMT

I have edited my message, just look at it again.

Cheers Ravi

data: begin of itab occurs 0,

matnr like mara-matnr,

vornr....,

end of itab.

data: begin of itab1 occurs 0,

vornr....,

matnr like mara-matnr,

end of itab.

loop at itab.

move-corresponding itab to itab1.

append itab1.

clear itab1.

endloop.

refresh itab.

sort itab1 by vornr matnr.

loop at itab1.

move-corresponding itab to itab.

append itab.

clear itab.

endloop.

Regards,

Ravi

Re: processing internal table

Former Member — Wed, 07 Dec 2005 15:34:11 GMT

Hi alexandar and federik,

If i use sort itab by vornr matnr descending.

then the result is

vornr matnr

1800 18

1800 19

1300 18

1200 18

1100 19

900 19. instead of.

vornr matnr

1800 18

1300 18

1200 18

1800 19

1100 19

900 19.

I hope you understand

Re: processing internal table

Former Member — Wed, 07 Dec 2005 15:34:52 GMT

Hi Sai,

Simply

sort itab by matnr vornr descending.

Thanks

eswar

Re: processing internal table

Former Member — Wed, 07 Dec 2005 15:38:53 GMT

So,

Change it to:

sort itab by matnr ascending

vornr descending .

Alexandre Nogueira

Re: processing internal table

FredericGirod — Wed, 07 Dec 2005 15:38:54 GMT

I don't know if SAP will like that, but you would like to do :

sort itab by matnr ascending vornr descending.

Fred

Re: processing internal table

Former Member — Wed, 07 Dec 2005 15:43:47 GMT

Hi all,

Thanks alot once again...

Re: processing internal table

Former Member — Wed, 07 Dec 2005 15:46:24 GMT

Hi Sai,

For your info. After matnr no need to give ascending..its default.

Thanks

Eswar