topic Re: SM12 Lock table in Application Development and Automation Discussions

SM12 Lock table

Former Member — Thu, 14 Aug 2008 05:43:08 GMT

Dear all,

My program is doing a huge Zxxx table update. But before i perform table updating i want to place a lock on Zxxx table, and my table primary key fields are:

1. MANDT

2. MATNR

3. BWKEY

For each processing, program will handle at least 10,000 material. Which means i need to place 10,000 locks for the table.

I would like to know if there is number of lock limit that a program can place each session?

Please also comment if i got the primary key fields sequence arrangement correct ?

Thanks in advance.

Re: SM12 Lock table

Former Member — Thu, 14 Aug 2008 05:49:02 GMT

here if you want to lock entire table then create a Lock object of that table... and use the function modules generated by this object to lock the tale...

with this lock object you can have entry level lock as well...

Re: SM12 Lock table

Former Member — Thu, 14 Aug 2008 05:51:01 GMT

Hi, thanks for your reply. However please comment base on my question posted above. Thank you.

Re: SM12 Lock table

Former Member — Thu, 14 Aug 2008 05:53:15 GMT

Hi,

http://help.sap.com/saphelp_nw04/helpdata/EN/c2/2d7037ecc92a7ee10000009b38f8cf/content.htm

Re: SM12 Lock table

RaymondGiuseppi — Thu, 14 Aug 2008 06:06:14 GMT

Look at OSS [Note 13907 - System error in the block handler, overflow lock table|https://service.sap.com/sap/support/notes/13907]

You could also consider locking the whole table by using a generic key.

Regards