ABAP MEMORY ID, ABAP Shared Memory, Types of Tables in SAP

What the different Types of Tables in SAP ? (Transparent, Pool and Cluster)

What the different Types of tables in SAP ?. 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. Once you got an idea about SAP Database tables, we will move to types of SAP internal tables.

Types of Tables in SAP

SAP Transparent Tables

Contain a single table. Used to store master data
It has a one-to-one relationship with a table in the database
For each transparent table there is one associated table in the database
The database table has the same name, same number of fields and the fields have the same names
There is only a single table
Single table can have one or more primary key
Secondary indexes can be created
They can be accessed using open and native SQL

Check also   Top 18 SAP Common ABAP Dumps in ST22 & TroubleShooting

Use of Transparent Table in SAP

They are used to hold master data e.g. Table vendors or table of customers. Example of transaction data is orders placed by customers

Pooled Tables in SAP

They are used to hold a large number of very small tables(stores customizing data or system data)
It has a many-to-one relationship with a table in the database
It is stored with other pooled tables in a single table called table pool in the database
The database table has different name, different number of fields and fields have different names
Table pools contain more tables than table clusters
Primary key of each table does not begin with same fields or fields
Secondary indexes cannot be created
They can be accessed using open SQL only

Use of Pooled Tables in SAP

They reduce the amount of database resources needed when many small tables have to be opened at the same time

Check also   The main important SAP FSCM Credit Management Tables

Types of Tables in SAP: Cluster

They are used to hold data from a few number of large tables.(stores system data)
It has a many-to-one relationship with table in the database
Many cluster tables are stored in a single table in the database called a table cluster
The database table has different name, different number of fields and fields have different names
Contains less tables than table pools
Primary key of each table begins with same fields or fields
Secondary indexes cannot be created
They can be accessed using open  SQL only

Use of Cluster Tables in SAP

They would be used when the tables have primary key in common and data in these tables are all accesses simultaneously

Types of SAP internal Tables

There is 5 types of SAP internal Tables:

  • Standard Table,
  • Sorted Table,
  • Index Table,
  • Hashed Table,
  • Any Table ( Generic type , used for generic ABAP Programming )
Check also   SAP PM Notifications get long Texts - Optimized

Source: Comparison of Transparent, Pool and Cluster tables

Leave a Reply

Your email address will not be published. Required fields are marked *