07-20-2007 10:52 AM
Hello all ,
How to know who is modifying or maintaining values to a table .
thanks and regards.
prem.
07-20-2007 11:03 AM
Hi
You can use the Function module ENQUEUE_READ to get the list of entries that are locked..
In the internal table ENQ that is returned check if there is an entry for the document...
Ex..
FOr purchasing document check for EKKO in the column GNAME and CLIENT + purchase order number in the column GARG...
IF there is a entry...which means some body is processing that purchase order..
In the field GUNAME..You will get the user name that is processing the document..
also Use the transaction SUIM and try to know other wise check in the tables CDHDR and CDPOS.
Hope this helps to solve ur problem....
<b>do reward if useful....</b>
regards
dinesh
07-20-2007 10:58 AM
Try to modify the table.. if someone else also modifying.. then it will tell u that particular user is changing the table..
Regards
Prax
07-20-2007 11:01 AM
Don't worry, lock automatically applies.. if you want to know who has last changed the content check the field which show the user name of last modified it.
Regards,
Sairam
07-20-2007 11:02 AM
You use lock objects to know if anyone is changing or modifying your table.
Regards,
Reema
07-20-2007 11:03 AM
Hi
You can use the Function module ENQUEUE_READ to get the list of entries that are locked..
In the internal table ENQ that is returned check if there is an entry for the document...
Ex..
FOr purchasing document check for EKKO in the column GNAME and CLIENT + purchase order number in the column GARG...
IF there is a entry...which means some body is processing that purchase order..
In the field GUNAME..You will get the user name that is processing the document..
also Use the transaction SUIM and try to know other wise check in the tables CDHDR and CDPOS.
Hope this helps to solve ur problem....
<b>do reward if useful....</b>
regards
dinesh
07-20-2007 11:15 AM
HI,
When a particular user is modifying a table and if other user is trying to modify
it gives a error message saying that 'Table Locked by user'
or else u can also check in the attributes who was the last user changed the table.
If you are modifying a table and want to restrict other users acess it
u can create a lock objects by using function modules
ENQUE to lock the object
and DEQUE to release the object
Regards,
Srinivas