Ansicht
Dokumentation

ABENDDIC_DATABASE_TABLES_POOLCLU - DDIC DATABASE TABLES POOLCLU

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 also specified under the statements in question. Direct access to pooled tables and cluster tables using Native SQL is not possible.

• Pooled tables in table pools

• Cluster tables in table clusters

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.