Skip to Content
0
Former Member
Sep 22, 2008 at 07:12 PM

Delta after image/before image issue with 2LIS_04_P_MATNR

116 Views

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