ABAP Tip - SE14:Database Utility

SE14:Database Utility

We can use T-CODE:SE14(Database Utility) for the purpose of adjusting the table and index at a database level.

There are two main functions of SE14.

1.  Table activation and adjustment.

 We often face table problems when activating table SE11 after changing the KEY columns and below poup screen will show up.

In this case, we can activate the table via T-CODE:SE14.

Execute T-CODE:SE14 and input table name, press the EDIT button. Or, you can use the below menu in T-CODE:SE11.

테이블의 데이터 보존이 필요하면, Save Data를 선택하고 Activate and adjust database 버튼을 누르면 테이블이 활성화된다. 

2.  Index creation and adjustment.

When you maintain(create, change) large index, there is some problem at a database level.

You should adjust the index via SE14.

Select the specific index and go to next screen

When index does not exist in database, button of ‘Create database index’ is activated. If you click this button, same index with ABAP dicitionay will be created. In case of large index, it takes lots of time to create index and lock the table until the task is complted. You should avoid the working time.

In addition, you can see the all index which is inconsistent between ABAP dictionary and DATABASE.

Only when index does not exist in database level, you can create index via SE14.

Or, you can create index by database script after logging into database server directly.