cancel
Showing results for 
Search instead for 
Did you mean: 

SAP ->JDBC -> SAP

Former Member
0 Kudos

Hi Experts,

I have a scenario in which SAP program accesses data from external database.

The requirement is as follows:

1.User executes a report in SAP with some data on selection screen.

2.SAP sends that data to database via pi to select some data from external database.

3.PI returns the selected data to the SAP program.

4.SAP program displays that data in the form of ALV.

Now in this scenario what should be the architecture?

Which adaptors should i use from sap side?

My main concern is sap program should wait till my query fetches data from external database.

Solution with some links to the blogs will be helpful

Thanks and Regards,

Atul

Accepted Solutions (1)

Accepted Solutions (1)

former_member187339
Active Contributor
0 Kudos

Hi Atul,

Two approach can be followed:

either RFC to PI to JDBC

or PRoxy to PI to JDBC


1.User executes a report in SAP with some data on selection screen.
2.SAP sends that data to database via pi to select some data from external database.
3.PI returns the selected data to the SAP program.
4.SAP program displays that data in the form of ALV.

This will be a normal ABAP report program. In this you need to get input from user and call proxy/RFC. Calling a proxy its like executing a Function Module, The controlled will be give to PI and PI will fetch the data and return back the response to the calling program (ie report). Then you can manipulate and show the response.

Check this link for Proxy

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=%28J2EE3417200%29ID0172822650DB1065132892549028194...

and this for sender RFC

/people/michal.krawczyk2/blog/2005/03/29/configuring-the-sender-rfc-adapter--step-by-step

If data size is more then go for PROXY else RFC

Regards

Suraj

Edited by: S.R.Suraj on Sep 24, 2009 3:49 AM

Answers (2)

Answers (2)

Former Member
0 Kudos

search sdn for RFC synch. scenario .... you wil find many.

Former Member
0 Kudos

Hi Atul ,

The requirement is as follows:

1.User executes a report in SAP with some data on selection screen.

2.SAP sends that data to database via pi to select some data from external database.

3.PI returns the selected data to the SAP program.

4.SAP program displays that data in the form of ALV.

Now in this scenario what should be the architecture?

1. ABAP Proxy(sync)->PI->JDBC(sync)

2. RFC(sync)->PIJDBC(sync)

Which adaptors should i use from sap side?

--> RFC. you can also go for adapter less approach , the first one mentioned above .

Solution with some links to the blogs will be helpful .

/people/ravikumar.allampallam/blog/2005/03/14/abap-proxies-in-xiclient-proxy

/people/michal.krawczyk2/blog/2006/04/19/xi-rfc-or-abap-proxy-abap-proxies-with-attachments

/people/sravya.talanki2/blog/2006/07/28/smarter-approach-for-coding-abap-proxies

Regards,