Update backend table from WebDynpro?

[Former Member]

Hi,

I need to create entries in the backend table HRUS_D2. I found that the FM used for this table is RH_UPDATE_SUBST_LIST_SERVER.

I want to write a Java WebDynpro application display all the fields on the webpage which represents above table and update the backend table, how do I do it?

Do I need to get any more information about the table like BADI or BAPI or write something to update table HRUS_D2?

Please let me know.

Praveen

[Former Member · Accepted solution]

Hi Praveen,

This is a very common question on SDN. You can go in to the Articles section or do a quick search for RFC call from WD JAVA. You can get loads of information. Meanwhile, I will remind you about the very common mistake that everyone does while trying to update a Table in the database. This will be of good help for you.

Ater following all the articles and materials about Calling a BAPI and creating you interface, you should not forget to call "BAPI_TRANSACTION_COMMIT" from WD. Because, whenever you want to update a database table you should do a commit to the database. Also, this should happen in the same session of the Jco Connection. If you dont do the commit then your database table will not be updated at all.

So, don't forget to do this. I hope this helps. Let me know if you need any further help.

Regards,

Gopal.

[Former Member · Accepted solution]

Hi thanks for quick info on the topic, as you would have guessed I'm new to this WebDynpro backend programming.

Can you please clarify this for me, so for every table in the backend(R3) there must be a function module?

If I have a existing JCo connection to connect to R/3 can I use that JCo or should I create one exclusively for the table that I'm going to update?

Thanks

Praveen

[Former Member · Accepted solution]

Hi Praveen,

so for every table in the backend(R3) there must be a function module? 

No, it is not necessary that you would have a FM to update a table in the backend. In some occasions you might have to write your own function module in R/3 and make it remote-enabled.

If I have a existing JCo connection to connect to R/3 can I use that JCo or should I create one exclusively for the table that I'm going to update?

You can use the one JCo for more than one function modules. That shouldn't be a problem. But, I am not sure about the performance related issues. I dont think, it is necessary to create one exclusively for the table!

I hope this helps you and let me know if you need more information.

Regards,

Gopal.

[Former Member · Accepted solution]

Thanks for the info. I think I start with development and read the documentations. Shall post back if I have any queries. I got answer to my query for this thread.

Praveen.

[Abhinav_Sharma]

Hi Praveen

You can refer the sample tutorials available in SDN. Things you require to execute the BAPI from WD Java is JCO and Backend access.

You will find lot of sample tutorials here [/docs/DOC-8661#section10 [original link is broken] [original link is broken]|/docs/DOC-8661#section10 [original link is broken] [original link is broken]]

Refer this [PDF|https://www.sdn.sap.com/irj/scn/logon?redirect=https%3a%2f%2fwww.sdn.sap.com%2firj%2fsdn%2fgo%2fportal%2fprtroot%2fdocs%2flibrary%2fuuid%2fa00f7103-6790-2a10-ac9c-fcac7c5b18a3]

Abhinav

Edited by: Abhinav Sharma on Aug 25, 2009 2:29 PM

[Former Member]

Hi,

you need to have the update bapi name and create a model based on that bapi and create JCO destination for the corresponding backe end system and update the fiedls with the help of web dypro application..

regards

Manohar

[former_member185879]

Hi,

To update data in back end.

1. Please create a RFC which will update the details in the table.

2. Create a Adaptive RFC Model and update the data thru Java Connector(JCo).

3. Create a webdynpro application to update the table.

Regards

SM Nizamudeen