RFC-requst from SAP with reply

[Former Member]

Hi.

I got an RFC-call from SAP with this RFC.:

INPUT_From_SAP

From_date
To_Date
Custumbernumber

INPUT_To_SAP

Crdnbr

Matnr

Qty

The issue is that I got a request from SAP and I'm going to send it to an DB2 database for selecting some data with SQL, and then send the same RFC back to SAP within the same RFC.i.e. The INPUT´_To_SAP shall bring the ruturndata and

INPUT_From_SAP is the request-data.

How can I do this and what kind of adapter can I use?

Can it be done?

This interface is an online-interface and need some good performance.

Very glad if someone could help me with this.

Thanks.

[Former Member · Accepted solution]

Hi,

Using XI JDBC adapter you can directly extract /fetch data from DB. So here you need RFC adapter and JDBC adapter.

RFC adapter used to call RFC function module...and base on the rfc response you can build your select query and directly fetch data from DB using JDBC adapter.

Let us know if you need more details.

Nilesh

[Former Member · Accepted solution]

Thanks.

But how should I set up the JDBC-reciever adapter

[Former Member · Accepted solution]

I have very good doc on this...send me u r email id.

Also you can refer this blogs..

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

Hope this will help.

Nilesh

[Former Member · Accepted solution]

please do not provide or request emails,

i.e.,

<a href="https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement&">Rules of Engagement</a>

Message was edited by:

Kenny Scott

[Former Member · Accepted solution]

Sent!

Also I have included some blogs for your refernce in my previous response.

Let us know if you need more details.

Nilesh

[Former Member · Accepted solution]

I will lock closer on tha material I got from you. I will be back.

Thank you very much.

[Former Member · Accepted solution]

It works.

Thank you

[nisarkhan_n]

are u directly acessing the DB2? if yes then the

Sync call from SAP TO Db2 using the RFC adapter and JDBC should work.

[Satyagadadas]

for the SAP side settings use this scenario

/people/shabarish.vijayakumar/blog/2006/03/23/rfc--xi--webservice--a-complete-walkthrough-part-1