Skip to Content
avatar image
Former Member

Read from DSO rule type along with key figure summation

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 28, 2015 at 04:29 PM

    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.

    Lookup in SAP BW

    Regards

    Karthik


    Add comment
    10|10000 characters needed characters exceeded

  • Oct 28, 2015 at 05:24 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded