Code

Hi,

I have data coming from R/3 like:

A B C D KF

P100 10 V1 1/1/08 100

P100 10 V1 1/3/08 250

P100 10 V1 2/6/08 400

P100 50 V1 3/5/08 300

P100 50 V1 4/6/08 550

P100 50 V1 4/26/08 800

But I need to update this into ODS like:

A B C D KF

P100 10 V1 1/1/08 100

P100 10 V1 1/3/08 150 (250-100)

P100 10 V1 2/6/08 150 (400-250)

P100 50 V1 3/5/08 300

P100 50 V1 4/6/08 250 (550-300)

P100 50 V1 4/26/08 250 (800-550)

So I need to subtract the data with the previous posting data where fields A, B and C are same. Previous posting can be 1 day before or any....I need this to be done at update rules level!!

Plz help me out in this.