Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP - External DB

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

6 REPLIES 6

Former Member
0 Kudos

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
Developer Advocate
Developer Advocate
0 Kudos

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
0 Kudos

other way is to use LSMW

regards

Former Member
0 Kudos

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.

0 Kudos

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

0 Kudos

Also, please refer to OSS notes 323151,

339092, 178949 for details.

Regards,

Rich Heilman