topic Re: Pooled Table in Application Development and Automation Discussions

Pooled Table

Former Member — Fri, 23 May 2008 23:30:24 GMT

What are the differences between Pooled & Cluster tables ?

Re: Pooled Table

valter_oliveira — Fri, 23 May 2008 23:34:20 GMT

Hello.

Check this link:

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

Reward if usefull.

Best regards.

Valter Oliveira.

Re: Pooled Table

Former Member — Sat, 24 May 2008 02:57:54 GMT

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.

Re: Pooled Table

Former Member — Sat, 24 May 2008 03:03:33 GMT

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

Re: Pooled Table

Former Member — Mon, 26 May 2008 03:53:59 GMT

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 ?

Re: Pooled Table

Former Member — Mon, 26 May 2008 09:13:17 GMT

well,,

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

Re: Pooled Table

Former Member — Mon, 26 May 2008 09:34:44 GMT

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

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