What is the difference between Transparent, pooled and cluster tables in SAP ?

What are the main differences between Transparent tables, Pooled Tables and Cluster tables in SAP data dictionary ?

+ -

The below are the major differences between transparent, pooled and cluster tables in SAP data dictionary .

Transaparent Tables Pool Tables Cluster Tables
Contain a single table. Used to store master data They are used to hold a large number of very small tables(stores system data). They are used to hold data from a few number of large tables.(stores system data).
It has a one-to-one relationship with a table in the database. It has a many-to-one relationship with a table in the database. It has a many-to-one relationship with table in the database.
For each transparent table there is one associated table in the database. It is stored with other pooled tables in a single table called table pool in the database. Many cluster tables are stored in a single table in the database called a table cluster .
The database table has the same name, same number of fields and the fields have the same names . The database table has different name, different number of fields and fields have different names. The database table has different name, different number of fields and fields have different names.
There is only a single table . Table pools contain more tables than table clusters . Contains less tables than table pools .
Secondary indexes can be created . Secondary indexes cannot be created . Secondary indexes cannot be created .

Learner Questions


No Questions by learners, be first one to ask ..!!

    Please Sign in to ask a question

    Was this lesson helpful to you? Yes No 58 People out of 64 think this lesson helpful


    Lesson Navigation

    ←Previous Chapter
    Next Chapter →