Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Dec 12 at 6:33 AM Good morning!
Well.... You have a couple of possibilities:
Easiest one: create a new field to evaluate reserved qty.
in this field you can write the code (i'm using a pseudocode here...)
case movement
when 911 then reserved qty
when 912 then reserved qty * -1
when others 0
So in this field you have the values you want to sumarize.
In the infoset query you'd have to do play with the total...
A different alternative would be to remove mseg from the join. Then you could add two calculated fields: one that totalizes the reserved qty in the way you want (by matnr...) and a second select to evaluate the join conditions...
As said in a previous post, none of these are going to be easy to implement...
IMO, you should go for a report (it'd be cheaper, easier to develop and easier to maintain...)
HTH
Horacio
PS: BTW, I don't know the filters you're creating and the join condition, but IMO, this query can lead to work with all the records in MSEG, and as this table holds a huge number of records... this could lead the report to a dump....
On the other hand if keep the join and you manage yourself to write the extras selects on mseg, you could go into a dump again (depending on the way you code that inner select that sums the reserved qty...)
| | | ---------------Original Message---------------
From: soufiane669
Sent: Wednesday, December 12, 2012 3:13 AM
Subject: Code at Infoset SQ02 - Use the Current Line When Processing
Yes, that's exactly what I need.
Soufiane |
| Reply to this email to post your response. __.____._ |   _.____.__ |
