What are the types of database tables in SAP?

What are the different types of database tables in SAP? What are Transparent Tables, Pooled Tables and Cluster Tables in SAP?

+ -

There are three types of database tables available in SAP, explained below

Transparent table

There is a physical table on the database for each transparent table. The names of the physical tables and the logical table definition in the ABAP/4 Dictionary correspond.

All business data and application data are stored in transparent tables.

Pooled table

Pooled tables can be used to store control data (e.g. screen sequences, program parameters or temporary data). Several pooled tables can be combined to form a table pool. The table pool corresponds to a physical table on the database in which all the records of the allocated pooled tables are stored.

Cluster table

Cluster tables contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least parts of the keys must agree. Several cluster tables are stored in one corresponding table on the database.

Please Sign in to ask a question

Was this lesson helpful to you? Yes No 72 People out of 79 think this lesson helpful


Lesson Navigation

←Previous Chapter
Next Chapter →