Create Data Model and Lock Object in SAP BTP, ABAP Environment

  @EndUserText.label : 'Room XXX'
  @AbapCatalog.enhancementCategory : #NOT_EXTENSIBLE
  @AbapCatalog.tableCategory : #TRANSPARENT
  @AbapCatalog.deliveryClass : #A
  @AbapCatalog.dataMaintenance : #LIMITED
  define table zroom_xxx {
  key client          : abap.clnt not null;
  key id              : abap.char(20) not null;
  @EndUserText.label : 'Seats'
  seats               : abap.dec(3,0);
  location            : z_loca_dtel_xxx;
  hasbeamer           : abap_boolean;
  hasvideo            : abap_boolean;
  userrating          : abap.char(2);
  lastchangeddatetime : tzntstmpl;
  lastchangedbyuser   : syuname;
  }
 ```

    Save and activate.


 ### Create data definition

   1. Right-click on **`Z_ROOM_XXX`**, select the menu path **New** > **Other ABAP Repository Object**

       ![Create table](https://raw.githubusercontent.com/sap-tutorials/abap-core-development/main/tutorials/abap-environment-lock-object/definition.png)

   2. Search for **Data Definition**, select it and click **Next>**.

       ![Create table](https://raw.githubusercontent.com/sap-tutorials/abap-core-development/main/tutorials/abap-environment-lock-object/definition2.png)

   3.  Create your data definition:
      - Name: **`Z_I_ROOM_XXX`**
      - Description: **`Room XXX`**

   Click **Next>**.

    ![Create table](https://raw.githubusercontent.com/sap-tutorials/abap-core-development/main/tutorials/abap-environment-lock-object/definition3.png)

   4. Click **Finish**.

       ![Create table](https://raw.githubusercontent.com/sap-tutorials/abap-core-development/main/tutorials/abap-environment-lock-object/definition4.png)

   5. Create your data definition with following coding:

    ```ABAP
    @AbapCatalog.sqlViewName: 'Z_M_ROOM_XXX'
    @AbapCatalog.compiler.compareFilter: true
    @AbapCatalog.preserveKey: true
    @AccessControl.authorizationCheck: #CHECK
    @EndUserText.label: 'Room XXX'
    @Search.searchable
    @UI.headerInfo: { typeName: 'Room', typeNamePlural: 'Rooms' , title : { value: 'ID' } }
    define root view Z_I_ROOM_XXX as select from zroom_xxx as room
    association [0..1] to I_BusinessUserBasic as _SAPSysAdminDataChangeUser on _SAPSysAdminDataChangeUser.UserID = room.lastchangedbyuser
    {
    @UI.facet: [ { type: #COLLECTION, position: 1, id: 'ROOM', label: 'Room'  }, { type: #IDENTIFICATION_REFERENCE, position: 1, parentId: 'ROOM', label: 'General Information'}]
    @EndUserText: { label: 'ID' }
    @Search: { defaultSearchElement: true }
    @UI: { lineItem: [{ position: 1 }], identification: [{ position: 1 }] }
    key room.id,
    @EndUserText: { label: 'Seats' }
    @UI: { lineItem: [{ position: 3 }], identification: [{ position: 2 }] }
    room.seats,
    @EndUserText: { label: 'Location' }
    @UI: { lineItem: [{ position: 4 }], identification: [{ position: 3 }] }
    room.location,
    @EndUserText: { label: 'Has Beamer' }
    @UI: { lineItem: [{ position: 5 }], identification: [{ position: 4 }] }
    room.hasbeamer,
    @EndUserText: { label: 'Has Video' }
    @UI: { lineItem: [{ position: 7 }], identification: [{ position: 5 }] }
    room.hasvideo,
    @EndUserText: { label: 'User Rating' }
    @UI: { lineItem: [{ position: 8 }], identification: [{ position: 6 }] }
    userrating,
    @EndUserText: { label: 'Last Changed On' }
    @UI: { identification: [{ position: 7 }] }
    room.lastchangeddatetime,
    @EndUserText: { label: 'Last Changed By' }
    @UI: { identification: [{ position: 8 }], textArrangement: #TEXT_ONLY }
    room.lastchangedbyuser,
    @UI.hidden: true
    _SAPSysAdminDataChangeUser  
    }
 ```

Save and activate.



### Create lock object

1. Right-click on **`Z_ROOM_XXX`**, select the menu path **New** > **Other ABAP Repository Object**

   ![Create lock object](https://raw.githubusercontent.com/sap-tutorials/abap-core-development/main/tutorials/abap-environment-lock-object/lock.png)

2. Search for **Lock Object**, select it and click **Next>**.

   ![Create lock object](https://raw.githubusercontent.com/sap-tutorials/abap-core-development/main/tutorials/abap-environment-lock-object/lock2.png)

3.  Create your database table:
  - Name: **`EZROOMXXX`**
  - Description: **`LOCK`**

Click **Next>**.

![Create lock object](https://raw.githubusercontent.com/sap-tutorials/abap-core-development/main/tutorials/abap-environment-lock-object/lock3.png)

4. Click **Finish**.

   ![Create lock object](https://raw.githubusercontent.com/sap-tutorials/abap-core-development/main/tutorials/abap-environment-lock-object/lock4.png)

5. Enhance your lock object with following information:
   - Lock Mode: Write Lock

   Save and activate.

   ![Create lock object](https://raw.githubusercontent.com/sap-tutorials/abap-core-development/main/tutorials/abap-environment-lock-object/lock5.png)



### Test yourself

</div><div class="step-validation-mount"
      data-step="5"></div>
 <div class="step-actions">
   <button class="fd-button fd-button--emphasized" data-action="mark-done" data-step="5">Done</button>
 </div>
</div>
</div>