Types of SAP Tables – Important SAP Database Tables
The types of SAP Tables (database tables) are as follows.
- Cluster table
- Transparent table
- Pooled table
Cluster Table: – Cluster tables are logical tables that are to be assigned to a table cluster after they are maintained. Cluster tables helps to control the data, store as temporary data, texts, etc.
Cluster tables are used for many purposes. For e.g. The text may contains many characteristics to store, so you have to design how many characters to be record to store in the database. Then the database reads the data when reading the record.
The features of Cluster table
- This tables are not directly maintained by the database tools.
- The usage of cluster tables are easier as there are not created separately.
- Data base views, joint and appends statements are not used in the cluster tables.
Pooled Table: – It is a special table in SAP ABAP dictionary. The data from the tables are stored together in a table pool. Pooled tables are used to store the internal controlling information.
Transparent Table: – Transparent tables store the the data directly and its exists same structure in database and dictionary with same data & fields. We can read tables directly from database.
How to create SAP Database tables
Database tables in SAP can be created via SAP ABAP dictionary by using one of the following navigation method.
- Transaction code: – SE11
- Menu Path: – SAP Menu >> Tools >> ABAP Workbench >> Development >> SE11 >> ABAP Dictionary
From ABAP Dictionary screen, you can create this three types of SAP tables.
Also Read: An Overview of ABAP Internal Tables.