topic Re: update database in RFC in Application Development and Automation Discussions

update database in RFC

Former Member — Wed, 03 Jun 2015 00:37:02 GMT

Hi all,

I have some requirements like this:

In system A, I have a program B, B will call Function Module C in remote system D.

In FM C, I have some UPDATE to change the database.

Here is the problem.

After C goes to the end, these UPDATE will be commited automatically, and the program run back to B. But I am not sure if B will run correctly afterwards and if it has some problems, I cannot ROLLBACK the work that I have done in system D.

If I use IN UPDATE TASK, I think that the updates will be lost after C is over.

So how should I do in this case?

Re: update database in RFC

former_member186741 — Wed, 03 Jun 2015 01:40:26 GMT

Hi Ming,

surely you can delay the call to the RFC until after the program has run successfully.

Re: update database in RFC

Former Member — Wed, 03 Jun 2015 01:53:12 GMT

Do you mean call in tRFC？

Re: update database in RFC

Former Member — Wed, 03 Jun 2015 01:55:43 GMT

And I think maybe I should separate the update parts and other parts into two two RFCs.

In the first RFC, I do logic and in the second RFC, I call it in tRFC and do update inside it.

Am I thinking right?

Re: update database in RFC

former_member186741 — Wed, 03 Jun 2015 04:12:59 GMT

no, I mean the function module being called as an RFC...why not call it at the end of processing for the program.

Re: update database in RFC

Former Member — Wed, 03 Jun 2015 04:35:50 GMT

This RFC is not just used for database updating, there are also some other logic.

Re: update database in RFC

former_member186741 — Wed, 03 Jun 2015 04:51:48 GMT

Ok, so I guess that is what you mean by splitting the function module into two? One to do the work as you go along and another to do the updates at the end?

Re: update database in RFC

Former Member — Wed, 03 Jun 2015 04:59:17 GMT

Yes, actually I am helping another guy fix this and I am thinking a better way to do that.

Maybe in this case, the logic part and the update part should be separated into two FMs.

Re: update database in RFC

former_member186741 — Wed, 03 Jun 2015 05:19:21 GMT

I think that is a good way to do it.