database comit

[Former Member]

hi,

i am using a FM : L_TO_CONFIRM

Passing parameter : I_komim = 2

This confirms Transfer ordder and creates Goods issue

After this FM i am selecting values from VBFA. Here some times data base is not updated properly. Commit work problem.

some times it works fine. some times for couple of line items its failing and later on the table is updated.

Please let me know how to correct this

I have used :

Commit work and wait

Wait for 5 seconds .....but no use .....

pls let me know how to solve it ?

-Senthil

[Former Member]

Hi,

there are two more parameters, I_UPDATE_TASK and I_COMMIT_WORK. Pass value 'X' to both of this. I should work.

Regards

Ram

[Former Member]

Pass I_COMMIT_WORK parameter as X and do not use seperate Commit work in your code.This flag will do the required commit.

[Former Member]

I am already passing i_comit_work as X.

Then also - same problem

Senthil

[Former Member]

do not use seperate Commit work in your code.This flag will do the required commit.

Remove your own commit work in your code

[Former Member]

Hi Senthil.

you mean after you call the FM: L_TO_CONFIRM, you can reading the data from VBFA and are you trying to save this VBFA data somewhere else...

if this is your issue, use the VBFA read before calling the FM L_TO_CONFIRM, and commit everything once.

because, once the COMMIT WORK is used it closes all the LUW's, so no more updates will be done within the program. so do the COMMIT as the last thing in your program.

Hope this helps.

Srini.