Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Jun 26 at 11:07 AM Hi, Sarah -
What do you expect to see when this runs? If you're looking to see nothing in the zassign field UNTIL the zuonr changes, then what you have will not do it. I beleive you need to adopt more of an approach that would accumulate the value into somewhere, and once you know the zuonr has changed (using two fields to know "what do I have now vs. what did I have the last time this calculation was performed"), populate the zassign field based on the accumulator to that point, and then clear the accumulator and start over.
The code you have might work in straight ABAP, but not in an infoset.
Now, if you want to start by pulling all the records from BSID, putting them into an internal hash table and then doing a read from that table when the zuonr changes, THAT might work, but it's much more complex.
Your ABAPer should be able to help.
Lou
| | | ---------------Original Message---------------
From: Sarah Cope
Sent: Tuesday, June 26, 2012 9:54 AM
Subject: Subtotal in SQ02:
Hi,
I would like to create a sub-total of amounts in SQ02.
I have written:
"select sum( DMBTR ) from BSID
into ZASSIGN
group by (BSID-ZUONR).
endselect."
Where ZASSIGN is my user-defined field to output the subtotal, DMBTR is the field I would like to total. ZUONR is the "assignment "field I would like to use as the basis as the sub-total ie a sub-total at each change in assignment field.
Any help gratefully appreciated. |
| 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.   _.____.__ |
