Skip to Content
0
Former Member
Jun 02, 2008 at 05:33 AM

Is there any Advantage for creating custom table in XI instead of R/3

133 Views

Hi,

I have scenario where i need to exract data from SQL server and pass the key fields to custom table (Is there any advantage for creating custom table in XI instead of R/3) and get the corresponding records and do some calculation and mapp the fields to appropriate segment fields of the shipment idoc SHIPMENT_CREATEFROMDATA01?and i need to update the read flag as well once the record has been read from the SQL Server table.

I suggested to create custom tables in R/3 for this scenario,but the client is asking what is the advantage of creating custom tables in R/3 instead of XI.

These are the possible methods for doing the scenario:

which method i have to choose if the custom table created in XI

1) JDBC to ABAP Proxy -

2) JDBC to IDOC using RFC Lokups

3) JDBC to IDOC using BPM------ Not recommanded

altimatly i need to pass the final data to standard idoc:SHIPMENT_CREATEFROMDATA01 which creates the idoc in R/3 system.

Please suggest me to do this scenario whether i need to create custom table in XI or R/3? advantages and disadvatages for both?

Regards,

Bhoj