Let's Talk
Previous Next
6 Columns with Active Background
DDIC  Reports   Interface   Conversion   Enhancement   Forms
6 Columns with Active Background
Data Dictionary Reports Interface Conversion Enhancement Forms
Active List Item Background

24DDIC3007 – Lock Objects Types and Creation Steps

Understanding Lock Objects

Lock objects in SAP are used to manage the locking mechanism for database records. They ensure that only one user can modify a particular record at a time, preventing data inconsistencies and conflicts. There are primarily two types of lock modules:

Enqueue Lock Objects

Dequeue Lock Objects

  1. Enqueue Lock Objects

Enqueue lock objects are used to lock database records for writing operations. They prevent other users from modifying the same records simultaneously. Enqueue locks are typically created when a user starts editing a record and are released when the editing session ends.

  1. Dequeue Lock Objects

Dequeue lock objects are used to release locks that were previously set by enqueue lock objects. They are essential for ensuring that locks are correctly managed and released, allowing other users to access and modify records once the original user’s session is completed.

Steps to Create Lock Objects

Creating lock objects involves defining lock modules and configuring their parameters. Below are the steps to create both enqueue and dequeue lock objects in ABAP.

Step 1: Define a Lock Object

  1. Access the ABAP Dictionary

Open the ABAP Dictionary by entering transaction code `SE11` in the SAP GUI.

  1. Create a New Lock Object

– Select “Lock Object” from the object type menu.

– Enter a name for the lock object (e.g., ‘ZMY_LOCK_OBJECT’).

– Click “Create.”

 

  1. Define the Lock Object Properties

– Enter a short description for the lock object.

– Choose “Enqueue” as the type of lock object.

  1. Specify the Lock Parameters

– Define the tables and fields that will be used for locking.

 – Specify the lock modes (e.g., shared or exclusive locks).

 

  1. Save and Activate

 – Save your entries and activate the lock object.

Step 2: Create Lock Modules

Lock modules are the programs that use the lock objects to manage locking and unlocking of records. These modules need to be created for both enqueue and dequeue operations.

 

Example: Creating an Enqueue Lock Module

  1. Access Transaction SE37

   Open transaction ‘SE37’ to create a new function module.

  1. Create a New Function Module

– Enter a name for the function module (e.g., ‘Z_ENQUEUE_MY_LOCK’).

– Click “Create.”

  1. Define the Function Module Properties

– Enter a short description for the function module.

– Specify the import and export parameters as needed.

 

  1. Add the Lock Code

– Use the ‘ENQUEUE_’ function module to set locks on the desired records.

 

Example code snippet:

     CALL FUNCTION ‘ENQUEUE_EZMY_LOCK_OBJECT’

       EXPORTING

         field1 = <value>

         field2 = <value>

       EXCEPTIONS

         FOREIGN_LOCK = 1

         SYSTEM_FAILURE = 2

         OTHERS = 3.

  1. Save and Activate

 – Save your entries and activate the function module.

 

Example: Creating a Dequeue Lock Module

 

  1. Access Transaction SE37

   Open transaction ‘SE37’ to create a new function module for dequeue operations.

  1. Create a New Function Module

– Enter a name for the function module (e.g., ‘Z_DEQUEUE_MY_LOCK’).

– Click “Create.”

  1. Define the Function Module Properties

 – Enter a short description for the function module.

 – Specify the import and export parameters as needed.

  1. Add the Unlock Code

– Use the ‘DEQUEUE_’ function module to release locks on the desired records.

 Example code snippet:

 CALL FUNCTION ‘DEQUEUE_EZMY_LOCK_OBJECT‘

       EXPORTING

         field1 = <value>

         field2 = <value>

       EXCEPTIONS

         FOREIGN_LOCK = 1

         SYSTEM_FAILURE = 2

         OTHERS = 3.

  1. Save and Activate

 – Save your entries and activate the function module.

Example Scenario: Implementing Lock Objects

Consider an example where you need to manage access to customer records. You would define a lock object to handle customer record locks and create enqueue and dequeue function modules to manage these locks.

 

  1. Define Lock Object

Create a lock object ‘ZCUSTOMER_LOCK’ specifying the `CUSTOMER` table and relevant fields.

  1. Create Enqueue Module

Create the function module ‘Z_ENQUEUE_CUSTOMER’ using the ‘ENQUEUE_EZCUSTOMER_LOCK’ function.

  1. Create Dequeue Module

Create the function module ‘Z_DEQUEUE_CUSTOMER’ using the ‘DEQUEUE_EZCUSTOMER_LOCK’ function.

Author : Aniket Pawar, 9373518385                                                     

