Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to know who is modifing or maintaining values in a table /

Former Member
0 Kudos

Hello all ,

How to know who is modifying or maintaining values to a table .

thanks and regards.

prem.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

5 REPLIES 5

Former Member
0 Kudos

Try to modify the table.. if someone else also modifying.. then it will tell u that particular user is changing the table..

Regards

Prax

former_member196280
Active Contributor
0 Kudos

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

Former Member
0 Kudos

You use lock objects to know if anyone is changing or modifying your table.

Regards,

Reema

Former Member
0 Kudos

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

Former Member
0 Kudos

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