topic Re: Is SM30 Multiuser ? in Application Development and Automation Discussions

Is SM30 Multiuser ?

Former Member — Wed, 24 Oct 2007 14:09:27 GMT

Hi Gurus,

Is SM30 Multiuser ?

my requiremet is: If one user create entry using SM30, it should not lock the table.. if it is possible how to do that?

Please reply,

Points will be rewarded.

Thanks,

neo

Re: Is SM30 Multiuser ?

naimesh_patel — Wed, 24 Oct 2007 14:12:18 GMT

In General scenario, SM30 is not a multiuser (as per your definition).

It is not adivisable to have more than one user to update the table simultaneously.

Re: Is SM30 Multiuser ?

RichHeilman — Wed, 24 Oct 2007 14:13:59 GMT

It may depend on the table, but I believe that the table will be locked at record level, so it would be possible for two users to change two different records in the same table at one time.

Regards,

Rich Heilman

Re: Is SM30 Multiuser ?

Former Member — Wed, 24 Oct 2007 14:29:24 GMT

Hi Rich,

Thanks for replying, Yes table should be locked at record level only, But how to do that?

In my current table maintainance, if one user go to change mode, it is showing information message "Data locked by user XYZ (display only)". It is locking all data.

Please reply,

Points will be rewarded

Re: Is SM30 Multiuser ?

Former Member — Wed, 24 Oct 2007 15:59:44 GMT

hi,

You can use ENQUEUE function module to lock certain record of a table.

Usually for all SAP standard table we have ENQUEUE function module available.

For eg function module ENQUEUE_EMEKKOE is used to lock PO and Item no.

See this for more details -

Lock objects:

http://www.sap-img.com/abap/type-and-uses-of-lock-objects-in-sap.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/cf/21eea5446011d189700000e8322d00/content.htm

also an example for u

You can make use of the standard lock objects for locking Material Number rather material master

ENQUEUE_EMMARAS to lock Material Master

DEQUEUE_EMMARAS to unlock Material Master

In order to check just execute the ENQUEUE module with one MATNR number and try to open the same MATNR number in MM02, then it says the material is locked by user ____

Then if you execute the DEQUEUE module then you can be able to change the MATNR number in MM02.

Hope this is clear

Reward if usefull

Re: Is SM30 Multiuser ?

Former Member — Wed, 24 Oct 2007 18:18:15 GMT

Hi Gurus,

I got one solution in this way,

1. Copy include program LSVIMF27 to your custom include. In this custom include, when it call function module VIEW_ENQUEUE, replace ENQUEUE_MODE parameter to 'S'.

2. Copy include program LSVIMFXX to your custom inlcude. In this include, replace include LSVIMF27 to your custom include.

3. In your function group program replace INCLUDE LSVIMFXX with the custom include you created in 2.

4. Reactivate your function group program.

But in this solution Still I am not able to lock entry at field level,

If user1 is editing entry1 in SM30 & if user2 enter with change mode for same table then entry1 should not appear to user2 in change mode.... is it possible?

Points will be rewarded,

Thanks,

neo