topic Re: Lock entry with Bapi BAPI_GOODSMVT_CREATE in Application Development and Automation Discussions

Lock entry with Bapi BAPI_GOODSMVT_CREATE

FredericGirod — Mon, 24 Apr 2006 07:33:52 GMT

Hi,

I have created a program with an ALV grid, when a user select a line and press a button that will call the function BAPI_GOODSMVT_CREATE.

The problem is, each time I call the BAPI, there was lock entry created. And this lock entry is only release when the users leave the program.

There is a way to release all the lock entry after the end of the function ?

Or maybe, other solution, is too call in background task the function ?

any idea?

Rgd

Frédéric

Re: Lock entry with Bapi BAPI_GOODSMVT_CREATE

Former Member — Mon, 24 Apr 2006 07:38:21 GMT

Hi,

You would be calling BAPI_TRANSACTION_COMMIT which should ideally release the locks.

Regards

Ravi

Re: Lock entry with Bapi BAPI_GOODSMVT_CREATE

Former Member — Mon, 24 Apr 2006 07:39:17 GMT

use functiom module DEQUEUE_ALL.

Re: Lock entry with Bapi BAPI_GOODSMVT_CREATE

FredericGirod — Mon, 24 Apr 2006 07:45:42 GMT

I don't want to commit the transaction, because I run the function in test mode.

(not all the times)

Fred

Re: Lock entry with Bapi BAPI_GOODSMVT_CREATE

FredericGirod — Mon, 24 Apr 2006 07:47:10 GMT

Maybe a good idea ..

I will check, but I'm not sure about the impact of dequeue ALL the lock entry (cause my users could play with a lot of entry ... )

Thanks

Re: Lock entry with Bapi BAPI_GOODSMVT_CREATE

Former Member — Mon, 24 Apr 2006 07:52:45 GMT

If you are using it in TEST MODE swtich on the flag TESTRUN of the BAPI and after that even if you COMMIT the changes will NOT be there in the DATABASE.

Then the locks will be released and changes are also NOT committed to DB if you have the TESTRUN flag on.

Its not recommended that you unlock the locks manually.

Regards,

Ravi

Re: Lock entry with Bapi BAPI_GOODSMVT_CREATE

FredericGirod — Mon, 24 Apr 2006 08:05:52 GMT

I have played with the TESTRUN option, but, for me, it's a logical problem to use a function to commit change when I use the test mode.

And maybe, what about using the function BAPI_TRANSACTION_ROLLBACK ?

Re: Lock entry with Bapi BAPI_GOODSMVT_CREATE

Former Member — Mon, 24 Apr 2006 08:07:40 GMT

BAPI_TRANSACTION_ROLLBACK also should release the locks, how ever you need to be careful to see that the changes that you do want to save are NOT lost.

regards,

Ravi

Re: Lock entry with Bapi BAPI_GOODSMVT_CREATE

FredericGirod — Mon, 24 Apr 2006 08:15:50 GMT

Thanks for all your answers.

Have a nice day

Fred

Re: Lock entry with Bapi BAPI_GOODSMVT_CREATE

Former Member — Mon, 24 Apr 2006 08:31:25 GMT

if user selects only one entry and makes changes maybe u can use ENQUEUE_READ, then pass those entries to specific DEQUEUE_(locks with respect to Goods movement).