Displaying and Managing Lock Entries SAP BASIS

Lock entries are system objects in charge of protecting the integrity of the data by synchronizing the access, so users cannot modify the same data at the same time. The lock objects are defined in the ABAP dictionary as a way of locking a data object. To display and perform some basic operations on lock entries, from the main administration menu, select Administration | Monitor | Lock Entries (transaction code SM12).

Lock entries initial selection screen

Lock entries initial selection screen

This screen works like a selection criteria display. You can select lock entries for displaying by client, user, specific tables that have locked rows, and by lock entry arguments. By entering the wildcard * in the client and user, the system displays all current lock entries. Clicking on the Continue button will display the list of current lock entries, if any. The display includes the following columns:

  • Cli refers to the SAP system client.
  • User shows the SAP user ID holding the lock.
  • Time indicates the time when the lock was generated.
  • Shared is an indicator that tells whether the lock object is shared or exclusive. With shared lock objects, more than one user might lock the same data.
  • Table includes the name of the table with locked rows.
  • Lock argument shows the fields used by the lock entry.

Lock entries are deleted automatically by the system when the programs release the data objects. However, it might sometimes be useful to display and possibly manually delete the lock entries when a system error has occurred and the dispatcher cannot release the lock. For example, this might happen in cases where users shut down their systems without logging off from the SAP system in an orderly manner. If this happens, users will not be able to access the locked data or mostly by an erroneous user development. It is advisable to contact the previous user to unlock the entry.

To display additional information about a lock entry, click on any of the entries from the list and select the Details button on the application toolbar. This window shows interesting information such as the transaction code being performed by the user, the application server hostname, and the lock object name.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status