Clustered & Pooled tables

[Former Member]

Hi Friends,

I have a small doubt in Table Types POOLED & CLUSTERED.

In which situation we will go for creation of these tables?

What are the exmples for these tables( gimme 5 of each kind).

Thanks in advance.

Regards,

Ram

[Former Member]

Hi Friends,

I have a small doubt in Table Types POOLED & CLUSTERED.

In which situation we will go for creation of these tables?

What are the exmples for these tables( gimme 5 of each kind).

Thanks in advance.

Regards,

Ram

[amit_khare]

Hi,

Pooled tables can be used to store control data (e.g. screen sequences, program parameters or temporary data). Several pooled tables can be combined to form a table pool. The table pool corresponds to a physical table on the database in which all the records of the allocated pooled tables are stored.

A001

A004

A005

A006

A007

Cluster tables contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least parts of the keys must agree. Several cluster tables are stored in one corresponding table on the database.

AUAA

AUAB

AUAO

AUAS

AUAT

Check this link for information on cluster & Pool tables. I think this will give you exact idea about them.

<a href="http://help.sap.com/saphelp_erp2005vp/helpdata/en/cf/21f0d1446011d189700000e8322d00/frameset.htm">http://help.sap.com/saphelp_erp2005vp/helpdata/en/cf/21f0d1446011d189700000e8322d00/frameset.htm</a>

Regards,

Amit

Reward all helpful replies.