How to sum internal table column value with some common field value ?

[former_member308418]

Dear all,

The above question is very similar to others questions, though I am facing some difficulty doing this. Please help me. My problem is,

In my internal table i'm selecting data from mseg table and based on bwart data in menge field will go on different columns like if bwart = '101' data will go to GRN column, if bwart = '303' data will go to TPN field. I have to add the values of GRNs if matnr , werks and budat are same.

Budat	Matnr	Menge1	Menge2
01.01.2012	2000001	10	0
		15	5
01.02.2012	2000002	30	5
01.03.2012	2000003	100	10
		12	10

I need to have the following result:

Budat	Matnr	Menge1	Menge2
01.01.2012	2000001	25	5
01.02.2012	2000002	30	5
01.03.2012	2000003	112	20

Here I tried with At End Of matnr.

                        sum.

                         endat

But it not works as I am using conditional statement here.

Loop at itab into wa_it.

CASE WA_IT-BWART.

       WHEN '101' OR '305'.

         WA_FINAL-MENGEG = WA_IT-MENGE.

       WHEN '303'.

        WA_FINAL-MENGET = WA_IT-MENGE.

       WHEN '231' OR '251'.

         WA_FINAL-MENGES = WA_IT-MENGE.

       WHEN '551' OR 'Z01'.

         WA_FINAL-MENGEW = WA_IT-MENGE.

     ENDCASE.

     APPEND WA_FINAL TO IT_FINAL.

     CLEAR WA_FINAL.

   ENDLOOP.

   Please help.

Moderator message : Not enough re-search before posting, discussion locked

Message was edited by: Vinod Kumar

[gouravkumar64]

Hi,

Try with collect instead of APPEND.

Try this

Thanks

Gourav.

[former_member308418]

Thanks Kumar.

Already tried with COLLECT but it does not give the accurate result.