topic Re: How to create a lock object dynamically ? in Application Development and Automation Discussions

How to create a lock object dynamically ?

Former Member — Sun, 08 Mar 2009 07:56:13 GMT

Hi all,

I have a report with a selection screen having one parameter in which the user can put a table name(Custom table) and some other paremeters.Based on these parameters I need to delete records from table put on the selection screen.Before deeting I need to lock the table. As beforehand I dont know the table name how can I create lock object dynamically lock my table ?

Please suggest some idea...

Re: How to create a lock object dynamically ?

Former Member — Sun, 08 Mar 2009 08:08:13 GMT

use this fm

ENQUEUE_E_TABLE

кu03B1ятu03B9к

Re: How to create a lock object dynamically ?

Former Member — Sun, 08 Mar 2009 12:09:25 GMT

But how to create the lock object dynamically? It is not possible to create lock object in SE11....

Re: How to create a lock object dynamically ?

Former Member — Sun, 08 Mar 2009 12:15:16 GMT

Firstly, put your table name into table DD25L-ROOTTAB. You'll get DD25L-VIEWNAME as a lock object.

Secondly, put VIEWNAME to table DD27S-VIEWNAME to extract all lock parameter.

This solution will applicable for table which has already created lock object.

In case you want to create lock object dynamically without manually create also, generate BDC for this matter is one idea.

Cheers,

Thanagit

Re: How to create a lock object dynamically ?

Former Member — Mon, 09 Mar 2009 13:19:22 GMT

Hi,

while u enter the table name on the selection screen run a bdc in the background creating Lock Object in SE11, Provide the table name to the BDC and create a lock object for that table..

now, pass the lock object created to the FM ENQUEUE_E_TABLE ...

the table is locked dynamically..

try this out

thanks

ravi

Edited by: Ravi Aswani on Mar 9, 2009 2:19 PM

Re: How to create a lock object dynamically ?

Former Member — Tue, 10 Mar 2009 09:50:33 GMT

have a look

[table|http://help.sap.com/saphelp_nwpi71/helpdata/en/af/22ab01dd0b11d1952000a0c929b3c3/content.htm]

Regards

Shashi

Re: How to create a lock object dynamically ?

Former Member — Tue, 10 Mar 2009 11:46:53 GMT

Hi,

check below link

http://help.sap.com/erp2005_ehp_03/helpdata/EN/7b/f9813712f7434be10000009b38f8cf/frameset.htm

Regards,

Madhu

Re: How to create a lock object dynamically ?

shadow — Sun, 05 Apr 2009 08:59:44 GMT

Hi bose,

check this link..........

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21eef3446011d189700000e8322d00/content.htm

With Regard's

Shaik.

Re: How to create a lock object dynamically ?

Peranandam — Fri, 10 Apr 2009 13:07:36 GMT

HI,

you dont need to create lock object for locking table entries. you can also lock table dynamically by using this FM VIEW_ENQUEUE.

Edited by: peranandam chinnathambi on Apr 10, 2009 3:07 PM

Re: How to create a lock object dynamically ?

alejandro_bindi — Fri, 10 Apr 2009 23:07:44 GMT

The solution Thanagit proposes, retrieving the already existing lock object from DD tables is the only one which has sense.

There's no point in generating the lock object dynamically and then using it, since no other program (which could be using the same records to be deleted) will lock the table anyway...

Re: How to create a lock object dynamically ?

Former Member — Mon, 13 Apr 2009 04:43:22 GMT

Hi,

go through this link----

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21eebf446011d189700000e8322d00/frameset.htm

regards,

Prashant