topic Re: Lock Object in Application Development and Automation Discussions

Lock Object

Former Member — Fri, 30 May 2008 10:44:12 GMT

hi all,

i need to create lock object at Row level, can anyone please tell me the step by step procedure?

its urgent.

regards saurabh.

Re: Lock Object

Former Member — Fri, 30 May 2008 10:45:15 GMT

Locking is not possible at row level.

It is possible at only table level.

rwrd if helpful

Bhupal

Re: Lock Object

Former Member — Fri, 30 May 2008 10:55:30 GMT

Hi,

Find the below links

[http://www.sap-img.com/abap/type-and-uses-of-lock-objects-in-sap.htm|http://www.sap-img.com/abap/type-and-uses-of-lock-objects-in-sap.htm]

[http://help.sap.com/saphelp_nw04/helpdata/en/41/7af4c5a79e11d1950f0000e82de14a/content.htm|http://help.sap.com/saphelp_nw04/helpdata/en/41/7af4c5a79e11d1950f0000e82de14a/content.htm]

Step by Step

Note: Row level locking will affect the SAP performance.

1. Go to SE11

2. Give the lock object name [EZJKAK](lock object name start with EZ) and click 'Create' Button.

3. Enter the short description,Table name[jkak], lock mode and key fields which is used to lock the entry.

4. Save and activate, it will generate 2 FM.

Ex:

DEQUEUE_EZJKAK Release lock on object EZJKAK

ENQUEUE_EZJKAK Request lock for object EZJKAK

In your program,

1. First loop the table.

2. call the FM 'ENQUEUE_EZJKAK' to lock.

3. Update the dB.

4. Release the lock using DEQUEUE_EZJKAK.

endloop.

DEQUEUE_ALL this FM will release all the lock.

Reward if it is helpful

Regards

Boobalan Suburaj.

Edited by: Boobalan Suburaj on May 30, 2008 1:56 PM

Re: Lock Object

Former Member — Fri, 30 May 2008 10:56:32 GMT

Hi,

One type of lock is the optimistic lock at row level.

see the help

http://help.sap.com/saphelp_erp2004/helpdata/en/50/eff4bb41124f4783ac34ab5c6a3588/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/8e/c7430d53fd2548be18a291c27bd72e/content.htm

Regards

Kiran Sure

Re: Lock Object

Former Member — Fri, 30 May 2008 10:57:24 GMT

hi check this...

regards,

venkat