topic Re: SAP - External DB in Application Development and Automation Discussions

SAP - External DB

Former Member — Sat, 08 Oct 2005 20:27:55 GMT

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.

Re: SAP - External DB

Former Member — Sun, 09 Oct 2005 16:35:15 GMT

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

Re: SAP - External DB

RichHeilman — Sun, 09 Oct 2005 18:10:28 GMT

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

Re: SAP - External DB

Former Member — Mon, 10 Oct 2005 03:58:23 GMT

other way is to use LSMW

regards

Re: SAP - External DB

Former Member — Mon, 10 Oct 2005 14:41:22 GMT

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.

Re: SAP - External DB

RichHeilman — Mon, 10 Oct 2005 14:45:00 GMT

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

Re: SAP - External DB

RichHeilman — Mon, 10 Oct 2005 14:51:07 GMT

Also, please refer to OSS notes 323151,

339092, 178949 for details.

Regards,

Rich Heilman