Record Level Locking

[Former Member]

Hi friends

1) I have locked a record in Exclusive mode(X) now it works when some buddy try to edit that record but not in case of display that record why.

2) While user create a new record how to block that record based on Primary key so that other user simultaniouly can not make new record with the same Primary Key condition.

Regards

Pulkit Agrawal

[Former Member]

you can create a shared lock.

Shared locks (or read locks) allow you to prevent data from being changed while you are reading it. They prevent other programs from setting an exclusive lock (write lock) to change the object. It does not, however, prevent other programs from setting further read locks.

[Former Member]

Hi

1) i want while i am editing it no buddy is allowed to see it? I have provided the exclusive lock.

2) While user create a new record how to block that record based on Primary key so that other user simultaniouly can not make new record with the same Primary Key condition.

Ex : - MM01 transaction material number.

regards Pulkit Agrawal

[Former Member]

Hi,

While inserting a new record, no need to lock the table. But if there is a scenario where User 1 or User 2 would create a record with same primary key, then lock the entire table.

Since the record is not yet created, no point in trying to lock the table at record level. It should be locked at table level.

Best regards,

Prashant

[Former Member]

Hi,

See the below link, this will show how to create the LOCK object and write the code to lock the table entries

http://www.sapdevelopment.co.uk/dictionary/lock_enqueue.htm

Regards

Sudheer