topic Re: Table maintenance generator multiple users entry at the same time in Application Development and Automation Discussions

Table maintenance generator multiple users entry at the same time

Former Member — Mon, 15 Apr 2013 12:32:21 GMT

Dear,

Kindly we need to give the ability to multiple user to access and make new entries in the same table on the same time in table maintain generator .

Re: Table maintenance generator multiple users entry at the same time

Former Member — Mon, 15 Apr 2013 12:54:09 GMT

This message was moderated.

Re: Table maintenance generator multiple users entry at the same time

RaymondGiuseppi — Mon, 15 Apr 2013 13:11:07 GMT

By default SM30 will lock the full table (it locks the table in fact (RSTABLE / E_TABLEE)

You could use one of the events of the dialog maintenance to dequeue the lock. (Extended Table Maintenance Events)

But then two users will be able to change same record as the generated program doesn't lock records, so at your own risks, you could consider developing a true module program yourself.

Regards,

Raymond

Re: Table maintenance generator multiple users entry at the same time

Former Member — Tue, 16 Apr 2013 09:59:46 GMT

This message was moderated.

Re: Table maintenance generator multiple users entry at the same time

Former Member — Tue, 16 Apr 2013 10:17:35 GMT

You could also make the same comment about the reply of sai krishna, based on an incorrect understanding of the table authorisation concept.

Re: Table maintenance generator multiple users entry at the same time

Former Member — Tue, 16 Apr 2013 10:46:08 GMT

I think you can use Row locking concept and make your own customize transaction to create the entries.

Regards,

Rahul Singh

Re: Table maintenance generator multiple users entry at the same time

Former Member — Tue, 16 Apr 2013 11:15:34 GMT

This message was moderated.

Re: Table maintenance generator multiple users entry at the same time

Former Member — Tue, 16 Apr 2013 11:21:24 GMT

You can go for row level locking wherein two users can access the same table at a time but not the same row..

You can refer to this link to implement the same

http://saptechnical.com/Tutorials/ABAP/Lock/Page1.htm

Thanks,

Namrata

Re: Table maintenance generator multiple users entry at the same time

Former Member — Tue, 16 Apr 2013 11:31:47 GMT

This message was moderated.

Re: Table maintenance generator multiple users entry at the same time

matt — Tue, 16 Apr 2013 12:55:16 GMT

I've removed posts which refer to client dependence/independence, and authorisation groups as they are simply wrong in the context of the original post.