topic Re: Export SAP data into Sql tables from sap side only. in Application Development and Automation Discussions

Export SAP data into Sql tables from sap side only.

Former Member — Tue, 31 Dec 2013 11:05:32 GMT

Hi Expert,

Pls share me, how to push sap data into SQL table from abap side.

Thanks & Regards,

M. Ali

Re: Export SAP data into Sql tables from sap side only.

Former Member — Wed, 01 Jan 2014 07:33:31 GMT

Hi Ali,

Could you elaborate your issue.

Regards,

Aditya Tanguturi.

Re: Export SAP data into Sql tables from sap side only.

Former Member — Thu, 02 Jan 2014 05:48:03 GMT

Dear Aditya,

My client has created some SQL tables(like mara table etc.) in SQL side and they want to move data from sap table(like mara table etc) into corresponding SQL tables.

And also they do not want use RFC, BAPI and ALE/IDOC..They have created connection using DBCO TCode and they are telling that to do it using ABAP coding only.

Pls Aditya share me it is possible using Native SQL..if yes then how? or tell me other way, if possible..

Thanks

Mudassar

Re: Export SAP data into Sql tables from sap side only.

nabheetscn — Thu, 02 Jan 2014 05:53:19 GMT

Yes you will have to use NATIVE SQL in this case. Fetch all the data using open SQL and then insert using Native SQL.

Please search SCN for the same

Nabheet

Re: Export SAP data into Sql tables from sap side only.

Former Member — Thu, 02 Jan 2014 06:04:17 GMT

Thanks Nabheet..can you share me some sample code for the same..

Rgrds,

Mudassar

Re: Export SAP data into Sql tables from sap side only.

Former Member — Thu, 22 Jan 2015 06:47:24 GMT

Dear Mudassar Ali,

Have found the way to solve this thing?
i am also in search of exactly same thing.....
please share the ABAP Code and also tell me how you have created connection using TCODE DBCO?

Thanking you in advance

Re: Export SAP data into Sql tables from sap side only.

Former Member — Thu, 22 Jan 2015 10:42:47 GMT

Dear Akhtar,

Actually, basis guys are responsible to create database connectivity between sap and other server using DBCO tcode.

Here, I have written some coding example for native SQL.

DATA: dbs TYPE dbcon-con_name VALUE 'CTDWTEST'. "Connection opening

EXEC SQL.

CONNECT dbs.

ENDEXEC.

"To Push the records into native database.

EXEC SQL.

INSERT INTO native_table_name ( mention here all native table's fields separated by comma )

VALUE (Write here all internal table's fields separated by colon and comma, Ex- :wa_test-matnr, :wa_test-werks, :wa_test,)

ENDEXEC.