Update table

[Former Member]

Guys,

I am doing an update on a dbase table in a user exit. After updating the table I am calling the table in my main program by calling the PBO of the main screen.

But i observed that the table updation is happening only after a while, as a result the old values are retrieved when I reload the screen. Is there any way I can ensure that the table gets updated before my screen call?

[Former Member]

hi,

Write COMMIT WORK in your User Exit After the Updation Logic.

It will Perform Updation at that time.

Regards

Sumit Agarwal

[Former Member]

Try to use WAIT Statement after your updation of records in table.

Thanks

Sudharshan

[Former Member]

hi,

Write COMMIT WORK in your User Exit After the Updation Logic.

It will Perform Updation at that time.

Regards

Sumit Agarwal

[Former Member]

Hi,

Commit work will solve your problem but use it with caution. As it is not recommended to be used in user exit.

[former_member217544]

Hi,

COMMIT statement will resolve the issue else you can use the following BAPI.

CALL FUNCTION 'BAPI_TRANSACTION_COMMIT'

EXPORTING

WAIT = 'X'

IMPORTING

RETURN = RETURN.

Return will show the success or failure of the commit statement.

If that is still not getting updated then try using the WAIT statement separately.

WAIT UP TO 2 SECONDS.

Hope this will solve the issue.

Regards,

Swarna Munukoti.