topic How to do a commit from update task mode. in Application Development and Automation Discussions

How to do a commit from update task mode.

bettinasilveira — Wed, 06 Sep 2017 19:47:15 GMT

Hi guys!

I have a problem, inside a function module called in update task mode I need to add a record to a Z table and do a commit so its available in a step later in the same process.

If I do a commit, I get a dump because you can't do that. I tried another thing, to call another function module as a new task and inside this FM add the insert and the commit. It's not doing anything.

Code works because if I execute the first FM from SE37 as a normal FM, the records is added to the table.

So, is there a way to add a record to a table and do the correspondent commit inside a FM called in update task mode? Keep in mind that I'm doing a select to retrieve this record in a posterior step, that's why I need it, I'm adding functionality to an existing program and trying to modify as little as I can.

Thanks for your help!

Re: How to do a commit from update task mode.

pokrakam — Wed, 06 Sep 2017 20:56:32 GMT

How exactly is the later step performed? Read consistency means your select should already 'see' the new data if it is in the same LUW, So im wondering whether there's some caching or something involved or it's going into another LUW?

Alternatively, is it possible to transport the updated info to the later step? Perhaps using a static class attribute or something like that.

Re: How to do a commit from update task mode.

bettinasilveira — Wed, 06 Sep 2017 21:05:04 GMT

"Later step" is in the same process, same function module, same LUW. I could save the info to memory, but I'm trying to not alter the code so much. If that's the only option I have, I guess there's no other way. 😞

Re: How to do a commit from update task mode.

pokrakam — Wed, 06 Sep 2017 21:21:25 GMT

Hmmm, it does make me wonder whether the program logic is optimal if we are writing to and then reading from the same table in the same code unit? It does sound a bit unusual.

Re: How to do a commit from update task mode.

vera_kulish2 — Wed, 06 Sep 2017 23:29:32 GMT

Try:

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'
EXPORTING
wait = 'X'.

Re: How to do a commit from update task mode.

Former Member — Thu, 07 Sep 2017 06:19:37 GMT

Hi,

You can do a Commit after call the FM in update task mode, so the FM will be execute and add the record, but in fact it is the same as call the FM in normal way.

Best regards.

Re: How to do a commit from update task mode.

retired_member — Thu, 07 Sep 2017 07:24:07 GMT

Then why do you do an explicit COMMIT at all?

If you change a DB table, the change is visible in "the same process, same function module, same (DB-)LUW". Or do I miss something?

Re: How to do a commit from update task mode.

bettinasilveira — Thu, 07 Sep 2017 13:37:33 GMT

If you read my original post, I need to do a commit INSIDE the FM, not after.

Re: How to do a commit from update task mode.

retired_member — Thu, 07 Sep 2017 14:33:04 GMT

But why an explicit commit? Inside an update FM and everything called there you are by default inside a DB LUW. There are no rollbacks, only in case of errors.

Re: How to do a commit from update task mode.

former_member507110 — Fri, 08 Sep 2017 01:50:16 GMT

Hi,

The code which you are using to update the z table, place it in a RFC enabled function module and write a commit statement inside this RFC enabled FM.

Call this RFC enabled FM from the main program or FM as DESTIANTION 'NONE'.

EG: CALL FUNCTION '<RFC ENABLED FM>' DESTINATION 'NONE'.

In this way you can avoid dump and you can update the z table.

Refer notes 1895298, 896173