topic Re: Simultaneous Access for table maintenance in Application Development and Automation Discussions

Simultaneous Access for table maintenance

Former Member — Mon, 23 Jun 2008 04:40:00 GMT

My client has a requirement for simultaneous access for a custome table maintenance. For which i found a View frame which i can Edit. How can i apply record level lock on the same?

Re: Simultaneous Access for table maintenance

Former Member — Mon, 23 Jun 2008 06:15:15 GMT

sorry.

Edited by: Vishvesh.K on Jun 23, 2008 8:16 AM

Re: Simultaneous Access for table maintenance

Former Member — Mon, 23 Jun 2008 06:29:08 GMT

Hi,

Pls refer the link below....might help.

Please reward if helpful.

Regards

Re: Simultaneous Access for table maintenance

Former Member — Mon, 23 Jun 2008 20:47:49 GMT

Hello Juhi,

At what type of table you are looking? Is it a Z-table or an SAP table? Either way a simultaneous access is not allowed in SM30. Never ever modify SAP tables! For simultaneous custom-table-access you have to write a program (report or dialog) with ENQUEUE and DEQUEUE Function Modules. Now you can achieve a record lock.

Good luck,

Heinz

Re: Simultaneous Access for table maintenance

Former Member — Tue, 24 Jun 2008 04:27:29 GMT

Hi Heinz,

There is a Z-table for which a view is made(with table maintenance). This view is called in a transaction.

What they require is to be able to get simultaneous access to the Table maintainenance not to edit the same record. but if one user is opened the transaction in Edit mode he should be able to edti one record.and simultaneously other user can access the record for editing which is not alrady in Edit mode.

Re: Simultaneous Access for table maintenance

Former Member — Tue, 24 Jun 2008 22:03:18 GMT

Hi Juhi,

please, take look at the Lock Mechanism:

[http://help.sap.com/erp2005_ehp_03/helpdata/EN/cf/21eed9446011d189700000e8322d00/frameset.htm]

I would implement this task with a concept like this:

- Create a Dialog program

- Display all table lines

- each record has a checkbox to the left

- the user has to check the box (or boxes) of the record(s) he wants to change

- in PBO lock the relevant line and display it in edit mode (at this time only the current user is allowed for modifications).

- in PAI save the record (UPDATE) and unlock it.

- all other users can access this record again.

As said before SE16 or SM30 locks the entire table.

By the way: the customer has to think about his request. In general it is not really wanted allowing modify many users a database at the same time. Only one well defined person should be allowed doing so! There can be a huge trouble regarding data integrity.

Have luck and try to convince your client about changing his mind,

Heinz