Skip to Content
avatar image
Former Member

Overwrite function not working in DSO.

Hi Guys,

I have a DSO1 with Key field as MATNR and Inspection lot no. , as per the requirement I have calculated Average lot quantity per Material using a routine. The Avg. lot quantity is populating in every material as shown in the below image. The only field which makes the record unique is Inspection lot number (PRUEFLOS), Average Does not depend on year also.

Now I am populating this data in DSO2 with key field as MATNR as i want single MATNR corresponding to an single Average lot Quantity.But my output is coming as shown below:

What is happening is Avg. lot Qty is getting summed up in the result.

Please tell me what i should do so that the Avg lot Qty doesnt add up in the DSO and just shows me one correct value as shown in DSO1.

Regards,

Pulkit

pic1.jpg (37.5 kB)
pic2.jpg (23.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 21, 2015 at 02:05 PM

    Hi Pulkit

    Please paste the code that you have written to calculate the average lot qty.

    Also give the output of 2012 in the second DSO to check how the source data has changed based on your routine code. (the screenshot that is provided now has 2013 as year and it doesn't sum up the four entries in your source)

    Regards

    Karthik

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Karthik Vasudevan

      Hi Kartik and Jyothi,

      SORT didnt work, but i tried what jyothi suggested, using semantic key and it worked.

      Thanks a lot Kartik and Jyothi for your time n help.

      Regards,

      Pulkit

  • avatar image
    Former Member
    Oct 22, 2015 at 02:19 PM

    hi

    in the second dso you can create a key figure not cumulative and map it on the dso1 key figure

    hope it helps

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Andrea,

      I tried that, but it didnt work. The results were still getting summed up.

      Regards,

      Pulkit