topic Re: unlock in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/unlock/m-p/3431033#M824133 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>We can use the function modules ENQUEUE_E_TABLE for locking tables and the function module DEQUEUE_E_TABLE for unlocking tables. With this method, we don't need to lock objects in order to lock the tables. In other words, any table can be locked/unlocked using these function modules.</P><P></P><P>report zsubhas_enqueue.</P><P></P><UL><LI level="1" type="ul"><P>testing the locking of tables...</P></LI></UL><P>data:</P><P> varkey like rstable-varkey.</P><P></P><P> varkey = sy-mandt.</P><P></P><UL><LI level="1" type="ul"><P>locking the tables............................</P></LI></UL><P>call function 'ENQUEUE_E_TABLE'</P><P> exporting</P><UL><LI level="1" type="ul"><P> MODE_RSTABLE = 'E'</P></LI></UL><P> tabname = 'MARA'</P><P> varkey = varkey</P><UL><LI level="1" type="ul"><P> X_TABNAME = ' '</P></LI><LI level="1" type="ul"><P> X_VARKEY = ' '</P></LI><LI level="1" type="ul"><P> _SCOPE = '2'</P></LI><LI level="1" type="ul"><P> _WAIT = ' '</P></LI><LI level="1" type="ul"><P> _COLLECT = 'X'</P></LI></UL><P> exceptions</P><P> foreign_lock = 1</P><P> system_failure = 2</P><P> others = 3</P><P> .</P><P> case sy-subrc.</P><P> when 1.</P><P> message i184(bctrain) with 'Foreignlock'.</P><P> when 2.</P><P> message i184(bctrain) with 'system failure'.</P><P> when 0.</P><P> message i184(bctrain) with 'success'.</P><P> when others.</P><P> message i184(bctrain) with 'others'.</P><P> endcase.</P><P></P><UL><LI level="1" type="ul"><P>unlocking the table...............</P></LI></UL><P></P><P> call function 'DEQUEUE_E_TABLE'</P><P> exporting</P><UL><LI level="1" type="ul"><P> MODE_RSTABLE = 'E'</P></LI></UL><P> tabname = 'MARA'</P><P> varkey = varkey</P><UL><LI level="1" type="ul"><P> X_TABNAME = ' '</P></LI><LI level="1" type="ul"><P> X_VARKEY = ' '</P></LI><LI level="1" type="ul"><P> _SCOPE = '3'</P></LI><LI level="1" type="ul"><P> _SYNCHRON = ' '</P></LI><LI level="1" type="ul"><P> _COLLECT = ' '</P></LI></UL><P> .</P><P></P><P></P><P>Regards</P><P>Nanda</P></BODY></HTML> Sun, 24 Feb 2008 12:59:18 GMT Former Member 2008-02-24T12:59:18Z unlock https://community.sap.com/t5/application-development-and-automation-discussions/unlock/m-p/3431032#M824132 <HTML><HEAD></HEAD><BODY><P>how to unlock the data base tables?</P></BODY></HTML> Sun, 24 Feb 2008 12:45:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/unlock/m-p/3431032#M824132 Former Member 2008-02-24T12:45:19Z Re: unlock https://community.sap.com/t5/application-development-and-automation-discussions/unlock/m-p/3431033#M824133 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>We can use the function modules ENQUEUE_E_TABLE for locking tables and the function module DEQUEUE_E_TABLE for unlocking tables. With this method, we don't need to lock objects in order to lock the tables. In other words, any table can be locked/unlocked using these function modules.</P><P></P><P>report zsubhas_enqueue.</P><P></P><UL><LI level="1" type="ul"><P>testing the locking of tables...</P></LI></UL><P>data:</P><P> varkey like rstable-varkey.</P><P></P><P> varkey = sy-mandt.</P><P></P><UL><LI level="1" type="ul"><P>locking the tables............................</P></LI></UL><P>call function 'ENQUEUE_E_TABLE'</P><P> exporting</P><UL><LI level="1" type="ul"><P> MODE_RSTABLE = 'E'</P></LI></UL><P> tabname = 'MARA'</P><P> varkey = varkey</P><UL><LI level="1" type="ul"><P> X_TABNAME = ' '</P></LI><LI level="1" type="ul"><P> X_VARKEY = ' '</P></LI><LI level="1" type="ul"><P> _SCOPE = '2'</P></LI><LI level="1" type="ul"><P> _WAIT = ' '</P></LI><LI level="1" type="ul"><P> _COLLECT = 'X'</P></LI></UL><P> exceptions</P><P> foreign_lock = 1</P><P> system_failure = 2</P><P> others = 3</P><P> .</P><P> case sy-subrc.</P><P> when 1.</P><P> message i184(bctrain) with 'Foreignlock'.</P><P> when 2.</P><P> message i184(bctrain) with 'system failure'.</P><P> when 0.</P><P> message i184(bctrain) with 'success'.</P><P> when others.</P><P> message i184(bctrain) with 'others'.</P><P> endcase.</P><P></P><UL><LI level="1" type="ul"><P>unlocking the table...............</P></LI></UL><P></P><P> call function 'DEQUEUE_E_TABLE'</P><P> exporting</P><UL><LI level="1" type="ul"><P> MODE_RSTABLE = 'E'</P></LI></UL><P> tabname = 'MARA'</P><P> varkey = varkey</P><UL><LI level="1" type="ul"><P> X_TABNAME = ' '</P></LI><LI level="1" type="ul"><P> X_VARKEY = ' '</P></LI><LI level="1" type="ul"><P> _SCOPE = '3'</P></LI><LI level="1" type="ul"><P> _SYNCHRON = ' '</P></LI><LI level="1" type="ul"><P> _COLLECT = ' '</P></LI></UL><P> .</P><P></P><P></P><P>Regards</P><P>Nanda</P></BODY></HTML> Sun, 24 Feb 2008 12:59:18 GMT https://community.sap.com/t5/application-development-and-automation-discussions/unlock/m-p/3431033#M824133 Former Member 2008-02-24T12:59:18Z