Register Login

Create a Transparent Table in SE11

This tutorial explains step by step procedure to create a transparent table in your SAP system using t-code SE11.

What is a Transparent Table?

Transparent tables are one-to-one relation table that exists with the same data and fields structure in both ABAP dictionary and database. When one transparent table is created in the ABAP dictionary then exactly the same table structure will be created in the database. Transparent tables are used used to store transaction data. 

How to Create a Transparent Table in SE11?

Please follow the steps below to create a transparent table in SE11:

Enter t-code SE11 in the SAP command field and press Enter to execute it


On the next screen put a name for the new database table such as ZDEMO_TABLE and then click the Create button to proceed further

Database Table Name

Now enter the Short Description about the database table to describe the table.



It is mandatory to choose Delivery Class  therefore click on the Search button next delivery class field and choose one 

delevery class

Next, go to the Fields tab and select fields as per your requirement. Also, check Key and Initial checkboxes.


Click the Save button to save all the world done till now.


Next, you will be asked for a location to store an object. You can place it local repository by clicking on the Local Object button


You can choose to place it in a package, if you don't have any package you can create a new package.


Next, select your Transport request and press Enter to continue


A new table ZDEMO_TABLE is saved.

Table saved

Next, go to option More and click on the Technical Setting button:

technical settig

Next in the Technical Settings screen go to the Data Class option. Click on the Search button next to Data Class and choose the appropriate class.

data class

Next, enter Size Category as it is a mandatory field.

Size Catageory

Now click the Save button to save all the data


Now click the Back button or press F3 to go back to the previous screen.


Now from the top menu navigate to Extras > Enhancement Category.


On the popup window click on the Continue icon.

Continue icon

Now in the Maintenance Enhancement Category popup choose Cannot Be Enhanced or any Enhancement Category according to your requirement.

And then click the Copy button 

Enhancement Structure

Now you need to make the object active by clicking on the Activate button.


Once you activate the object you have successfully created a new transparent table in t-code SE11 and now you use your new table in any reports.