Lock object vith forgien key

[Former Member]

HI All,

I have 4 table that are related via forgin key ,i want to create lock object and my question

is if i need to create lock object for each table or just one lock object.

Best Regards

Joy

[Former Member]

For Lock objects with foreign key , lock object for the primary table alone is enough .

Check below links

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eea5446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_nw70/helpdata/en/af/22ab01dd0b11d1952000a0c929b3c3/content.htm

[Former Member]

Hello KArtik ,

i read the help and one thing that i don't understand is if i have different tables that

the forging key is for instance employee .

when i create lock object enqoue and denque the FM that generate is different so how i can

use just one lock object ?

Regards

Joy

[Former Member]

I think u are using custom tables..its better to create lock for all tables and update tables and unlock all..

cheers

[Former Member]

HI ,

What does it mean ,if the tables are relate via foreign key and i lock one table to update,

does it mean that all the related tables are locked or not ....?

Best Regards

Joy

Edited by: Joy Stpr on Jul 19, 2009 9:02 PM

[Former Member]

I dont think related tables will be locked as you are just updating not inserting new record...

Problem might come when u want to insert new record in one of secondary table..

cheers

[Former Member]

its simple dear,

the number of table you are updating in one go will form the tables in locking objects

for example in save command you are updating 3 table then you will lock three table

and just readting from master table then you will create a seperate lock for your master table ..

i.e you will put a read lock on your master table and write lock on your child table..

just put read lock on master first if successfull. the place the write lock on the child.

Regards