when to use cluster table

[Former Member]

when we will use the cluster table.. in which situation we will declare the table type as cluster table.

thanks and regards

suresh

Message was edited by: suresh m

[Former Member]

hi suresh,

Cluster table are logical tables that must be assigned to a table cluster when they are defined.

Cluster table can be used to store control data they can also used to store temporary data or text such as documentation.

below link can help u

http://www.planetsap.com/HR_ABAP_payroll.htm

http://cma.zdnet.com/book/abap/ch03/ch03.htm#TableClustersandClusterTables

regards,

venu.

Message was edited by: Venu Narayana

[Former Member]

Hi Suresh,

Please revisit your past threads and see the replies that you have got. The answers that were given along with the content in the links provided should help you decide when the table should be a cluster table.

Also, please do reward points to the answers that were given to your questions.

Regards,

Anand Mandalika.

[Former Member]

It's my understanding that cluster tables were developed by SAP to get around an early Oracle limit on the number of fields allowed on their tables. That limit is no more and there is no need to define a table as a cluster.

Rob

[Former Member]

Hi,

A cluster is advantageous in the case where data is accessed from multiple tables simultaneously and those tables have at least one of their primary key fields in common. Cluster tables reduce the number of database reads and thereby improve performance.

Several logical data records from different cluster tables can be stored together in one physical record in a table cluster

Check the below links for further info:

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

http://cma.zdnet.com/book/abap/ch03/ch03.htm#TableClustersandClusterTables

Regards,

Anjali

[former_member181959]

Hi suresh,

User is not going to deal with these cluster tables. For all cluster tables there is one cluster pool. Cluster tables are similar to pool tables. The difference between the cluster and pool table is that in cluster table , primary key is taken as reference. For all cluster tables there is unique identifier to cluster pool.

For more info

http://cma.zdnet.com/book/abap/ch03/ch03.htm#TableClustersandClusterTables

with regards…

prasad.