Skip to Content
0
Former Member
May 30, 2008 at 09:51 AM

Extract Data from SQL Server table and create IDOC in R/3- Urgent

323 Views

Hi,

I have scenario where i need to exract data from SQL server and pass the key fields to 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 can do this scenario by

1) JDBC to ABAP Proxy -

2) JDBC to IDOC using RFC Lokups

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

Please suggest me which method is good for doing this scenario without BPM Please?

Regards,

Bhoj