Skip to content

ABAP Keyword Documentation →  ABAP Dictionary →  Classic Objects in ABAP Dictionary →  Database Tables 

Pooled Tables and Cluster Tables

Alongside transparent tables, pooled tables and cluster tables are an SAP-specific category of database tables that can be defined in ABAP Dictionary. Unlike transparent tables, pooled tables and cluster tables do not exist with this definition on the database and instead contain the content of a table pool or table cluster. Only the table pool or table cluster is defined as a special table on the database. It is still possible, however, to access pooled or cluster tables using Open SQL, just like a transparent table. The database interface transforms accesses to the relevant accesses to the table pool or table cluster. Some restrictions apply, however, which are specified under the statements in question. Direct access to pooled tables and cluster tables using Native SQL is not possible.

Other versions: 7.31 | 7.40 | 7.54


Note

It is not usually recommended that new tables are created as pooled table or cluster tables. It was also never recommended that business data be saved in pooled tables or clustered tables. Pooled tables and cluster tables were only ever designed for internal control information, temporary data, or continuous texts such as documentation. It is generally recommended that any existing pooled tables and cluster tables are transformed to transparent tables.

Continue

Pooled Tables in Table Pools

Cluster Tables in Table Clusters

Transforming Pooled Tables and Cluster Tables