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.