Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question