SM30 Table Maintenance - Record Lock

[Former Member]

Hi,

In sm30 table maintenance one person cannot update a table while another person updating the same table. The message "Locked object" is coming

But my user wants to update the table even while other person is updating too.

Since they do updation on company code level, i want to lock the company code field in that table, insteading of locking the whole table. So users can update the data for their respective company codes simultanously.

But How can I achieve that? I know it must be done through events, but since i dont know anything about events, Please guide me to do this.

Thanks,

Ezhil.

[Former Member]

Hi,

In sm30 table maintenance one person cannot update a table while another person updating the same table. The message "Locked object" is coming

But my user wants to update the table even while other person is updating too.

Since they do updation on company code level, i want to lock the company code field in that table, insteading of locking the whole table. So users can update the data for their respective company codes simultanously.

But How can I achieve that? I know it must be done through events, but since i dont know anything about events, Please guide me to do this.

Thanks,

Ezhil.

[Former Member]

Hi Ezhil,

Please check the link below which will be helpful for you:

[http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8129f164-0a01-0010-2a8e-8765287250fc?language=en]

Regards,

Md Ziauddin.

[Former Member]

Hi,

I am afraid this document will not help me. This is for creating new entries with some validation.

In my table company code is the key field. I want lock for this field. When user is updating data under one company code the other user should not be able to change that country code.

But now the lock for whole table. One cannot open the table in sm30, while others updating the table. Instead of this, i want the lock only for the key field.

Thanks

Ezhil.

[Former Member]

Hi,

According to my knowledge , we cannot do this in SM30 as this is a standard functionality of SAP that 2 people cannot maintain the same table using table maintainence at the same time.

Instead, we can create a program with a selection screen using table control wherein we can provide the fields of the table to be edited and multiple people can use the tcode at the same time.

Then we can build in manual locks at the company code field.

Hope this helps.

Regards,

Samreen.

[Former Member]

Thank you..

I created Row lock instead for whole table.

[Former Member]

Hello,

Can you please explain how did you row lock via sm30 table maintenance.

Thanks.