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.