Diff Bt Cluser and pool tables?

[Former Member]

HI,

Wats the diff between the cluster and pool tables?

Regards,

KK

[Former Member]

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

[Former Member]

Hi Kishore

Welcome to the SDN Forum

Check these <b>links</b> it iwll be very helpful

http://help.sap.com/saphelp_47x200/helpdata/en/81/415d363640933fe10000009b38f839/frameset.htm

http://www.sap-img.com/abap/the-different-types-of-sap-tables.htm

http://www.datamanagementgroup.com/Resources/Articles/Article_0106_2.asp

Reward with points if it is helpful

Regards

Alfred

[Former Member]

Refer these links:

I think both mean the same:

http://help.sap.com/saphelp_47x200/helpdata/en/81/415d363640933fe10000009b38f839/frameset.htm

Regards,

ravi

[former_member404244]

Hi Kishore,

go through the follwing link.

Regards,

Nagaraj

[Former Member]

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]

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