topic Re: when to use cluster table in Application Development and Automation Discussions

when to use cluster table

Former Member — Mon, 18 Jul 2005 13:01:44 GMT

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

Re: when to use cluster table

Former Member — Mon, 18 Jul 2005 13:10:11 GMT

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

Re: when to use cluster table

Former Member — Mon, 18 Jul 2005 13:10:59 GMT

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.

Re: when to use cluster table

Former Member — Mon, 18 Jul 2005 13:21:08 GMT

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

Re: when to use cluster table

Former Member — Tue, 19 Jul 2005 03:46:33 GMT

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

Re: when to use cluster table

former_member181959 — Wed, 20 Jul 2005 08:26:42 GMT

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.