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.