07-18-2005 2:01 PM
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
07-18-2005 2:10 PM
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
07-18-2005 2:10 PM
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.
07-18-2005 2:21 PM
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
07-19-2005 4:46 AM
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
07-20-2005 9:26 AM
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.