Register Login

Difference between Pooled and Cluster Tables

Updated May 18, 2018

Pooled Tables vs Cluster Tables

Cluster tables and Pooled tables have Many to One relationship with a Table in the database i.e many tables of cluster/pooled tables has one database table. Pool and Cluster table is basically use to store Application Data.

The main difference between Pooled Table and Cluster Table.

  • A Table Pool corresponds to a table in the database in which all records from the pooled tables assigned to it are stored. In other words a number of pool table are stored in single table called Table Pool. Several logical data records from different Cluster Tables can be stored together in one physical record in a table cluster. In other wordss many Cluster Table are stored in one single table called Table Cluster.
  • A pooled table cannot have the name having more than 10 characters.
  • All the key fields of the pooled table must be of character data type (for example, CHAR, NUMC, CLNT). A Cluster contains a long field (Vardata) that
    contains the contents of the data fields of the cluster tables for this key. If the data does not fit into the long field, continuation records are created.
  • Table Cluster has primary key but Table pool doesn't.
  • In pooled tables, the maximum length of the key field/data fields should not exceed the length of varkey/vardata of the pool respectively.
  • In cluster table the records having the same key are stored in a single key in the cluster. If there is an overflow of the data records a continuation record is created with the same table key.
  • Table Pool contain large number of table having small data on the other hand Table Cluster holds few numbers of table having large data. For e.g 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.

 


Comments

  • 27 Jul 2017 7:02 pm Sonia Barwar Helpful Answer

    A pooled table is used to combine several logical tables in the ABAP/4 dictionary. 

    Pooled tables are logical tables that must be assigned to a table pool when they are defined.

    Cluster table are logical tables that must be assigned to a table cluster when they are defined.

    Cluster table can be used to store control data they can also used to store temporary data or text such as documentation.

  • 28 Jul 2017 5:25 pm Romil Tripathi Helpful Answer

    Pool Table (match codes, look up tables)

    1. Pool table is a logical table that must be assigned to a table pool when they are defined. The pool table is used to store control data. Several pooled tables can be combined in a table pool. The data of these pooled tables are then sorted in a common table in the database.
    2. Table pool can contain 10 to 1000 small pool table which has 10 to 100 records.
    3. A pooled table in R/3 has a many-to-one relationship with a table in the database. 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.
    4.  Should be buffered (SE11->Display Table->technical settings)

    Cluster Table (BSEG,KONV, BSEC) 

    1. Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to store control data. They can also be used to store temporary data or texts, such as documentation.
    2. Cluster table can contain very big but few (1 to 10)  cluster table.
    3. 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.
    4. Can not be buffered

    A clustered and a pooled table cannot be read from outside SAP because certain data are clustered and pooled in one field. 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 used to store application data.


×