‎2008 Jun 13 7:54 AM
Hi Everybody,
I have a quary. I have created a custom table which will be used to store master data entered by multiple Users through a module pool program. The program has following functionalities stated below:
CREATE : Entry of new data.
CHANGE: Changing of existing record.
DELETE: Delete existing record
I need to implement lock system inside the module pool program while performing the above operations. In CHANGE and DELETE mode I have implemented record lock system. But in case of CREATE mode which lock mode should I use, ie should I use whole table lock or particular record lock? agerly waiting for reply.
Regards,
Pulokesh
‎2008 Jun 13 8:08 AM
Hi,
To create a new entry you need not lock the table. But still if you want to lock the table and dont want any one else to modify table while you are creating the lock it has to be on table level. You can not put lock on record level for a new entry.
Hope this clarifies your doubt.
Regards,
Lalit Kabra
‎2008 Jun 13 8:02 AM
please find below links will be helpfull.
http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eea5446011d189700000e8322d00/content.htm
http://help.sap.com/saphelp_nw70/helpdata/en/af/22ab01dd0b11d1952000a0c929b3c3/content.htm
http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eef3446011d189700000e8322d00/content.htm
http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ef0d446011d189700000e8322d00/content.htm
‎2008 Jun 13 8:08 AM
Hi,
To create a new entry you need not lock the table. But still if you want to lock the table and dont want any one else to modify table while you are creating the lock it has to be on table level. You can not put lock on record level for a new entry.
Hope this clarifies your doubt.
Regards,
Lalit Kabra