topic Re: COMMIT WORK closes a transaction call in Application Development and Automation Discussions

COMMIT WORK closes a transaction call

Former Member — Tue, 10 Jan 2006 16:26:37 GMT

Hi! I have two different programs. In one of them, I call a transaction to the second program in this way:

CALL TRANSACTION 'ZVGI03A_RCR' USING bdcdata.

Inside the second program, I have to use 'COMMIT WORK' but after that the program finish itself suddenly, returning to the first program.

What is the reason?

Thanx!

Re: COMMIT WORK closes a transaction call

Former Member — Tue, 10 Jan 2006 16:28:38 GMT

Hi,

U cant use the commit work inside a program, calling form call transaction method. It ends the LUW.

Sreedhar

Re: COMMIT WORK closes a transaction call

Former Member — Tue, 10 Jan 2006 16:35:05 GMT

Can I call the program usign CALL PROGRAM instead of CALL TRANSACTION??

Re: COMMIT WORK closes a transaction call

Former Member — Tue, 10 Jan 2006 16:46:06 GMT

You can use "Submit program <progname> and return."

Re: COMMIT WORK closes a transaction call

Former Member — Tue, 10 Jan 2006 16:51:32 GMT

If you have used a COMMIT WORK command, your BDC'll end at the point where you've done the COMMIT.

Which kind is your Z-program?

Max

Re: COMMIT WORK closes a transaction call

Former Member — Tue, 10 Jan 2006 17:03:41 GMT

You can use submit program if the report is a report, but how would you handle the BDC table? If possible, I'd take the commit out of the other program.

Rob

Re: COMMIT WORK closes a transaction call

StevenDeSaeger — Tue, 10 Jan 2006 17:38:44 GMT

Hi,

There is actually a standard solution for this with the CALL TRANSACTION statement.

It has an optional syntax element 'OPTIONS FROM opt' where the 'opt' is a structure with specific option fields.

One of the fields 'RACOMMIT' controls whether the commit work statement will stop the BDC or not. By default it will but by using this field you can prevent it from happening ...

Regards,

Steven

Re: COMMIT WORK closes a transaction call

Former Member — Wed, 11 Jan 2006 08:24:55 GMT

Hi !

You could use the Call Transacation ... OPTIONS

For example:

CALL TRANSACTION 'ZXYZ' UING bdc_tab

OPTIONS FROM bdc_opt.

where bdc_opt is defined as:

DATA: bdc_opt TYPE ctu_params.

and the parameter: bdc_opt-racommit ist set to ' '.

Then the Call-Transaction will not end on any COMMIT WORK of the called transaction.

Regards

Rainer