topic Re: Lock in parameter/select-options field in Application Development and Automation Discussions

Lock in parameter/select-options field

Former Member — Mon, 07 Nov 2005 06:31:17 GMT

Hi,

How can we block another user from executing report with the same value of parameter/select-option field entered on screen by user?

for example:

Report ZZZ, parameter field sales org = A, run by user 1.

Another user, say B, attempts to run the report by entering the same sales org = A. In these second execution of the report, I need to display error message saying that user A is running the report then report cant be run by user B.

Do i need to put lock object for these?

thanks alots

Alia

Re: Lock in parameter/select-options field

Former Member — Mon, 07 Nov 2005 06:36:08 GMT

No, there is no mechanism to restrict in that way.

but you can create a Z-table with one column (vkorg)

now make a little change in the report..

1.check if any entry of vkorg is there in that z-table.

if not proceed, else error msg.

2.craete an entry of that vkog in that z-table.

3.Normal processing of this report.

4.at end delete that entry of vkorg from z-table.

thus you can achieve mutual exclusion.

cheers.

Message was edited by: Anid

Re: Lock in parameter/select-options field

Vinod_Chandran — Mon, 07 Nov 2005 06:38:16 GMT

Hi Alia,

Try creating a lock object with the parameters you want to check. This can be from different database tables. Then in the start of selection call the lock object with the parameters given. If another user run the program with the same parameters, the locking will fail and you can give an error message and exit from the program.

Cheers

Vinod

Re: Lock in parameter/select-options field

Former Member — Mon, 07 Nov 2005 06:59:37 GMT

Hi all,

thanks alots for the given solution. I use lock object and can work perfectly.

again, huge thanks

Alia

Re: Lock in parameter/select-options field

andreas_mann3 — Mon, 07 Nov 2005 07:07:37 GMT

Hi ,

otr try that (without lock object):


  sptab-TABNAME = 'TVKO'.
  concatenate sy-mandt 'A' into sptab-VARKEY .

  CALL FUNCTION 'ENQUEUE_E_TABLE'
       EXPORTING
            TABNAME        = sptab-TABNAME
            VARKEY         = sptab-VARKEY
       EXCEPTIONS
            FOREIGN_LOCK   = 1
            SYSTEM_FAILURE = 2
            OTHERS         = 3.

Andreas

Re: Lock in parameter/select-options field

Former Member — Mon, 07 Nov 2005 08:11:50 GMT

Hi Andreas.

Thanks alots. I have tried your solution, can work. I no need to create own lock object.

Thanks!!

Alia