Skip to Content
0
Former Member
Nov 30, 2009 at 11:57 PM

UPDATE_INSERT problem

38 Views

Hi all,

I am using UPDATE_INSERT in the mapping for the receiver JDBC scenario.

As name says, update and insert should be done. Updates for any row that has been changed, else the new rows should be inserted.

The problem that I am having is - say I insert 4 rows. Then I change 1 of the rows in the source system and re-send those 4 rows again (3 old and 1 changed). So, it should only update the 1 changed row and nothing else should happen.

But it is over-writing the all the 4 records with the 1st record (I changed the values in the 2nd row). So, 4 rows are there after the 2nd run, but all the rows are having the same value as the 1st row.

I am following the structure prescribed in SAP document and using a Key field.

Where I am doing wrong? Any suggestions will be highly appreciated.

Thanks,

Abhi