SAP - External DB

[Former Member]

Hello, i have an external database with data that must be imported into sap tables periodically. What would you recommend for this? writing a program on java and connect it to sap and then calling a function module to store de data?

thanks in advance,

Unknown.

[Former Member]

I will recommend writing an ABAP program and schedule it as a batch job (recurring). To connect to external database from ABAP program refer to following mails -

http://www.sapfans.com/sapfans/forum/intface/messages/4289.html

and

Cheers,

Sanjeev

[RichHeilman]

You could write a java program to call an RFC enabled function module via jCo to load the data into SAP table. You could also write an ABAP program using native SQL to retrieve the data from the external database.

Regards,

Rich Heilman

[Former Member]

other way is to use LSMW

regards

[Former Member]

Hi, thanks everyone for your responses, which way is easier and better? writing abap program or the abap connection mode?

are there any standard bapis to write tables or do i have to create them?

thanks in advance.

[RichHeilman]

I would say that using native SQL in an ABAP program would be easier. Check out this link.

http://help.sap.com/saphelp_46c/helpdata/EN/b3/277977713411d194c20000e8353423/frameset.htm

Please remember to award points for helpful answers. Thanks.

Regards,

Rich Heilman

[RichHeilman]

Also, please refer to OSS notes 323151,

339092, 178949 for details.

Regards,

Rich Heilman