topic Re: lock objects in Application Development and Automation Discussions

lock objects

Former Member — Fri, 31 Aug 2007 04:58:02 GMT

Gurus,

I have created Ztable, for this how to lock the table and how to lock a record?

could any one explain the process of creating a lock object, how to unclock the table or record?

Re: lock objects

Former Member — Fri, 31 Aug 2007 05:04:45 GMT

Lock objects are use in SAP to avoid the inconsistancy at the time of data is being insert/change into database.

SAP Provide three type of Lock objects.

- Read Lock(Shared Locked)

protects read access to an object. The read lock allows other transactions read access but not write access to

the locked area of the table

- Write Lock(exclusive lock)

protects write access to an object. The write lock allows other transactions neither read nor write access to

the locked area of the table.

- Enhanced write lock (exclusive lock without cumulating)

works like a write lock except that the enhanced write lock also protects from further accesses from the

same transaction.

You can create a lock on a object of SAP thorugh transaction SE11 and enter any meaningful name start with EZ Example EZTEST_LOCK.

Use: you can see in almost all transaction when you are open an object in Change mode SAP could not allow to any other user to open the same object in change mode.

Example: in HR when we are enter a personal number in master data maintainance screen SAP can't allow to any other user to use same personal number for changes.

Technicaly:

When you create a lock object System automatically creat two function module.

1. ENQUEUE_<Lockobject name>. to insert the object in a queue.

2. DEQUEUE_<Lockobject name>. To remove the object is being queued through above FM.

regards

Giridhar

Re: lock objects

gopi_narendra — Fri, 31 Aug 2007 05:05:10 GMT

See this link

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eef3446011d189700000e8322d00/frameset.htm

Regards

Gopi

Re: lock objects

messier31 — Fri, 31 Aug 2007 05:05:19 GMT

Hi,

1. <a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eef3446011d189700000e8322d00/frameset.htm">Create lock objects</a>

2. <a href="http://help.sap.com/saphelp_nw04/helpdata/en/af/22ab01dd0b11d1952000a0c929b3c3/frameset.htm">Example for lock object</a>

Misc : <a href="http://help.sap.com/saphelp_nw04/helpdata/en/af/22ab01dd0b11d1952000a0c929b3c3/frameset.htm">Lock Mechanism</a>

Enjoy SAP.

Pankaj Singh.

Re: lock objects

Former Member — Fri, 31 Aug 2007 05:07:40 GMT

Lock object concept

Lock modes

Creating a lock object (example)

Lock object sample code

Lock Objects SAP data dictionary provides you with a locking mechanism to synchronize simultaneous data access by different users.

Lock objects are created in SE11.

Customer lock objects must begin with EY or EZ .

Three possible lock modes exist for lock objects.

LOCK MODE

Lock mode E: This sets a lock for changing data for single user. This lock can be accumulated.

Lock mode X: This mode is used like mode E for changing data. The only technical difference from mode E is that the respective lock does not allow accumulation.

Lock mode S: This mode ensures that data displayed in your program cannot be changed by other users during the entire display time. Here you do not want to change the data yourself (allows read only access for data).

Creating Lock object

Enter lock object name beginning with EY or EZ

and hit create.

Enter table names containing data records that should be locked and the lock mode.

The primary keys of the specified tables are automatically selected as lock parameters.

To set a lock in the application program

call a function module ENQUEUE_<LOCK_OBJECT>.

For our example, it would be ENQUEUE_EZMARA.

To release the lock in the application program

call a function module DEQUEUE_<LOCK_OBJECT>.

For our example, it would be DEQUEUE_EZMARA.

Refer the code executed by user (say abap1) for

matnr = ’000000000000000012’.

REWARD IF USEFULL

Re: lock objects

Former Member — Fri, 31 Aug 2007 06:19:40 GMT

Hi,

you see the following steps to create and use the lock objects.

suppose you created one z table called 'ZVIJ' for that you need to create lock objects.

Creating Lock object

Enter lock object name beginning with EY or EZ example EZVIJ

and hit create.

Enter table names is ZVIJ containing data records that should be locked and the lock mode.The primary keys of the specified tables are automatically selected as lock parameters.And press the 'activate' button, then lock objects creates by default two Funtion modules are

1) ENQUEUE_EZVIJ (for Lock create)

2) DEQUEUE_EZVIJ (Relase lock)

NOTE: dont forget to active the lock objects until unless activate sys doesnot create the F.Ms

To set a lock in the programs

call a function module ENQUEUE_EZVIJ

To release the lock in the application program

call a function module DEQUEUE_EZVIJ

Reward with points if helpful.

Regards,

Vijay

Re: lock objects

Former Member — Fri, 31 Aug 2007 07:13:55 GMT

Hi,

Goto tcode SE11

choose "lock object" (the last option)

Give a name starts with 'E' follwed by ur table name.For Ex: EZTESTTAB.And

click on create.

give description .

click on Tables tab.

jus give name of the table on which u want to create the lock ...and lock mode.

There r differrent kind of locks:

Lock mode E: This sets a lock for changing data for single user. This lock can be accumulated.

Lock mode X: This mode is used like mode E for changing data. The only technical difference from mode E is that the respective lock does not allow accumulation.

then add or remove secondary tables if u r table have any ..

jus save and active.

after this the system will automaticall create two functiona modules named

ENQUEUE_<UR lockname> -for locking a table

DEQUEUE_<UR lockname> -for unlocking a table.

u can call these function modules directly in ur report to lock and unlock that table.

Reward if useful.

Thanks,

jyothi D

Re: lock objects

