2009 Jul 19 8:41 AM
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
2009 Jul 20 5:54 AM
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
2009 Jul 19 8:53 AM
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
2009 Jul 19 9:19 AM
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 ?
2009 Jul 19 9:47 AM
I think u are using custom tables..its better to create lock for all tables and update tables and unlock all..
cheers
2009 Jul 19 10:22 AM
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 ....?
Edited by: Joy Stpr on Jul 19, 2009 9:02 PM
2009 Jul 20 12:08 AM
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..
Bluesky
