topic Re: Locking a Program for only 1 user in edit mode in Application Development and Automation Discussions

Locking a Program for only 1 user in edit mode

Former Member — Mon, 24 Jun 2013 18:36:22 GMT

Hi experts, I need to be able to lock a program based on a paramter on the selection screen so that only one user can edit at a time. Just like MM02, COr2, and XD02 have the ability to restrict one user to change the material number, process order and customer numbers.

This will be different than just chcking for a lock table.

Any help would be appreciated.

Thanks

Jayden

Re: Locking a Program for only 1 user in edit mode

Former Member — Tue, 25 Jun 2013 03:23:01 GMT

Hi Jayden,

I doubt i understand your question.

A program can only be edited by a single user at a time and that is standard behavior.

Having said that, if you want a single user to run any program at a time, then you can refer the code here - http://scn.sap.com/thread/1838118.

BR.

Re: Locking a Program for only 1 user in edit mode

Former Member — Tue, 25 Jun 2013 03:46:25 GMT

Hi Jayden,

You can achieve by using LOCK OBJECT.

Thanks

Pavan

Re: Locking a Program for only 1 user in edit mode

Former Member — Tue, 25 Jun 2013 04:23:20 GMT

Your Lock Object should have the values which you wanted lock from other users.

As In MM02 selection-screen, locking parameter is client+material number.

Same way you should have your required fields in your locking parameter.

Re: Locking a Program for only 1 user in edit mode

matt — Tue, 25 Jun 2013 04:30:59 GMT

This won't be any different from checking a lock table. In fact, that is your solution.

Re: Locking a Program for only 1 user in edit mode

arindam_m — Tue, 25 Jun 2013 04:47:10 GMT

Hi,

The program can be edited ( as in change code ) only by single user at a time. But if you meant that only one user can execute the program at any given time you can achieve the same by setting parameters say like a flag field in Ztable is set via the selection screen checkbox to state that the program is being used.

The code should clear it at the end of program. Then you can always have a list to refer to via any program that you want checked before execution

Cheers,

Arindam

Re: Locking a Program for only 1 user in edit mode

Former Member — Tue, 25 Jun 2013 12:59:43 GMT

Sorry, I was referring to the execution of the program, not the editing of the program in se38 or se80.

In using a LOCK OBJECT what happens if the connection to SAP is lost or the program never finishes?

My worries is with a hung session. Would assigning a value to a memory ID work? Then FREE this value once the program is finished?

Arindam, this is the reason that I don't want to create a value and put in a ztable.

Re: Locking a Program for only 1 user in edit mode

Former Member — Tue, 25 Jun 2013 13:00:06 GMT

I almost forgot. THanks for ALL of the replys

Re: Locking a Program for only 1 user in edit mode

former_member213275 — Tue, 25 Jun 2013 13:11:52 GMT

Hi Jayden,

As Pavan and others said just create a lock object in SE11 specifying the table name that needs to edited by one user and then call the function module "ENQUEUE_yourlockobject" in program and at the end dequeue.

Srikanth.

Re: Locking a Program for only 1 user in edit mode

Former Member — Tue, 25 Jun 2013 14:17:48 GMT

Can this be done by value? For example, when a user is changing a material in MM02, MARA is locked, only that Material Number is locked.

Thanks

Jayden

Re: Locking a Program for only 1 user in edit mode

Former Member — Tue, 25 Jun 2013 16:36:56 GMT

Hi Jayden,

You are on the right track, and you've been given good advice so far.

For example if you search the lock objects available in SE11 for "MARA" in the description, you may find lock object EMMARAE.

That has lock parameters of MANDT and MATNR, so you can limit to a single material.

You can lock more than 1 table with a lock object if that is your requirement and the right foreign keys are avialable.

If you are worried about old locks causing problems, just check out transaction SM12. In fact, why not write a little prototype and check out SM12 while running your code through the debugger.

Hope this helps, and watch out for deadly embraces

Stuart.

Re: Locking a Program for only 1 user in edit mode

Former Member — Wed, 26 Jun 2013 06:36:08 GMT

Hi Jayden,

Please see the sample code at

http://scn.sap.com/thread/1838118.

BR.

Re: Locking a Program for only 1 user in edit mode

RaymondGiuseppi — Wed, 26 Jun 2013 07:09:25 GMT

You could read some documentation like The SAP Lock Concept, and its Example Program: SAP Locking. (after a brief search on google with option site:help.sap.com)

Regards,

Raymond

Re: Locking a Program for only 1 user in edit mode

Former Member — Wed, 26 Jun 2013 07:30:21 GMT

Dear Jaydan,

You can create Lock object using T-code SE11 , Naming convention start with 'E' e.g. Exxx (where xxx is a table name), then say create. Then 'table tab' please select correct locking mode that is either 'Read' or 'Write' and under 'lock parameter tab' you select which column are required to be lock.

Once you create and activate automatically two functions modules are getting created like

ENQUEUE_Exxx ( To lock)

DEQUEUE_Exxx ( To unlock)

and use above function modules for locking the tables. Also you can use secondary tables for locking purpose.

Regards

Vaman Kamat