topic Re: sql does not work after changing data with BAPI in Application Development and Automation Discussions

sql does not work after changing data with BAPI

Former Member — Thu, 06 Nov 2008 18:18:35 GMT

Hey all

I am using bapi 'BAPI_REQUISITION_CHANGE' to change the the data in EBAN.

then on the successfull execution of the above bapi, i am using an sql query to change one customer field in eban.

the Bapi works fine but the sql query does not modify any data. although i am using commit work.

if i put a break-point after bapi then the sql works fine.

any ideas.??

Regards,

Tarun

Re: sql does not work after changing data with BAPI

former_member156446 — Thu, 06 Nov 2008 18:23:13 GMT

use commit work and wait X seconds addition to commit.

Re: sql does not work after changing data with BAPI

Former Member — Thu, 06 Nov 2008 18:29:27 GMT

how are you committing the data? use commit = 'X' in BAPI_TRANSACTION_COMMIT call.

Re: sql does not work after changing data with BAPI

Former Member — Thu, 06 Nov 2008 18:29:49 GMT

Wait is a pretty bad coding technique

Re: sql does not work after changing data with BAPI

Former Member — Thu, 06 Nov 2008 18:30:14 GMT

no such thing as X seconds.

isnt the syntax 'COMMIT WORK AND WAIT'.

Regards

Re: sql does not work after changing data with BAPI

Former Member — Thu, 06 Nov 2008 18:31:37 GMT

i dont need to use BAPI TRANSACTION COMMIT for PR Change Bapi.

after using sql i am using commit work and wait.

Re: sql does not work after changing data with BAPI

Former Member — Thu, 06 Nov 2008 18:55:08 GMT

Guys Please Help

Re: sql does not work after changing data with BAPI

Former Member — Thu, 06 Nov 2008 18:57:25 GMT

Put in a COMMIT after the BAPI.

Rob

Re: sql does not work after changing data with BAPI

former_member156446 — Thu, 06 Nov 2008 19:00:49 GMT

If you do not specify the addition AND WAIT, the program does not wait until the update work process has executed it (asynchronous updating). If you specify the addition AND WAIT, however, program processing after COMMIT WORK will not continue until the update work process has executed the high-priority update function modules (synchronous updating).

source: from sap Help

Re: sql does not work after changing data with BAPI

Former Member — Thu, 06 Nov 2008 19:31:33 GMT

I meant your Wait up to x seconds. thats pretty bad

Re: sql does not work after changing data with BAPI

Former Member — Sat, 02 May 2009 13:08:45 GMT

Changed BAPI and resolved