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

SE11

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.

Description

 

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.

Field

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

save

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

Location

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

Package

Next, select your Transport request and press Enter to continue

TR

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

Save

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

Back

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

Enhance

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.

Activate

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.