Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from soufiane669 on Dec 11 at 11:12 AM Hello, I don't want to do 2 selects, only one to catch the sum of the quantity reserved in a reservation where the movement type = 911. My query is as following: Select sum(mseg~menge) into calculated_field from mseg where movement_typ = '911' group by mseg~matnr. Is this query going to populate correctly my calculated field, because when i test it dump for space overflow issue. Thanks by advance, Soufiane
| | | ---------------Original Message--------------- From: soufiane669 Sent: Tuesday, December 11, 2012 10:06 AM Subject: Code at Infoset SQ02 - Use the Current Line When Processing Hello every one, I want to add some abap code in infoset SQ02 to calculate an additional field: In the infoset i'm joining the 2 tables RESB and MSEG and i want to calculate for each reservation of material => sum(reserved quantity) where movement type = 911 MINUS sum(reserved quantity) where movement type = 912 where the material = current line. That's why i want to use the value of the current line material otherwise the select will populate the additional field with the same result for all the records. Please to help me Regards, Soufiane | | Reply to this email to post your response. __.____._ | _.____.__ |