topic Re: ENQUEUE_E_TABLE in Application Development and Automation Discussions

ENQUEUE_E_TABLE

Former Member — Wed, 10 Dec 2008 11:02:17 GMT

Hai sdn members,

Can you please explain ENQUEUE_E_TABLE is used for.

Re: ENQUEUE_E_TABLE

Former Member — Wed, 10 Dec 2008 11:06:46 GMT

used to lock a table ...

Re: ENQUEUE_E_TABLE

Former Member — Wed, 10 Dec 2008 11:08:13 GMT

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

Re: ENQUEUE_E_TABLE

former_member206439 — Wed, 10 Dec 2008 11:13:33 GMT

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

Re: ENQUEUE_E_TABLE

Former Member — Wed, 10 Dec 2008 11:15:43 GMT

hi,

search in SCN

go to transaction ABAPDOCU and ABAPHELP

from there u will understand more

thanks

Sachin

Re: ENQUEUE_E_TABLE

Former Member — Wed, 10 Dec 2008 11:41:24 GMT

Hi,

Please follow the link below

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

Regards,

Manish

Re: ENQUEUE_E_TABLE

Former Member — Wed, 10 Dec 2008 11:48:57 GMT

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.