SAP DATA PROVIDER (KONV Table from SAP server Oracle to SQL server)

[Former Member]

Hi All,

I do not really know much about the SAP.So, please excuse for my ignorance.I have a SAP installed on oracle.For our reporting purposes we would want to move KONV table from SAP to SQL server.As i was looking for option , i found that this can be accomplished by using SAP data for SQL server.As per the documentation i should installSAP DLL librfc32.dl (using SAP GUI.exe ) on my machine.Once i have that done ,Two custom Remote Function Calls (RFCs) must be installed on the SAP server. The RFCs are installed first on the same computer as the SAP DLL, and then are transported to the SAP server by SAP Admin.

Please explain how can i create these RFC's and how complicated is it.All i want to do is to copy KONV from SAP to SQL server. Please help me as this is an urgent issue for us.

Thanks...........

[Former Member]

Hi,

There are many ways to export data from Oracle to SQL Server. Personally, I choose to export table content to CSV file , by developing a small ABAP program something like, below;

SELECT * FROM KONV INTO TABLE ITAB_KONV.

CALL FUNCTION 'SAP_CONVERT_TO_CSV_FORMAT'
EXPORTING
i_field_seperator    = ';'
TABLES
i_tab_sap_data = ITAB_KONV
CHANGING
i_tab_converted_data = ITAB_CSV.

CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
filename = 'C:\konv.csv'
TABLES
data_tab = ITAB_CSV.

Then, import the CSV file into the SQL server, by using SQL Server Import and Export Wizard.

You can export the table of content by using PL/SQL commands, also. You can find many example scripts over the internet.

Best regards,

Orkun Gedik