Managing locks

[Former Member]

Hi All,

I have a custom table that gets locked whenever someone tries to update it. Instead of the entire table getting locked, can I make it record locked ? If so, how do i do it ? The field VIMDESC-SUBSETFLAG is the one that determines this behavior I suppose.

[Former Member]

Hi Pavan,

Yes you can lock a specific row, visit these links.

http://help.sap.com/saphelp_erp2004/helpdata/en/5e/eba673440a11d3a98200a0c9449261/content.htm

http://help.sap.com/saphelp_erp2004/helpdata/en/d2/cb9a7844d911d3a98200a0c9449261/frameset.htm

It may help you.

Regards,

Narinder Hartala

Message was edited by: Narinder Hartala

[jayanthi_jayaraman]

Hi,

Create an authorization object for change mode. Loop at screen in the user exit and set input to 0. Check the record. Decide whether input should be 0 or 1.

Hope this helps if you want to lock particular record.

[Former Member]

Hi,

http://help.sap.com/saphelp_46c/helpdata/en/dc/174b6e5733d1118b3f0060b03ca329/frameset.htm

Have a look into this.

Thanks & Regards,

Judith.

[Former Member]

Hi Pavan,

I assume that you have created a z table and have generated a table maintenance dialog for this.

When you hit change in a table mainteance dialog it opens all the records for input. Therefore, it must lock the whole table otherwise you may get concurrent update of data.

To lock on a record basis you would need to change the table maintenance dialog to only open selected rows for change, and I don't think this is possible using the standard functionality.

I would suggest that if this is a strong requirement that you develop your own custom table maintenance screen (which edits data row by row and not the whole table at once) and then of course you can lock on a record basis.

For help on implementing locks, I don't like much the links in the other posts, check out the following link for help on using lock objects:

http://help.sap.com/saphelp_46c/helpdata/en/a2/3547360f2ea61fe10000009b38f839/frameset.htm

Cheers,

Brad

[Former Member]

Thank you all.

It was indeed helpful !!