05-24-2008 12:30 AM
05-24-2008 3:57 AM
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.
05-24-2008 12:34 AM
Hello.
Check this link:
http://www.sap-img.com/abap/the-different-types-of-sap-tables.htm
Reward if usefull.
Best regards.
Valter Oliveira.
05-24-2008 3:57 AM
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.
05-26-2008 4:53 AM
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 ?
05-26-2008 10:13 AM
well,,
pool table used to store system information... u cant access how ever u can convert transperent table into pool table...
05-24-2008 4:03 AM
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
05-26-2008 10:34 AM
Pool table used to store system dependent data....... dats y union
cluster table used to store independent data dats y using interaction.