Delete all the entries in target table when message mapping?

[Former Member]

Hello Gurus,

I have a requirement in the project. When I do message mapping, I need to delete all the entries in the target table and then insert the new rows. From searching the old posts, I know it is possible without BPM. Can anyone please help me out? I really appreciated it.

Regards,

Bai

[Former Member · Accepted solution]

Hi,

in msg mapping, in target JDBC structure have 2 table nodes......in first have action as DELETE and table as TABLE_NAME without any field conditions......in second have action as INSERT and table as TABLE_NAME and fields in access node......

[Former Member]

Thanks for your replies. It worked fine. However there is another outstanding issue. WHen I send 2250 records in 1000 package size, there will be only 250 entries inserted in the JDBC table. That is because 2250 records have been splited up to three messages (1000/1000/250). Each message carries a DELETE action. If I send one message with 2250 records, there is no problems. Any idea how to resolve it? I tried to find a simple solution to resolve it. Thanks.

[Former Member]

Hi Bai,

Check the below links:

http://help.sap.com/saphelp_nwpi711/helpdata/en/43/9519abb1146353e10000000a11466f/frameset.htm

Defining a DELETE Statement

http://help.sap.com/saphelp_nwpi711/helpdata/en/44/7b6e85fde93673e10000000a114a6b/content.htm

Thanks,