How to know exactly the database update have finished?

[Former Member]

Hi all,

I use BDC to confirm a Transfer Order, the last screen is reserved for user. User may confirm all the items or some of them or none. So I want to select the TO item data after the BDC to get the confirmed items for the nexe process. Now the problem is, if I select data just after the BDC, the database still not updated yet, so I have to use the statement: WAIT UP TO 2 SECONDS. Is there any better solution for this?

[Former Member]

hi, maybe you can wait up a few monment, and then do a select to check if the infomation has been update into the table.(select single or other master check method) if so, finished you BDC, if not, then wait again, then do the same check twice....

Hope this way will be helpful.

[Former Member]

U can check the lock enteries using below code

DATA : WRK_SEQG3 TYPE TABLE OF SEQG3.

DO.

CALL FUNCTION 'ENQUEUE_READ'

EXPORTING

GCLIENT = SY-MANDT

GNAME = <table neme>

TABLES

ENQ = WRK_SEQG3.

CHECK WRK_SEQG3[] IS INITIAL.

EXIT.

ENDDO.

If the control comes out of this do loop then u can find the data in table...so ur select condition wont fails

Regds

gv