Skip to Content
avatar image
Former Member

SAP ->JDBC -> SAP

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 24, 2009 at 07:49 AM

    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%29ID0172822650DB10651328925490281944End?blog=/pub/wlg/1387

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2009 at 07:30 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 24, 2009 at 07:33 AM

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

    Add comment
    10|10000 characters needed characters exceeded