Look up table update

[Former Member]

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

[Former Member]

Hey Kumar,

I haven't understood the purpose of this replication,

it is allways recommended to use the master table

If you persist do this replication,

than you must be aware that the replication might take some time,

which means, the XI table will not be up-to-date every time.

I would suggest to use the table change logging, to find the changes in the table

for more information:

http://help.sap.com/saphelp_nw04/helpdata/en/7e/c81ebb52c511d182c50000e829fbfe/frameset.htm

I remind you that it is prefer

use the master table (and not creating a slave)