Skip to Content
0
Mar 02, 2009 at 06:19 AM

SUM in ITAB

51 Views

hi guru's,

i have 5 fields in ITAB and 3 fields are numeric like below :

ITAB :

MATNR .... UNIT ..... QUANTITY ..... TOT_STOCK ..... BAL_QUANTITY

AAAA .... . NOS ..... 20 ......... 45 ........ 25

AAAA .... . NOS ..... 15 ......... 60 ........ 45

BBBB .... . NOS ..... 50 ......... 45 ........ 05

CCCC .... . KG ..... 15 ......... 60 ........ 45

CCCC .... . KG ..... 10 ......... 30 ........ 20

and i need add QUANTITY, TOT_STOCK and BAL_QUANTITY for same material and have to display single material.

i need final itab like this:

ITAB :

MATNR .... UNIT ..... QUANTITY ..... TOT_STOCK ..... BAL_QUANTITY

AAAA .... . NOS ..... 35 ......... 105 ........ 70

BBBB .... . NOS ..... 50 ......... 45 ........ 05

CCCC .... . NOS ..... 25 ......... 90 ........ 65

can anyone please help me?

regards saurabh.