Pooled Table

[Former Member]

What are the differences between Pooled & Cluster tables ?

[valter_oliveira]

Hello.

Check this link:

http://www.sap-img.com/abap/the-different-types-of-sap-tables.htm

Reward if usefull.

Best regards.

Valter Oliveira.

[Former Member]

Pooled table

Pooled tables can be used to store control data (e.g. screen sequences, program parameters or temporary data). Several pooled tables can be combined to form a table pool. The table pool corresponds to a physical table on the database in which all the records of the allocated pooled tables are stored.

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.

[Former Member]

Can i have atleast one example each for both Pooled & Cluster tables ?

Also i came to know that we cant access the pooled tables using the normal select. Then how can we retrieve the data ?

[Former Member]

well,,

pool table used to store system information... u cant access how ever u can convert transperent table into pool table...

[Former Member]

Hi,

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 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

See the help

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

Regards

Kiran Sure

[Former Member]

Pool table used to store system dependent data....... dats y union

cluster table used to store independent data dats y using interaction.