topic Re: Cluster Table in Application Development and Automation Discussions

Cluster Table

Former Member — Thu, 26 Apr 2007 10:39:24 GMT

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

Re: Cluster Table

amit_khare — Thu, 26 Apr 2007 10:43:06 GMT

Check the link -

Regards,

Amit

reward all helpful replies.

Re: Cluster Table

Former Member — Thu, 26 Apr 2007 10:43:56 GMT

Hi Suma,

Cluster Table : 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.

For more refer to this link.

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

Reward points if it solves ur query or answer is helpful

Thanks

Chinmay

Re: Cluster Table

Former Member — Thu, 26 Apr 2007 10:44:43 GMT

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