Cluster Table

[Former Member]

why do we need cluster table??how efficient is it in application if created??

[amit_khare]

Check the link -

Regards,

Amit

reward all helpful replies.

[Former Member]

Hi Suma,

<b>Cluster Table</b> : Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to strore control data. They can also be used to store temporary data or texts, such as documentation

A clustered and a pooled table cannot be read from outside SAP because certain data are clustered and pooled in one field.

<b>For more refer to this link.</b>

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm

<b>Reward points if it solves ur query or answer is helpful</b>

Thanks

Chinmay

[Former Member]

Hi,

Table Clusters generally contain the data from a samll number of very large tables.

i.e. say there are 4 cluster tables each having 1,00,000 records.

In that case we can create a table cluster which will be having all the records from all the 4 tables.

Here the mandat is that all the cluster tables must have at least one key in common.

Actually, this all is done for database management.

Generally cluster tables contain the sustem information.

e.g. Change history tables CDHDR and CDPOS are cluster tables.

Moreover, u also cannot put a join on cluster tables.

Regards

Himanshu