Capturing old Price

[Former Member]

we have table in ECC where we have Prices based on Customer and material (millions of records). This table table maintains just latest price.

ECC

Customer	Material	Price	Price Change Date
1000	Advil	5.95	11/01/2013
2000	Tylenol	4.93	05/04/2014
3000	Motrin	9	01/01/2015

Say the price changes for customer/material (1000, Advil), from 5.95 to 6 on 05/05/2015. In BW I need to capture both 5.95 and 6. along with Price change date

I will need to have BW table like this

Customer	Material	New Price	Old Price	Price Change Date
1000	Advil	6	5.95	05/05/2015
2000	Tylenol	4.93		05/04/2014
3000	Motrin	9		01/01/2014

Any idea on above logic is appreciated

Thanks,

Vinay

[Loed]

Hi,

My idea is to include the NEW_PRICE, OLD_PRICE, and PRICE_CHANGE_DATE objects as ATTRIBUTES of your 0MATERIAL masterdata and do an END ROUTINE to compare the DELTA load to your existing masterdata..

Regards,

Loed