on 10-28-2015 8:05 AM
Hello all,
I want to read a key figure from a DSO in my transformation and sum it up if there are multiple keys in the lookup DSO. Is this possible with the Read from DSO rule type along with key figure aggregation type 'summation'? Currently what I'm seeing is that it is not adding up but reading only one line and displaying that in the target.
Thanks
Aadil
HI,
yes you can achevie easely using start routine.
create the one internal table along with all key fields and use the particular key figure.
use the key figure propaty as summation.
ex - one PO have different line items and with key figure values as summation.
if you load every time it will sum the total values.
Thanks,
Phani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Aadil
As you have already checked this way, its clear that this rule type will not help for your expectation.
Please try using field routine or end routine.
Even when doing this, you should remember to fetch the sum (your keyfigure) as DSO will store data in detailed manner based on the key fields
The below link will give an clear explanation with an example. Try this way and you could achieve what you need.
Regards
Karthik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.