I have to implement one scenario, for which i need your help.
Scenario is like this:
I purchased one material from the vendor with the MAP of Rs.10
Next time i purchased same material with the price of 8, so avg. MAP becomes 9.
Now i want to consume the material the against the vendor.
A per my knowledge while consumption system book the consumption value based on the current price in material master but i want to book the consumption i such a way that first system has to check all the existing purchased orders for that material and whichever price is higher system should take that price into consideration for consumption.
Is it possible with standard features of SAP ?? If yes, then how??