topic Lock objects in Application Development and Automation Discussions

Lock objects

Former Member — Mon, 22 Jan 2007 15:12:12 GMT

how to lock a specific table entries?

Re: Lock objects

RichHeilman — Mon, 22 Jan 2007 15:15:06 GMT

By using Lock Objects You create a lock object for you table via SE11, doing so, creates two function modules, an ENQUEUE function module and a DEQUEUE funciton module. When you want to lock a table entry, you simply call the ENQUEUE function module for that lock object and pass the values in which are the key of the record that you want to lock.

http://help.sap.com/saphelp_nw2004s/helpdata/en/a2/3547360f2ea61fe10000009b38f839/frameset.htm

Regards,

Rich Heilman

Re: Lock objects

ferry_lianto — Mon, 22 Jan 2007 15:15:35 GMT

Hi,

You can do by creating a lock object (SE11) and use this FM.

ENQUEUE_E_TABLE

DEQUEUE_E_TABLE

Regards,

Ferry Lianto

Re: Lock objects

Former Member — Mon, 22 Jan 2007 15:16:29 GMT

sunil

check the below link may be useful for u

~~Guduri

Re: Lock objects

Former Member — Mon, 22 Jan 2007 15:16:38 GMT

Hi sunil,

http://help.sap.com/saphelp_nw2004s/helpdata/en/cf/21eef3446011d189700000e8322d00/content.htm

Re: Lock objects

Former Member — Mon, 22 Jan 2007 15:16:47 GMT

use...

DB_GET_LOCKED_TABLES

BKK_PA_LOCKS_DB_SET_OBJECTS

BKK_CLOSCTRL_LOCK_OBJECTS

TRINT_OLE_LOCK_OBJECTS

Re: Lock objects

Former Member — Mon, 22 Jan 2007 15:17:06 GMT

* Lock Table ZFISVTAX_CCTR
  CALL FUNCTION 'ENQUEUE_E_TABLE'
   EXPORTING
     MODE_RSTABLE         = C_E
     TABNAME              = C_CCTR
   EXCEPTIONS
     FOREIGN_LOCK         = 1
     SYSTEM_FAILURE       = 2
     OTHERS               = 3

*   Unlock table ZFISVTAX_CCTR
     CALL FUNCTION 'DEQUEUE_E_TABLE'
      EXPORTING
        MODE_RSTABLE       = C_E
        TABNAME            = C_CCTR
               .

Re: Lock objects

Former Member — Mon, 22 Jan 2007 15:20:02 GMT

Hi Sunil,

If it is a standard table, there might be lock function modules created by SAP. If you want to create lock for ztable entries to use in custom transactions, create a lock object from SE11 starting with 'E' char like Eflightno and select lock parameters and table inside it. It will create two function modules in the Dictionary with names as

ENQUEUE_EFLIGHTNO and

DEQUEUE_EFLIGHTNO

which should be used in the custom transaction ..

Let me know, if i am not clear.

Regards,

Vivek

Re: Lock objects

Former Member — Mon, 22 Jan 2007 18:13:12 GMT

you can have a look at:

http://www.saptechnical.com/Tips/ABAP/lock.htm