What is SE11 table in SAP?

SAP database tables are created within the data dictionary using transaction SE11 (can also be accessed via SE80) and are used to store data within your SAP system. This includes Master data, transaction data, configuration data etc.

How do I create a table view in SE11?

How to create Table View in transaction SE11?

1. To create table view go to transaction SE11 (ABAP Dictonary).
2. Choose View name i.e. “ZMM_TV_MARA“.
3. Click on Create button:
4. Choose View Type.
5. Click on Continue button:
6. Fill Short Description field with i.e. “MARA + MAKT“:
7. Put tables you want to use in this view.

How do I view table transactions in SAP?

Go To SE16–>TVDIR

1. Now we enter Table name ZAP_PARENT_ORGUN as mentioned below.
2. If you have an entry that means a Table Maintenance generator is created like below.
3. Now we will check whether a Transaction Code is created for this Table Maintenance Generator.
4. Now enter * ZAP_PARENT_ORGUN * as mentioned below and Execute.

How many types of database tables can be created in SE11?

Actually in SAP Database Tables there are 3 main types of SAP Tables: Transparent Tables, Pool and Cluster. Let’s explain each SAP Table Type.

How do I make a DDIC table?

The database table in data dictionary can be created by two methods, i.e. Step 1: Execute SAP Tcode “SE11” in the SAP command field. Enter the required name of database table in the field. The name of table should be start with only Y or Z as we discussed earlier.

What is the difference between pooled table and cluster table?

Pooled tables are logical tables that must be assigned to a table pool when they are defined. Cluster table are logical tables that must be assigned to a table cluster when they are defined. Cluster table can be used to store control data they can also used to store temporary data or text such as documentation.

What are DDIC objects in SAP?

DDIC objects are data dictionary objects, anything that you can create via SE11, including Tables, Data Elements, Domains, Search Helps, Lock Objects, Views, structures, table types, etc. The ABAP Dictionary centrally describes and manages all the data definitions used in the system.

What is SE16 used for?

Code SE16: SE16 allows you to view data stored in different fields in tables. SE16 is a data browser, and it is used to view the contents of the table, and we cannot change or append new fields to the existing structure of the table as we cannot see the structure level display using the SE16.