FM for locking n unlocking a table for update

[Former Member]

I have to update a table named bnka, can anyone tel me the FM for locking and unlocking a table before updating the same..

thnkx

amit

[former_member181962]

Use the fms:

ENQUEUE_E_TABLE passing BNKA to the tabname parameter. and

DEQUEUE_E_TABLE passing BNKA to the tabname parameter.

or

ENQUEUE_EFBNKA and DEQUEUE_EFBNKA

Regards,

ravi

Message was edited by:

Ravi Kanth Talagana

[manuel_bassani]

Hi Amit

you can use FM ENQUEUE_EFBNKA to lock the table BNKA

and DEQUEUE_EFBNKA to unlock it

Example:

call function 'ENQUEUE_EFBNKA'
 EXPORTING
   MODE_BNKA            = 'E'
   BANKS                = bnka-banks
   BANKL                = bnka-bankl
 EXCEPTIONS
   FOREIGN_LOCK         = 1
   SYSTEM_FAILURE       = 2
   OTHERS               = 3.
if sy-subrc <> 0.
 MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
endif.

update BNKA .....

call function 'DEQUEUE_EFBNKA'
 EXPORTING
   MODE_BNKA       = 'E'
   BANKS           = bnka-banks
   BANKL           = bnka-bankl.

Cheers,

Manuel

[venkata_ramisetti]

Hi Amit,

You can use ENQUEUE_E_TABLES or ENQUEUE_E_TABLE function module.

Thanks

Ramakrishna

[Former Member]

Hello,

Use,

ENQUEUE_* and DEQUEUE_* function modules.

Regards,

Shehryar Dahar

[Former Member]

you can use FM ENQUEUE_EFBNKA to lock the table vbak

and DEQUEUE_EFBNKA to unlock it

Example:

call function 'ENQUEUE_EFBNKA'

EXPORTING

MODE_BNKA = 'E'

BANKS = bnka-banks

BANKL = bnka-bankl

EXCEPTIONS

FOREIGN_LOCK = 1

SYSTEM_FAILURE = 2

OTHERS = 3.

if sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

endif.

update BNKA .....

call function 'DEQUEUE_EFBNKA'

EXPORTING

MODE_BNKA = 'E'

BANKS = bnka-banks

BANKL = bnka-bankl.

[manuel_bassani]

cut and paste, Srikanth ?