Skip to Content
0
Former Member
Feb 15, 2017 at 07:07 PM

Infocube Post Update due to price change

172 Views Last edit Feb 18, 2017 at 08:00 AM 3 rev

Dear Experts,

We have a Infocube contains the following Data.

0Material (Key) 0Plant(Key) 0Calmonth(Key) Material-Average Invoice Price

32009 313 01.2016 1,3

32009 313 02.2016 1,4

The Material Invoice Price is caculated ( sum(monthly Amount) / sum(monthly Quantity) )in end routine though abap look up based on the data of another DSO (invoice document level DSO) which contrains the following data.

Invoice Doc.Nr.(Key) Invoice Doc. Item(Key) Posting Date(Key) Material Invoice Amount Invoice Quantity

4150002938 10 01.01.2016 32009 13 10

4190000293 20 03.02.2016 32009 14 10

But we have noticed that the Invoice Price in the look up DSO can change after some times. For exsample.

In invoice document Level DSO we have a new record in term of Material 32009 after look up the invoice Price in Infocube .

4150002939 10 32009 10 10 15.01.2016

So, the Material (32009) invoice Price at 01.2016 is not 1,3 any more but (10+13)/(10+10)= 1.15

I would like to know how I can change the old invoice Price in Infocube automated wenn we receive new invoice document in Terms of a old date.