What is lock object in SAP?

Lock Object is a feature offered by ABAP Dictionary that is used to synchronize access to the same data by more than one program. Data records are accessed with the help of specific programs. Lock objects are used in SAP to avoid the inconsistency when data is inserted into or changed in the database.

What is lock mechanism in SAP?

The SAP system is equipped with a special lock mechanism that synchronizes database access. The purpose of the lock mechanism is to prevent two transactions from changing the same data in the database simultaneously. Implementation Considerations. Locks are defined generically as “lock objects” in the Data Dictionary.

How do you unblock material at plant level in SAP?

Go to MM02 and Select you Material and Select Basic Data1 View and Change the X Plant Material Status to Blank Also Select Purchasing View and Change the Plant Sp. Material Status to Blank & Save. To Unblock the Material Type Go to OMS2 and Select the Material type and Change the X Plant Material Status to Blank.

How do you lock in SAP?

Lock Client of SAP system

Run tr. SE37.
Enter the name of the module SCCR_UNLOCK_CLIENT.
Press F8 to activate.
Enter the number of client and press (F8).

What is type of lock object?

Lock objects are function modules to avoid accessing data by two or more users. There are two types of lock objects are available, DEQUEE, ENQUEE. Shared Lock: Several users can read the same data at the same time, but as soon as a user edits the data, a second user can no longer access this data.

What are the types of locks in SAP?

There are four types of locks in the SAP System:

Shared lock.
Exclusive lock.
Exclusive but not cumulative lock.
Optimistic lock.
→ see also.

What are different types of lock objects?

There are two types of lock objects are available, DEQUEE, ENQUEE. Type of locks: Exclusive Lock: The locked data can be read or processed by one user only. Shared Lock: Several users can read the same data at the same time, but as soon as a user edits the data, a second user can no longer access this data.

How do I remove a material block in SAP?

Enter in the sales org and plant into the org levels selection box that pertain to the plant location that has inventory. 3. Check Basic Data 1 view –> Field: X-plant matl status –> remove value and remove coresponding valid from date. 4.

How do I view blocked materials in SAP?

If you have block for “X-plant matl status” on basic data 1 tab. Then you can see the blocked material from table MARA, with filtering value 01 or 02 for field MSTAE. And if you used MM06 for deletion flag for material, Then you can see the blocked material from table MARA, with filtering value X for field LVORM.

What is the types of lock in SAP?

There are four types of locks in the SAP System: Shared lock. Exclusive lock. Exclusive but not cumulative lock.

What are the function modules used for lock objects?

When you activate a lock object in the ABAP Dictionary, the system automatically creates function modules for setting (ENQUEUE_) and releasing (DEQUEUE_) locks. The system automatically assigns the generated function modules to function groups.

How do I find a material block in SAP?

Is there a way to unlock a material in SAP?

SM12 is the Tcode used to handle lock object’s which are already opened by a User, but to unlock a material we can do it using MM06 or MM02 also . Lokeswar. Help to improve this answer by adding a comment.

Is there a way to block a material in SAP?

Yes, you can block a material to discontinue its procurement. So, go to MM02 for this material and select views . In Basic data 1-> X-plant matl status -> select blocked for procurement.Here you can block the material for all the plant.

Do you need to lock the material Master?

In certain circumstances there is a business need to lock few material master fields as lock relevant (The fields should be in a display mode under MM02 transaction) & users shouldn’t be able to change the material master.

Which is EAN field is lock relevant in SAP?

For example the field EAN under Basic Data1 is marked as lock relevant as follows Execute MM17 & lock the material as follows (Locking & unlocking the fields via MM17 is possible) Now the EAN field is in display mode under MM02 & the users will not be able to change the Fields in MM02