‚Č° Menu

Types of SAP Tables- cluster table, transparent table, Pooled Tables

Types of SAP Tables – Important SAP Database Tables

The types of SAP Tables (database tables) are as follows.

  1. Cluster table
  2. Transparent table
  3. 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 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.

Types of SAP Tables- cluster table, transparent table, Pooled Tables

Transaction code: – SE11

Menu Path: – SAP Menu >> Tools >> ABAP Workbech >> Development >> SE11 >> ABAP Dictionary

From ABAP Dictionary screen, you can create this three types of SAP tables.