Former Member — Fri, 31 Aug 2007 07:58:01 GMT

i hv created a zemp1 table and maintaining 3 fields, empno(primary key), ename, dno.

i hv created a lock object..

but it is going to DUMP.

Tables : Zemp1.

CALL FUNCTION 'ENQUEUE_EZEMP1'

EXPORTING

MODE_ZEMP1 = 'E'

EMPNO = 102.

X_EMPNO = ' '
_SCOPE = '2'
_WAIT = ' '
_COLLECT = ' '
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.

Re: lock objects

Former Member — Fri, 31 Aug 2007 09:22:21 GMT

` hv created a zemp1 table and maintaining 3 fields, empno(primary key), ename, dno.

i hv created a lock object..and i hv called the FM...but it is going to DUMP.

Tables : Zemp1.

CALL FUNCTION 'ENQUEUE_EZEMP1'

EXPORTING

MODE_ZEMP1 = 'E'

EMPNO = 102.

X_EMPNO = ' '
_SCOPE = '2'
_WAIT = ' '
_COLLECT = ' '
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.

Re: lock objects

Former Member — Fri, 31 Aug 2007 09:29:23 GMT

Jus uncomment the "exceptions" part.....

hope it works....

CALL FUNCTION 'ENQUEUE_EZEMP1'

EXPORTING

MODE_ZEMP1 = 'E'

EMPNO = 102.

X_EMPNO = ' '
_SCOPE = '2'
_WAIT = ' '
_COLLECT = ' '
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.

Reward if useful.

Jyothi D

Re: lock objects

Former Member — Fri, 31 Aug 2007 09:31:11 GMT

what is a match code ? Lock objects ?

The MATCH CODE is nothing but a DDIC search help. If you want to assign a search help to a PARAMETERS or SELEC-OPTIONS in your report program you can use MATCH CODE followed by name of the DDIC search help. Make sure that the DATA ELEMENTS are matched when you make the assignment.

for more information on search help please referr the following link it help you

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ee2b446011d189700000e8322d00/content.htm

Lock objects are use in SAP to avoid the inconsistancy at the time of data is being insert/change into database.

SAP Provide three type of Lock objects.

- Read Lock(Shared Locked)

protects read access to an object. The read lock allows other transactions read access but not write access to

the locked area of the table

- Write Lock(exclusive lock)

protects write access to an object. The write lock allows other transactions neither read nor write access to

the locked area of the table.

- Enhanced write lock (exclusive lock without cumulating)

works like a write lock except that the enhanced write lock also protects from further accesses from the

same transaction.

You can create a lock on a object of SAP thorugh transaction SE11 and enter any meaningful name start with EZ Example EZTEST_LOCK.

Use: you can see in almost all transaction when you are open an object in Change mode SAP could not allow to any other user to open the same object in change mode.

Example: in HR when we are enter a personal number in master data maintainance screen SAP can't allow to any other user to use same personal number for changes.

Technicaly:

When you create a lock object System automatically creat two function module.

1. ENQUEUE_<Lockobject name>. to insert the object in a queue.

2. DEQUEUE_<Lockobject name>. To remove the object is being queued through above FM.

regards,

srinivas

Re: lock objects

Former Member — Fri, 31 Aug 2007 09:42:35 GMT

hi jyothi..

its not wrkng... it is gng to dump

Re: lock objects

Former Member — Fri, 31 Aug 2007 09:59:10 GMT

Did u do the same thing like this....

CALL FUNCTION 'ENQUEUE_EZEMP1'

EXPORTING

MODE_ZEMP1 = 'E'

EMPNO = 102.

X_EMPNO = ' '
_SCOPE = '2'
_WAIT = ' '
_COLLECT = ' '

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.

Re: lock objects

Former Member — Fri, 31 Aug 2007 10:04:19 GMT

Try commenting exporting also!!!!

Re: lock objects

Former Member — Fri, 31 Aug 2007 10:17:10 GMT

And At the end call DEQUEUE_EZTEMP also.....

But dont uncomment anything there.......

Re: lock objects

Former Member — Fri, 31 Aug 2007 10:28:26 GMT

if i comment on Exporting , how do u pass the Mode and Empno as parameters.?

Re: lock objects

Former Member — Fri, 31 Aug 2007 10:35:17 GMT

First of all why do u want to pass the lock mode as 'e'.

This lock mode u mighjt hav defined while creating the lock object in Data dictionary itself....once if i can see the code.....i can tell i think.........

Re: lock objects

Former Member — Fri, 31 Aug 2007 10:43:47 GMT

thisz the code

wen im created , i hv mention the Lock mode as "Read Lock'" in ECC6.0

Tables : Zemp1.

CALL FUNCTION 'ENQUEUE_EZEMP1'

EXPORTING

MODE_ZEMP1 = 'E'

EMPNO = 102.

X_EMPNO = ' '
_SCOPE = '2'
_WAIT = ' '
_COLLECT = ' '
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.

Re: lock objects

Former Member — Fri, 31 Aug 2007 11:27:41 GMT

Hi ,

There will be only 3 kinds of lock modes....

1)exclusive,cumulative

2)shared

3)exclusive,non cumulative

this in 4.6 version.....

is tht entire code which is there in ur program......

if u r locking the tbale means u might be doiing some changes to the table rite.....where u hav included that .....

try to sedn the entire code once.........

Re: lock objects

Former Member — Fri, 31 Aug 2007 12:15:10 GMT

im just created a sample lock object to lock a table?

could u tell me the entire process.. How to create a lock object and how to call FM? explain one complete example?