Handling Changes to Database Tables

Copy the template database table definition. If you finished the previous exercise, you can skip this task and continue editing your database table Z##EMPLOY.

1. Copy database table definition /LRN/EMPLOY to your own package (suggested name: Z##EMPLOY, where ## stands for your group number).

   1. In the Project Explorer view, right-click database table definition /LRN/EMPLOY to open the context menu.

   2. From the context menu, choose Duplicate ....

   3. Enter the name of your package in the Package field. In the Name field, enter the name Z##EMPLOY, where ## stands for your group number.

   4. Confirm the transport request and choose Finish.

2. Activate the copy.

   1. Press Ctrl + F3 to activate the database table definition.

In the field list of your database table, add a new field (suggested name: DEPARTMENT_ID) and type it with built in type CHAR and length 40. After activating the table with the new field, reduce the length of the field to 20 and adjust the table on the database.

1. Before theANNUAL_SALARY field, add a new field (suggested name: DEPARTMENT_ID) and type it with built in type CHAR and length 40.

   1. Adjust the code as follows:

      Code Snippet

      Copy code

      Copy code

      Switch to dark mode

      Switch to dark mode

      1234567
      
        birth_date      : z##birth_date;
        entry_date      : z##entry_date;
        @Semantics.amount.currencyCode : 'z##employ.currency_code'
        annual_salary   : z##annual_salary;
        currency_code : waers;
      

2. Activate the database table definition.

   1. Press Ctrl + F3 to activate the development object.

3. Display the Dictionary Log for the table.

   1. Right-click anywhere in the source code and choose Open With → Dictionary Log.

   2. Navigate to the Dictionary Log tab that appears below the editor.

   3. Hold down the Ctrl key and click on the row starting with See log.

   4. From the toolbar on the Dictionary Log tab, choose Show Search Toolbar.

   5. Enter the name of your database table in the Find: field and press Enter.

   6. The update strategy is mentioned after the row Adjust table in DB >>>.

4. Reduce the length of the new field from 40 to 20.

   1. Adjust the code as follows:

      Code Snippet

      Copy code

      Copy code

      Switch to dark mode

      Switch to dark mode

      1234567
      
        birth_date      : z##birth_date;
        entry_date      : z##entry_date;
        @Semantics.amount.currencyCode : 'z##employ.currency_code'
        annual_salary   : z##annual_salary;
        currency_code : waers;
      

5. Activate the database table definition.

   1. Press Ctrl + F3 to activate the development object.

6. Analyze the ABAP log.

   1. On the dialog window with the error message, choose Open ABAP Log to display the Dictionary Log.

   2. On the Dictionary Log tab, hold down the Ctrl key and click on the row starting with See log.

   3. From the toolbar on the Dictionary Log tab, choose Show Search Toolbar.

   4. Enter the name of your database table in the Find: field and press Enter.

   5. The update strategy is mentioned after the row Adjust table in DB >>>.

7. Use the quick fix to convert the content of your database table.

   1. Navigate to the source code of your database table definition.

   2. In the code row that starts with define table, place the cursor on the table name and press Ctrl + 1 to invoke the quick fix.

   3. From the list of available quick fixes, choose Adjust and activate database table, convert data.

Replace the hard-coded type with a new data element (suggested name: Z##_DEPARTMENT_ID, where ## is your group number) which uses a new domain ((suggested name: Z##_DEPARTMENT_ID). In the domain, use technical type CHAR with a length of 20. After activating the database table, change the length in the domain to 10. Then activate and adjust the database table.

1. In your database table definition, replace abap.char(20) with Z##_DEPARTMENT_ID and use a quick fix to create the new data element.

   1. Adjust the code as follows:

      Code Snippet

      Copy code

      Copy code

      Switch to dark mode

      Switch to dark mode

      12345678
      
        birth_date      : z##_birth_date;
        entry_date      : z##_entry_date;
        department_id   : z##_department_id;
        @Semantics.amount.currencyCode : 'z##employ_dep.currency_code'
        annual_salary   : z##_annual_salary;
        currency_code   : waers;
      

   2. Click on z##_department_id, and press Ctrl + 1 to open the quick fix menu.

   3. From the quick fix menu, double-click Create data element ....

   4. Confirm the package and the name, enter a description, for example, Department Identification, and choose Next.

   5. Assign the new object to a transport request and choose Finish.

   6. Under Type Name, enter Z##_DEPARTMENT_ID and enter the following field labels:

      Field	Value
      Short	Dep.
      Medium	Department
      Long	Department ID
      Heading	Department ID

2. Save the data element. Then use forward navigation to create the domain with technical type CHAR and a length of 20.

   1. Press Ctrl + S to save the data element.

   2. Choose the Type Name: label to start creating the domain.

   3. Confirm the package and the name, enter a description, for example, Department Identification, and choose Next.

   4. Assign the new object to a transport request and choose Finish.

   5. Enter CHAR as Data Type and 20 as Length.

3. Save the domain. Then activate the domain, the data element, and the database table definition.

   1. Press Ctrl + S to save the domain.

   2. Choose Activate inactive ABAP development objects. Alternatively, press Ctrl + Shift + F3.

   3. Choose Select All and then Activate.

4. In your domain for the department ID, reduce the technical length and the display length from 20 to 10.

   1. Navigate to your domain Z##_DEPARTMENT_ID.

   2. Change the value in the Length field from 20 to 10.

   3. Remove the value in the Output Length field (this will be filled automatically during activation).

5. Try to activate the domain and analyze the messages on the Problems view.

   1. Press Ctrl + F3 to activate the domain.

   2. Open the Problems view below the editor to display the error messages.

6. Use the quick fix for the error message Domain ... cannot be activated due to dependent tables.

   1. In the Problems view, place the cursor on the error message that starts with Domain ... and press Ctrl + 1 to invoke the quick fix.

   2. Choose Finish.

   3. From the Previous Result section on the lower right, choose Activation Log to analyze the activation log.

7. Use a quick fix to adjust and convert the dependent database table, that is, your database table Z##EMPLOY.

   1. Navigate to the source code of your database table definition.

   2. In the code row that starts with define table, place the cursor on the table name and press Ctrl + 1 to invoke the quick fix.

   3. From the list of available quick fixes, choose Adjust and activate database table, convert data.

8. Activate the domain for the department ID.

   1. Navigate to the definition of your domain for the department ID.

   2. Press Ctrl + F3 to activate the development object.