topic Re: restrict multiple users from edit the data in custom tcode in Application Development and Automation Discussions

restrict multiple users from edit the data in custom tcode

Bharath84 — Wed, 20 Nov 2019 13:36:51 GMT

Hi All,

In my module pool, I have two input fields and in application tool bar I have Create, Change and Display icons. For the given inputs user clicks on Create/Change and enter some data in the table controls and save the data into database. If one user is trying to Create/Change the data for the given inupts, other users should not be able to go Create/Change mode. Only Display mode should be allowed. I used the function module 'RSAU_WRITE_SM01_LOG' but still other users are able to go into change mode. How can we restrict this. Please let me know if anyone have done this.

Thanks,

Haritha

Re: restrict multiple users from edit the data in custom tcode

Sandra_Rossi — Wed, 20 Nov 2019 13:42:35 GMT

I think you go completely the wrong way with RSAU_WRITE_SM01_LOG!

What you are looking for is a lock to be set when a user is editing the "object", and any other person trying to edit this same object will be rejected because a lock exists. Please search the forum for "lock object" (enqueue, dequeue, etc.)

Re: restrict multiple users from edit the data in custom tcode

IN — Wed, 20 Nov 2019 13:47:33 GMT

Hello,

You should look at locking objects concept in SAP. There you can find the way to lock a table and what are the options when doing the locking.

For more information, be free to ask.

Regards,

Igor

Re: restrict multiple users from edit the data in custom tcode

dev_parbutteea — Wed, 20 Nov 2019 13:48:35 GMT

Hi,

I do not know which object you are updating but you may use lock objects to restrict access (via enqueue & dequeue).

Re: restrict multiple users from edit the data in custom tcode

Gourab_Dey — Wed, 20 Nov 2019 19:04:02 GMT

You have to use the lock object. You will get enough information in google. So, basically when you create a lock object, 2 function module will be created. Once for en-queue that is to put a lock and another one is de-queue which is to release the lock. Once it's lock, you can see it in SM12.

Thanks,

Gourab

Re: restrict multiple users from edit the data in custom tcode

keremkoseoglu — Thu, 21 Nov 2019 05:24:58 GMT

Create a custom (Z-) lock object for your T-Code. If a user can enqueue, he/she can edit. If not, he/she should see the data in read only mode.

Re: restrict multiple users from edit the data in custom tcode

ThangaPrakash — Thu, 21 Nov 2019 05:44:44 GMT

@Haritha P It can be achieved by using lock object, create a lock object for the table which you are using in the Table control.

In the beginning of the program call created lock objects ENQUEUE to lock the data and at the end call DEQUEUE to release the lock

SAP Help Lock objects

Lock Object creation and consumption reference

Re: restrict multiple users from edit the data in custom tcode

Bharath84 — Thu, 21 Nov 2019 07:02:27 GMT

Hi Prakash,

I have already used this ENQUE and DEQUE function modules in my module pool program when updating my custom tables. Here what I am trying to do is, if one user click on Change icon in application tool bar, all the tabs are in editable mode. If other users try to click on Change icon, it should throw an error message 'One user already editing the data, only display allowed'.

Thanks,

Haritha

Re: restrict multiple users from edit the data in custom tcode

ThangaPrakash — Thu, 21 Nov 2019 07:20:25 GMT

vidya.p If that is the case, under Change Icon user command, check for the lock entries using FM 'ENQUEUE_READ' and if there is lock for your transaction/program/table, then raise a message 'One user already editing the data, only display allowed'.

Re: restrict multiple users from edit the data in custom tcode

SimoneMilesi — Thu, 21 Nov 2019 09:16:57 GMT

vidya.p that's the use of Lock objects!

Read if the object is locked
If locked, throw error on edit
if not locked, lock it and procede with editing.
At save, release the lock

Re: restrict multiple users from edit the data in custom tcode

Sandra_Rossi — Thu, 21 Nov 2019 10:44:16 GMT

Generally speaking, to support mass update in background in parallel processes, between the read (1) and the lock (3), it could be locked by another process, so I think it's best to use this logic as rule of thumb:

Try to lock the object (ENQUEUE)
If locked, throw error on edit
Otherwise proceed with editing.
At save, release the lock