What is the best way to import/export data between an SQL server and SAP?
You can use EXEC SQL to issue SQL to the SQL server. Once you have read the data, you can bring it into SAP using BAPIs, IDOCs or BDC. For Oracle databases, SAP suggest the procedure outline in OSS note 25383 - Database links, synonyms, remote DB.
Dig Deeper on SAP ABAP
Related Q&A from Matthew Billingham
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading
A SearchSAP.com reader wants to know if it's possible to write an SAP ABAP program that will read source code and then create an SAP ABAP function ... Continue Reading