sort internal table

Hai,

Sort matnr(2nd field)--> First

and then Vbeln(Ist Field) --> Second

Thanks & regards

Sreeni

You have to loop at the table and calculate the totals using the AT NEW event provided it is SORTED by MATNR.

regards

Ravi

Note : Please mark all the helpful answers

loop at itab.

at new matnr.

sum.

...

...

endloop.

data: xtab like line of itab.

loop at itab.

xtab = itab.

total = total + xtab-kwmeng.

at end of matnr.
Write:/ total.
clear total.
endat.

endloop.

Regards,

Rich Heilman

try this, just changing the SORT order

sort itab by matnr vbeln.

regards

srikanth

---If not wrong you wish to have the total on material and not document+material ..correct ---in that case

please note AT Event wont work for MATNR since you have the first field in your table as VBELN. So even if the Matnr is same but different VBELN...the at event would be triggered.

The only way is to SORT the table with MATNR and VBELN.

and use the on change event...as shown below. Unfortunately you would need a separate loop.

sort itab by matnr vbeln.

loop at itab.

l_sum = l_sum + qty.

on change of matnr.

write : / l_sum.

clear l_sum.

endon.

endloop.

Message was edited by: Anurag Bankley

Hi Sdn,

Try with this code.

<b>SORT ITAB BY MATNR VBELN.</b>

<b>LOOP AT ITAB.</b>

AT END OF MATNR.

<b>SUM.</b>

WRITE:/ ITAB-MATNR, ITAB-QTY.

ENDAT.

<b>ENDLOOP.</b>

Thanks,

Vinay

Message was edited by: Vinaykumar G

Try this.

Loop at itab.

at new matnr.

sum.

write: itab-(field to be totaled)

endat.

Endloop.

HI,

Sort the second field first.

Regards,

Laxmi.