10-16-2012 10:33 AM
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.
Please help.
Moderator message : Not enough re-search before posting, discussion locked
Message was edited by: Vinod Kumar
10-16-2012 10:58 AM
10-16-2012 11:26 AM
Thanks Kumar.
Already tried with COLLECT but it does not give the accurate result.