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