10-24-2007 3:09 PM
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
10-24-2007 3:12 PM
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.
10-24-2007 3:13 PM
10-24-2007 3:29 PM
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
10-24-2007 4:59 PM
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
10-24-2007 7:18 PM
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