2007 Apr 05 3:58 PM
Hello Experts,
Kindly let me know the difference between
POOL TABLES and CLUSTER TABLES in means of JOINS
And please let me know some differences between POOL TABLES and CLUSTER TABLES.
Thanks and Regards
Hello Experts,
Kindly let me know the difference between
POOL TABLES and CLUSTER TABLES in means of JOINS
And please let me know some differences between POOL TABLES and CLUSTER TABLES.
Thanks and Regards
2007 Apr 05 4:24 PM
hi,
Pool table
A database table defined in the ABAP Dictionary whose database instance is assigned to more than one table defined in the ABAP Dictionary. Multiple pool tables are assigned to a table pool in the database. The key fields of a pool table have to be character-type fields. The table pool's primary key consists of two fields: TABNAME for the name of a pool table, and VARKEY for the interdependent contents of the key fields in the corresponding pool table. The non-key fields of the pool table are stored in compressed format in their own column, called VARDATA, of the table pool. The only way to access pool tables is by using Open SQL. Joins are not allowed.
Table Pool
Database table in the database that contains the data of several pool tables.
Cluster Table
Database table defined in the ABAP Dictionary, whose version on the database is not only assigned to one table defined in the ABAP Dictionary. Several cluster tables are assigned to a table cluster in the database. The intersection of the key fields of the cluster tables forms the primary key of the table cluster. The other columns of the cluster tables are stored in compressed form in a single column VARDATA of the table cluster. You can access cluster tables only via Open SQL, and only without using joins.
Table Cluster
Database table in the database that contains the data of several cluster tables.
Note: Never mix up with a database table that has the necessary structure for storing data clusters in database tables and in the shared memory. Those are called INDX-type, with reference to the database table INDX supplied by SAP. Data clusters are groupings of data objects for transient and persistent storage in a selectable storage medium. A data cluster can be processed using the statements IMPORT, EXPORT, and DELETE FROM
This link also helps you...
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm
~~Guduri
2007 Apr 05 4:51 PM
Hi Santosh,
Check out these threads
EXAMPLES
http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm
Regards,
Santosh
2007 Apr 05 5:10 PM
Hi santosh,
I just want to ask you ..
What is the difference between these two tables in means of joins???
Regards
2007 Apr 09 9:15 AM
hi...
visit the link below it should help u out.
http://help.sap.com/saphelp_erp2005vp/helpdata/en/cf/21f0d1446011d189700000e8322d00/frameset.htm
<b>plz reward pts if helpful.</b>
regards
vijay
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |