How to create a database table in SAP SE11?

How to create a Transparent Table in SAP data dictionary? What in Top to Bottom and Bottom to top approach to create database tables in SAP?

+ -

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

1. Top to Bottom: In this approach, first table fields are defined and later domain and data element are defined.

2. Bottom to Top: In this approach, first domain and data element are defined and later table will be created.

In this example we are going to learn creating an SAP transparent table using a top to bottom approach (I suggest a simplest way).

Go to SE11 T-code, provide table name to be created ZSTUDENT_TABLE and create.

Creating a table in SAP

Provide short description, delivery class (A), Display Maintenance Allowed and select fields tab.

Creating a table in SAP

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

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

Creating a table in SAP

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.

Creating a table in SAP

Provide short description, domain and label

Creating a table in SAP

Creating a table in SAP

Save, double click on domain name ZSTUDENT_NO, click on yes.

Provide short description, data type, no. Characters, save and activate.

Creating a table in SAP

Similarly create remaining fields with data elements and domains as below

Creating a table in SAP

Once all fields are created click on 'Technical Settings' button.

Creating a table in SAP

Provide data class and size category, save and activate.

Creating a table in SAP

You will get a warning message just click on No, table is created.

Now add entries to table.

Add entries to SAP custom table

Adding entries to SAP custom table

Learner Questions


No Questions by learners, be first one to ask ..!!

    Please Sign in to ask a question

    Was this lesson helpful to you? Yes No 85 People out of 86 think this lesson helpful


    Lesson Navigation

    ←Previous Chapter
    Next Chapter →