ENQUEUE_E_TABLE

[Former Member]

Hai sdn members,

Can you please explain ENQUEUE_E_TABLE is used for.

[Former Member]

used to lock a table ...

[Former Member]

Hi,

Just search on SCN for better idea about this FM.

[SEARCH RESULTS|https://www.sdn.sap.com/irj/scn/advancedsearch?cat=sdn_all&query=enqueue_e_table&adv=false&sortby=cm_rnd_rankvalue]

Thanks

[former_member206439]

Hi

This is the basic information about the Fm, and you can search it in SCN you can get better answers.

We can use the function modules ENQUEUE_E_TABLE for locking tables and the function module DEQUEUE_E_TABLE for unlocking tables. With this method, we don't need to lock objects in order to lock the tables. In other words, any table can be locked/unlocked using these function modules.

report zsubhas_enqueue.

* testing the locking of tables...
data:
  varkey like rstable-varkey.

  varkey = sy-mandt.

* locking the tables............................
call function 'ENQUEUE_E_TABLE'
 exporting
*   MODE_RSTABLE         = 'E'
   tabname              = 'MARA'
   varkey               = varkey
*   X_TABNAME            = ' '
*   X_VARKEY             = ' '
*   _SCOPE               = '2'
*   _WAIT                = ' '
*   _COLLECT             = 'X'
 exceptions
   foreign_lock         = 1
   system_failure       = 2
   others               = 3
          .
  case sy-subrc.
    when 1.
        message i184(bctrain) with 'Foreignlock'.
    when 2.
      message i184(bctrain) with 'system failure'.
    when 0.
      message i184(bctrain) with 'success'.
        when others.
        message i184(bctrain) with 'others'.
  endcase.

• unlocking the table...............

call function 'DEQUEUE_E_TABLE'
   exporting
*     MODE_RSTABLE       = 'E'
     tabname            = 'MARA'
     varkey             =  varkey
*     X_TABNAME          = ' '
*     X_VARKEY           = ' '
*     _SCOPE             = '3'
*     _SYNCHRON          = ' '
*     _COLLECT           = ' '
            .

Edited by: Naresh nelapatla on Dec 10, 2008 12:18 PM

[Former Member]

hi,

search in SCN

go to transaction ABAPDOCU and ABAPHELP

from there u will understand more

thanks

Sachin

[Former Member]

Hi,

Please follow the link below

http://searchsap.techtarget.com/tip/1,289483,sid21_gci858655,00.html

Regards,

Manish

[Former Member]

function modules ENQUEUE_E_TABLE and DEQUEUE_E_TABLE to lock/unlock a row

in any custom (or standard) SAP tables. when you are controlling workflows using table entries.