24DDIC3007 – Lock Objects Types and Creation Steps

Understanding Lock Objects

Lock objects in SAP are used to manage the locking mechanism for database records. They ensure that only one user can modify a particular record at a time, preventing data inconsistencies and conflicts. There are primarily two types of lock modules:

Enqueue Lock Objects

Dequeue Lock Objects

  1. Enqueue Lock Objects

Enqueue lock objects are used to lock database records for writing operations. They prevent other users from modifying the same records simultaneously. Enqueue locks are typically created when a user starts editing a record and are released when the editing session ends.

  1. Dequeue Lock Objects

Dequeue lock objects are used to release locks that were previously set by enqueue lock objects. They are essential for ensuring that locks are correctly managed and released, allowing other users to access and modify records once the original user’s session is completed.

Steps to Create Lock Objects

Creating lock objects involves defining lock modules and configuring their parameters. Below are the steps to create both enqueue and dequeue lock objects in ABAP.

Step 1: Define a Lock Object

  1. Access the ABAP Dictionary

Open the ABAP Dictionary by entering transaction code `SE11` in the SAP GUI.

  1. Create a New Lock Object

– Select “Lock Object” from the object type menu.

– Enter a name for the lock object (e.g., ‘ZMY_LOCK_OBJECT’).

– Click “Create.”

 

  1. Define the Lock Object Properties

– Enter a short description for the lock object.

– Choose “Enqueue” as the type of lock object.

  1. Specify the Lock Parameters

– Define the tables and fields that will be used for locking.

 – Specify the lock modes (e.g., shared or exclusive locks).

 

  1. Save and Activate

 – Save your entries and activate the lock object.

Step 2: Create Lock Modules

Lock modules are the programs that use the lock objects to manage locking and unlocking of records. These modules need to be created for both enqueue and dequeue operations.

 

Example: Creating an Enqueue Lock Module

  1. Access Transaction SE37

   Open transaction ‘SE37’ to create a new function module.

  1. Create a New Function Module

– Enter a name for the function module (e.g., ‘Z_ENQUEUE_MY_LOCK’).

– Click “Create.”

  1. Define the Function Module Properties

– Enter a short description for the function module.

– Specify the import and export parameters as needed.

 

  1. Add the Lock Code

– Use the ‘ENQUEUE_’ function module to set locks on the desired records.

 

Example code snippet:

     CALL FUNCTION ‘ENQUEUE_EZMY_LOCK_OBJECT’

       EXPORTING

         field1 = <value>

         field2 = <value>

       EXCEPTIONS

         FOREIGN_LOCK = 1

         SYSTEM_FAILURE = 2

         OTHERS = 3.

  1. Save and Activate

 – Save your entries and activate the function module.

 

Example: Creating a Dequeue Lock Module

 

  1. Access Transaction SE37

   Open transaction ‘SE37’ to create a new function module for dequeue operations.

  1. Create a New Function Module

– Enter a name for the function module (e.g., ‘Z_DEQUEUE_MY_LOCK’).

– Click “Create.”

  1. Define the Function Module Properties

 – Enter a short description for the function module.

 – Specify the import and export parameters as needed.

  1. Add the Unlock Code

– Use the ‘DEQUEUE_’ function module to release locks on the desired records.

 Example code snippet:

 CALL FUNCTION ‘DEQUEUE_EZMY_LOCK_OBJECT‘

       EXPORTING

         field1 = <value>

         field2 = <value>

       EXCEPTIONS

         FOREIGN_LOCK = 1

         SYSTEM_FAILURE = 2

         OTHERS = 3.

  1. Save and Activate

 – Save your entries and activate the function module.

Example Scenario: Implementing Lock Objects

Consider an example where you need to manage access to customer records. You would define a lock object to handle customer record locks and create enqueue and dequeue function modules to manage these locks.

 

  1. Define Lock Object

Create a lock object ‘ZCUSTOMER_LOCK’ specifying the `CUSTOMER` table and relevant fields.

  1. Create Enqueue Module

Create the function module ‘Z_ENQUEUE_CUSTOMER’ using the ‘ENQUEUE_EZCUSTOMER_LOCK’ function.

  1. Create Dequeue Module

Create the function module ‘Z_DEQUEUE_CUSTOMER’ using the ‘DEQUEUE_EZCUSTOMER_LOCK’ function.

Author : Aniket Pawar, 9373518385                                                     

Unlock the full potential of SAP technology and propel your career forward with our industry-leading SAP training courses.

Facebook Instagram Whatsapp Linkedin Youtube

Program Options

Get In Touch

Contact us

Let's Talk

Copyright © 2023 VEDANKA , All rights reserved.