Multiple Users need (maintenance) access to a customized table.

[Former Member]

Hi Gurus

We created a z table and maintained couple of values in it

The _attributes _ are as follows:

Delivery Class : A (Application table (master and transaction data)

Table Maintenance : Display and Maintenance allowed

ISSUE :

This table does not allow multiple access. In other words, multiple users have to enter this table and change values in this table. Is that possible?

Could you let me know how can this be done?

Thanks a lot

Sridevi

[Former Member]

Hi,

If the attributes you have mentioned are correct then it will allow multiple users to edit the values and insert new values.

I can change the values of tables created by other users. its working for me.

but if the client is different then you need privilages for those users.

Thanks and Regards.

[Former Member]

Infact Its stopping me in DEV as well. Any ideas?

regards

Sridevi

[Former Member]

Hello,

I would check if it is using any ENQUEUE AND DEQUEUE FM....maybe that is why you r not allowed to update the table from multiple users.

please also look for autority checks on the table.

Bye

Gabriel

Edited by: Gabriel Fernando Pulido V. on Jun 4, 2008 11:49 AM

[Former Member]

Hi,

please check whether there are any locks on the database table as said by our friend.

Goto Sm12 and check whether there are any locks.

Thanks and Regards.

[Former Member]

Hi Both

I m a fucntional person. So, not understood much of your techinal language. Even, I read functional info in SM12 but thats going top of my head.

I checked in SM12, a lock is showing up there for this table.

We tried SM30 and assigning this to a Z T code as well. But, no use.

Pls guide me in detail.

Thanks a lot for your time

Sridevi

[christine_evans]

By default, I think SM30, and probably SE16 as well, will lock the entire table if someone is trying to change it. So, only one person can maintain the table at a time. This is the simplest way that it can ensure data integrity.

If I wanted multiple users to be able to maintain a table simultaneously, I'd create a custom screen (dynpro, user dialog, whatever you want to call it) to do it, using lock objects (ENQUEUE and DEQUEUE function modules that you create for the key of your table) to lock / unlock specific rows when a user wanted to change them. I also might use some sort of reference number generator to ensure unique keys.

Not a terrifically complicated piece of development but you'd need to get a Abaper to do it.

[Former Member]

Thanks a lot all of you guys!

[Former Member]

.