topic Re: Difference bet cluster table and pooled table in Application Development and Automation Discussions

Difference bet cluster table and pooled table

laxman_sankhla3 — Mon, 28 May 2007 14:34:43 GMT

which table are cluster table and which table are pooled table.

what is the difference between them.

thanks .

Re: Difference bet cluster table and pooled table

Former Member — Mon, 28 May 2007 14:36:21 GMT

clustered tables:

A cluster table is similar to a pooled table. It has a many-to-one relationship with a table in the database. Many cluster tables are stored in a single table in the database called a table cluster.

pooled tables:

A pooled table in R/3 has a many-to-one relationship with a table in the database (see Figures 3.1 and 3.2). For one table in the database, there are many tables in the R/3 Data Dictionary. The table in the database has a different name than the tables in the DDIC, it has a different number of fields, and the fields have different names as well. Pooled tables are an SAP proprietary construct.

Cluster table

Cluster tables contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least parts of the keys must agree. Several cluster tables are stored in one corresponding table on the database.

Tables assigned to a table pool or table cluster are referred to as pooled tables or cluster tables.

Pooled tables

Pooled tables are logical tables that must be assigned to a table pool when they are defined. Pooled tables are used to store control data. Several pooled tables can be cominied in a table pool. The data of these pooled tables are then sorted in a common table in the database.

Hope this will solve ur problem..

<b><u>Dont forget to reward all the useful replies</u></b>

Sudheer

Re: Difference bet cluster table and pooled table

amit_khare — Mon, 28 May 2007 14:37:18 GMT

Check the link -

Regards,

Amit

Reward all helpful replies.

Re: Difference bet cluster table and pooled table

Former Member — Mon, 28 May 2007 14:38:30 GMT

Hi,

Refer these thread to answer your question

Re: Difference bet cluster table and pooled table

Former Member — Mon, 28 May 2007 14:39:36 GMT

Hi,

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

One of the possible reasons is for instance that their content can be variable in length and build up. Database manipulations in Abap are limited as well.

But pool and cluster table is a many to one relationship table. This means many pool table store in a database table which is know as table pool.

All the pool table stored table in table pool does not need to have any foreign key relationship but in the case of cluster table it is must. And pool and cluster table is basically use to store application data.

Table pool can contain 10 to 1000 small pool table which has 10 to 100 records. But cluster table can contain very big but few (1 to 10) cluster table.

For pool and cluster table you can create secondary index and you can use select distinct, group for pool and cluster table. You can use native SQL statement for pool and cluster table.

Regards,

Ferry Lianto

Re: Difference bet cluster table and pooled table

Former Member — Mon, 28 May 2007 14:40:08 GMT

Chk the below link

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