Look up table update

Hello Friends,

I have a scenario like this...

The lookup tables will exist in SAP and in the XI environment with the difference being that SAP will contain the source (or master) tables and XI will hold the target (or slave) tables. Any new data created (or changed) in the lookup table in SAP will need to be reflected in the lookup table of the middleware (XI) environment.

I will be uploading a file with all the records and in XI we have a look up table which needs to be updated. Now when there is an error while updating this lookup table then I need to create a file or send a mail with all the failed records.

Can you please suggest me how to proceed on this case.

Waiting for your valuable suggestions..

Thanks & Regards,

Kumar