Row level locking for table maintainance - sm30

[Former Member]

Hello All,,

I have created a ztable with table maintainance in sm30.

I have a requriment in which this ztable will be maintained by multiple users at a time. Currently when one user is using the table .. for the other user it say locked by XXX

So is there any way to lock the ztable table in sm30 at row level?

Please advice ...

Thanks,

Vasavi

[Former Member]

Hello All,,

I have created a ztable with table maintainance in sm30.

I have a requriment in which this ztable will be maintained by multiple users at a time. Currently when one user is using the table .. for the other user it say locked by XXX

So is there any way to lock the ztable table in sm30 at row level?

Please advice ...

Thanks,

Vasavi

[Former Member]

Reward points if it is useful..

[Former Member]

Hi Vasavi Kasamshetty

U can acheive row level locking by lock objects. Try doing this.

For this u need create lock objects for the key fields.

Venkat.

[Former Member]

Hello Venkat,

In my table I have 3 fields and all are primary fields.

Now if I want multiple users to insert records ... do I need to create a transaction program for this ...and before inserting I need to call the newly created lock FM ...

Please help me ....

[Former Member]

Hello Vasavi,

View Maintenance (SM30) is meant for usage for Customizing Tables - normally not many situations where multiple user have to access it simultaneously many times.

Row-wise locking of data is not possible in any application.

Locks are only possible for an entity or an object itself. A table is an object, and is locked when accessed via txns like SM30. A record, is a data line belonging to a table, which is not considered an object by itself.

There is no locking possible, only the 2nd user has to wait for the first user to finish his/her processing.

Best regards,

Rekha

[Former Member]

Hi Vasavi,

you can achieve row-level locking ie by following these steps:

1. Create lock object on your Z-table
2. create customer program (will be called by custom transaction - create this transaction)
3. within this program you will delete all table locks on your Z-table and call your Z-table maintenance screen
4. In your table maintenance code (SE80 - function pool) modify the screen by adding a new module which will lock only the rows you selected to be edited and rows that can't be locked will remain disabled for edit.

For more details, you can follow my step-by-step guide with screenshots and code excerpts on http://oprsteny.com/?p=322