Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Diff Bt Cluser and pool tables?

Former Member
0 Kudos

HI,

Wats the diff between the cluster and pool tables?

Regards,

KK

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Kishore,

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.

Table Pools

A table in the database in which all records from the pooled tables assigned to the table pool are stored corresponds to a table pool.

The definition of a pool consists essentially of two key fields (Tabname and Varkey) and a long argument field (Vardata).

Regards,

VKreddy

5 REPLIES 5

Former Member

former_member181962
Active Contributor
0 Kudos

former_member404244
Active Contributor
0 Kudos

Hi Kishore,

go through the follwing link.

Regards,

Nagaraj

Former Member
0 Kudos

Hi Kishore,

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.

Table Pools

A table in the database in which all records from the pooled tables assigned to the table pool are stored corresponds to a table pool.

The definition of a pool consists essentially of two key fields (Tabname and Varkey) and a long argument field (Vardata).

Regards,

VKreddy

rajeshkumar_kaveti
Participant
0 Kudos

Hi,

I am adding a point to above post.

The diff is : All the cluster tables in a table clustor will have one or more common fields. Whereas pooled tables in table pool need not to have common field.

Regards,

Rajesh