on 09-24-2009 8:17 AM
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
search sdn for RFC synch. scenario .... you wil find many.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.