Delta Loads for 2LIS_13_VDITM

Dear SAP Gurus,

I have come across an interesting situation and would like to share with you all. The datasource 2LIS_13_VDITM provides delta loads to an ODS (ZODS_13). For following records the analysis is as follows:

1. DATE X1.YY.ZZZZ Amt +100 against a fwd invoice type 'P' is updated in ODS. (ROCANCEL field of datasource is BLANK).

Later on a future date above invoice is cancelled using a cancelled invoice type 'S1'. (Cancellation in SAP means a new cancel invoice w.r.t the old fwd invoice). Old invoice gets mark in the field FKSTO 'X' indicating cancellation.

2. DATE X2.YY.ZZZZ Amt -100 against a cancel invoice type 'S1' is updated in ODS. (ROCANCEL field of datasource is BLANK).

3. DATE X2.YY.ZZZZ Amt -100 against the old fwd invoice type 'P' is updated in ODS. (ROCANCEL field of datasource is 'X').

The result on account of 1, 2, and 3 is as follows:

NET SALE = +100 -100 -100. That is, total = -100. (if ODS aggregation type)

NET SALE = -100 -100. That is, total = -200. (if ODS overwrite type)

Now, the negation of key figure in point 3 is as a result of standard delta process wherein change is marked by ROCANCEL field equal to 'X'. However, this is resulting in the net figures going wrong. I have solved the issue at reporting level. However, would like to know is there any other way to get the Total Values reflected correctly.

Regards

Waseem Akhtar.