cancel
Showing results for 
Search instead for 
Did you mean: 

Difference between tables

Former Member
0 Kudos

Hi,

Please tell me the difference between transparent table, cluster tables, pooled tables?

points will be assigned.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Sridevi,

Transparent Tables: Typical tables that are used in SAP to store data.

Tables can be defined independently of the database in the ABAP Dictionary. The fields of the table are defined with their (database-independent) data types and lengths.

When the table is activated, a physical table definition is created in the database for the table definition stored in the ABAP Dictionary. The table definition is translated from the ABAP Dictionary to a definition of the particular database.

Pooled and Cluster Tables :

Table pools (pools) and table clusters (clusters) are special table types in the ABAP Dictionary. The data from several different tables can be stored together in a table pool or table cluster. Tables assigned to a table pool or table cluster are referred to as pooled tables or cluster tables.

A table pool or table cluster should be used exclusively for storing internal control information (screen sequences, program parameters, temporary data, continuous texts such as documentation). Data of commercial relevance is usually stored in transparent tables.

Sarhan.

Answers (1)

Answers (1)

Former Member
0 Kudos