cancel
Showing results for 
Search instead for 
Did you mean: 

Read from DSO rule type along with key figure summation

aadilmohammed
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member976
Active Contributor
0 Kudos

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.

karthik_vasudevan
Active Contributor
0 Kudos

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