Web Dynpro integration with R/3

[Former Member]

Dear all,

We have the following requirement in Web Dynpro integration with R/3

We have to update the local SQL tables based on R/3 system return values. R/3 system should call the webdynpro business method for updating local SQL Status table. In the R/3 system after purchase order is created, via user exit it should call and update some fields in the local SQL tables. To solve this problem we have thought of following solutions possibility:

1. In R/3 system based on user exit, it calls the ABAP Proxy -> XI (SOAP Adapter) -> Web Dynpro Web Service in WebAS-> XI -> ABAP Proxy -> User exit – PO continues.

2. In R/3 system based on user exit, it calls directly web service then web service goes to user exit.

3. In R/3 -> user exit -> ABAP Proxy – JDBC Adapter -> SQL stored procedure call - > user exit.

Please give your valuable suggestion or any other options to solve above problems.

And another one question is how to create web service and deploy into WebAS through webdynpro project?. Kindly guide us to the correct document for creating webservice through webdynpro or any other related url link.

Advance thanks,

S.Saravanan.

[Former Member]

I am not sure if you can create web service based on 'Web Dynpro'. As Web Dynpro is merely a user interface and not means of providing business services...

You can write simple stateless session bean which use JDBC to update SQL database and expose this session bean as web service (very simple if you are using NWDS to create bean).

Other method could be to use JCo and write java class to update SQL database using JDBC. You can start JCo server, register it as RFC destination in R/3 and call the java method.

[Former Member]

Hi Sarvanan,

Please refer to the following link for help on webservice,

Creating webservice, http://help.sap.com/saphelp_nw2004s/helpdata/en/db/99c04ba22fe64f96a8651df68eab92/frameset.htm

Consuming a Web Service in JAVA,

http://help.sap.com/saphelp_nw2004s/helpdata/en/81/12703e5da3e946e10000000a114084/frameset.htm

Consuming webservices in webdynpro,

http://help.sap.com/saphelp_nw2004s/helpdata/en/91/9c2226df76f64fa7783dcaa4534395/frameset.htm

I feel once you go through these links you yourself will be in a much better position to decide upon to your design options.

Reply back for more help,

Guru.