Delta after image/before image issue with 2LIS_04_P_MATNR
Hello,
I have a problem with the delta functionality for the below scenario
We have implemented datasource 2LIS_04_P_MATNR. Here are the sequence of steps happening.
Initial value in order in R/3
PO QTY SCRP QTy
600003335 5 1
Filled up the setup tables
Initialized the data load to BI and BI shows the vales as below which is correct.
PO QTY SCRP QTy
600003335 5 1
Changed the qty to 6 and 1.5 in R/3
Loaded Delta
PSA shows as below.
ROCANCEL PO QTY SCRP QTY
600003335 6 1.5
X 600003335 -5 -1
Loaded the data into DSO
New table
Strno 0Recordmode Order Qty Scrp qty
X <BLANK> 600003335 -5 -1
Activated the data in DSO
Change log
Strno 0Recordmode Order Qty Scrp qty
X <BLANK> 600003335 -5 -1
<BLANK> X 600003335 -5 -1
<BLANK> N 600003335 5 1
Active Table
Strno 0Recordmode Order Qty Scrp qty
X <BLANK> 600003335 -5 -1
Ideally the active table should show as
Strno 0Recordmode Order Qty Scrp qty
X <BLANK> 600003335 6 1.5
but its showing as -5 and -1.
Can anyone help me with this. The keyfigures has overwrite functionality.
Any help would be highly appreciated and rewarded.
Regards,
KK