How to create a database table in SAP ABAP SE11?

SAP ABAP transparent table.

A table can be created in two ways, one is bottom to top approach and another one is top to bottom approach.

A) Top to Bottom:- In this approach, first table fields are defined and later domain and data element are defined.
B) Bottom to Top:- In this approach, the first domain and data element are defined and later table will be created.
In this example, we are going to learn how to create SAP transparent table by using Top to bottom approach.
Step 1: Go to SE11 T-code, provide table name( ZSTUDENT_TABLE) & Click on create button.
(NOTE:- Table name must start with 'Z' or 'Y' letter.)

When you click on 'Create' button it goes on next screen. Provide a short description, delivery class (A), Display Maintenance Allowed and select fields tab.

Select Fields tab, add a field STUDENT_NO, data element as ZSTUDENT_NO and check Key and Initial Value checkboxes

A table must contain at least one key field, without a key field we are not able to create a table.

Double click on data element ZSTUDENT_NO (Not yet created), a pop up will open, click yes and one more information message will come press enter.

Now a pop up will come asking to create date element, click yes.

Provide a short description, click on the field label an enter field label and save.

Enter domain name 'ZSTUDENT_NO' an double click on that & click on yes
Provide a short description, data type, no. Characters, save and activate that domain.

Similarly, Create remaining fields with data elements and domains as showing below.

Once all fields are created click on 'Technical Settings' button or provide se13 Tcode and maintain technical setting for the same table.

Provide data class and size category in the technical setting a click save button.

Maintain Enhancement category, Extras -> Enhancement category ->Can be enhanced(charater-type or numeric).

Click on Save, Check, and Active button.
Now add entries to table.
Utilities(M) -> Table Contents -> Create entries.

Now you will gate next screen for creating entries.

Enter the required data and click on save button.
Once you have done with creating entries go back an click on Utilities(M) -> Table Contents -> display. You will gate all the data you have already entered.

   Previous Topic                                                                          Next Topics..