Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from horacio zapettini on Dec 12 at 9:53 AM Totally agree... :)
| | | ---------------Original Message---------------
From: Louis Corato
Sent: Wednesday, December 12, 2012 9:45 AM
Subject: Code at Infoset SQ02 - Use the Current Line When Processing
Soufiane - I've been reading the threads and I would like to offer another alternative. First, I agree with Horacio (as always) that unless you limit this query in some way other than just the movement type, this query will only get worse with time and will not produce results at some point - it will just dump out due to the volume of data.
That said, I would suggest creating your own hashed table of values to sum the amounts by material in the code before the selection area starts. Declare the hashed table in the DATA area, and then do the selection once, up front, before the query starts its selection. This would be an independent grab of data that would be put into the hashed table. As each record then processes, you would use a READ statement based on material (there should be only one with a net value of 911's and 912's) and read that summed value into the field you're using in the query on a record-by-record basis.
You would not necessarily do this in an ABAP program this way, but in a query, it's a better method to get the data you want once, and not keep going through the same tables over and over again.
Good luck!
- Lou |
| Reply to this email to post your response. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
