topic Re: Call transaction inside Update task in Application Development and Automation Discussions

Call transaction inside Update task

Former Member — Tue, 17 Jul 2007 11:58:33 GMT

Is it possible to use call transaction inside an update function module?

My requirement is like this.

When I execute LB10 storage units will be created..then we have to go to lt09 and then create a TO's there for all these Storage units..

Now, when I try to call a bdc session from an exit, the storage units are not updated there. so the BDC is getting failed..

To resolve this, I kept all the BDC code in to a Zfunction module and made it an update funtion module. I am calling this function module form the exit IN UPDATE TASK.

But the call transaction is not working....

I have tried with L_TO_CREATE_MOVE_SU inside the Z function module..Still no use..

is there any other way that I can solve this?

Re: Call transaction inside Update task

Former Member — Tue, 17 Jul 2007 12:06:53 GMT

Hi,

Calling a FM in Update Task is one of the bundling techniques used in ABAP to avail functionality provided by SAP Update System. Here all database updates are processed at the end of the SAP LUW in contrast to normal FM call where the database updates are done and commited at the time of call (Database LUW). It is necessary to bundle all your database updates in an SAP LUW e.g. all database updates in a transaction (like VA01) should be bundled. Almost all standard SAP transactions use bundling techniques.

This technique separates the dialog process and update process. The dialog part of the transaction can span more than one screen(one dialog step) and can be processsed by more than one dialog work process. A work process is released when the dialog step changes (screen changes) and the work process sends a database commit (called Implicit Database LUW). So with each screen change there is a database commit and database remains in consistent state.

Now when using bundling technique, when a COMMIT WORK is encountered, system ends the dialog process with a dialog work porcess and starts the update process using an update work process.

The dialog step containing the COMMIT WORK is considerd as the last dialog step of the transaction and all the update function modules are processed now in the last dialog step by the update work process though they were called earlier during the earlier dialog steps.

It is necessary to create update FMs to take advantage of this technique. The update FM is created FM by setting the Update moduleradiobutton in the Attributes tab in SE37.

In a normal FM call, if there are database updates (UPDATE, INSERT, MODIFY, DELETE) than database is commited after the FM processing is over as the FM starts its own Database LUW and ends it too.

Reward Points

Regards

Re: Call transaction inside Update task

Former Member — Tue, 17 Jul 2007 12:07:42 GMT

have u marked that function module as 'UPDATE' in se37 Attributes.

and be sure that commit work should not be inside the function module called instead it should be in the calling program after function module gets executed.

regards

ravish

plz dont forget to reward if useful

Re: Call transaction inside Update task

Former Member — Tue, 17 Jul 2007 12:11:03 GMT

Use Call transaction always

if you use call transaction in your case use update mode 'S',then your problem will be solved.

if you use update mode 'S',it will update record transaction level as well database level,then cursor will go next record,you get message number in BDCMSGCOLL if you want to have ..read the message using T100 table so that you will get language description.

syntax :

call transaction tcode using bdcdata

mode 'A/E/N'

update 'S'

messages into bdcmsgcoll.

Thanks

Seshu

Re: Call transaction inside Update task

Former Member — Tue, 17 Jul 2007 12:11:28 GMT

and add addition as separate unit it will work

Re: Call transaction inside Update task

Former Member — Tue, 17 Jul 2007 12:14:01 GMT

Does this mean we can't call BDC programs from Update function module?

I have already set appropriate settings in attributes...

Re: Call transaction inside Update task

Former Member — Tue, 17 Jul 2007 12:14:46 GMT

as u add a addition as As separate unit the FM will be excuted as separate unit and it will reflect to the current luw

Re: Call transaction inside Update task

Former Member — Tue, 17 Jul 2007 12:15:58 GMT

sorry some correction

as u add a addition as As separate unit the FM will be excuted as separate unit and it will not reflect to the current luw

Re: Call transaction inside Update task

Former Member — Tue, 17 Jul 2007 12:24:35 GMT

AS SEPARATE UNIT addition is applied for IN BACKGROUND TASK ..Isn't it?

can be given for IN UPDATE TASK too?

Re: Call transaction inside Update task

Former Member — Tue, 17 Jul 2007 12:50:22 GMT

Hi Kalyan,

As far as my knowledge goes in Updates in SAP.

We cannot use CALL TRANSACTION...

LEAVE TO TRANSACTION...

SUBMIT...

SUBMIT.. AND RETURN

statements in update Function Modules. They do not stand any significance in update Function Modules.

Try to do a Synchronous update by COMMIT WORK AND WAIT instead of Asynchronous Update using COMMIT WORK. After the explicit COMMIT WORK AND WAIT statement try to do your CALL TRANSACTION...

I do not know whether the above can be done in your scenario, But i am pretty sure that you cannot use CALL TRANSACTION in update FM.

Regards,

Goutham.

Please let me know if you have further inputs.