topic Re: Sending and Receiving data to/from SQL server in Application Development and Automation Discussions

Sending and Receiving data to/from SQL server

Former Member — Thu, 13 Apr 2006 22:19:24 GMT

Hi,

I am developing a custom dialog programming screen in SAP.

The user will enter Sales Order number on the screen and clicks on a button.

The Sales order details should be passed to Microsoft SQL server and saved in a table. An event runs immediately in SQL server to process this data passed from SAP and saves the results in second table in SQL server. Then SAP has to pull the data from this second table in SQL server and display the results on the second screen in the custom screen in SAP.

All of this should happen when the user clicks the button on the first screen of SAP transaction.

How can I send data to SQL server and wait in the same transaction to get back the results from SQL server?

Your thoughts are greatly appreciated.

Thanks,

Ashok.

Re: Sending and Receiving data to/from SQL server

RichHeilman — Thu, 13 Apr 2006 23:05:16 GMT

You need to write to SQL server which is not the underlying database of the SAP system? If so, you can use Native SQL to connect to the other SQL server.

Search forum for Native SQL

Regards,

Rich Heilman

Re: Sending and Receiving data to/from SQL server

Former Member — Fri, 14 Apr 2006 11:23:32 GMT

Hi,

After sending the data to SQL server from SAP, the data is processed in SQL server and the results are stored in a table in SQL server.

I want to get send the data from SAP and get back the results from SQL server in the same transaction/program.

How do I do that in ABAP program?

Thanks,

Ashok.

Re: Sending and Receiving data to/from SQL server

Former Member — Fri, 14 Apr 2006 11:24:59 GMT

Thanks Rich.

After sending the data to SQL server from SAP, the data is processed in SQL server and the results are stored in a table in SQL server.

I want to get send the data from SAP and get back the results from SQL server in the same transaction/program.

How do I do that in ABAP program?

Thanks,

Ashok.

Re: Sending and Receiving data to/from SQL server

Former Member — Fri, 14 Apr 2006 11:40:22 GMT

Hi Ashok !!

You can do this only if you have yor sap installed on Windows platform. Then you shoul create connection do SQL Server in DBCO transaction, and tehen use native sql in abap program. If you have Sap installed in non-windows platofrm you should install Busiines Connector or XI.

Bussiness Connector is free !!

BR, Jacek