sql does not work after changing data with BAPI

[Former Member]

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

[former_member156446]

Hi

use commit work and wait X seconds addition to commit.

[Former Member]

Wait is a pretty bad coding technique

[Former Member]

no such thing as X seconds.

isnt the syntax 'COMMIT WORK AND WAIT'.

Regards

[Former Member]

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

after using sql i am using commit work and wait.

[Former Member]

Guys Please Help

[Former Member]

Put in a COMMIT after the BAPI.

Rob

[former_member156446]

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

[Former Member]

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

[Former Member]

Changed BAPI and resolved

[Former Member]

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