What is the Difference between Transparant Tables , Pooled
& cluster Tables?

Answer Posted / uma mb

These are three different kinds of table types in SAP.

The first most common type known to all is the 'Transparent
Table' which is a logical definition (in teh ABAP data
dictionary) of a physical table in the database.

Several tables logically defined in ABAP data dictionary can
be combined in a physical table (pool or cluster).

When functionally dependent data spread in many different
tables are kept in one database table, it comes to be known
as a cluster table. The key fields of these cluster tables
form the cluster key.

Pool table is just the opposite where tables are kept
together but they are not functionally dependent - rather
say all small master tables kept together as a pool would
form a pool table.

The true benefits of a cluster / pool table is data is
stored ina compressed form, so less memory space and less
network load.

There are some minus points also:

No native SQL can be used, no views, no joins, no scondary
indices, no GROUP BY, ORDER BY can be used. Table appends
not possible.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

​​What is the symbol to do “concatenation” operation in​​ nw​​ abap​​ 7.4​​ ?

993


What is an update task? : abap modularization

745


How do you read files from the presentation server ? : abap bdc

748


​​What is view proxy in abap?

940


Difference between sap script and report?

900






On which event we can validate the input fields in module programs?

763


How to display or know if the value entered contains records or not?

726


What are the steps to be followed to set lockobjects? : sap abap data dictionary

794


What are the names of the function modules that will be generated upon activation of a lock object?

692


How do you send files to the legacy systems from sap and vice versa? How does one know that the legacy files have come on to the sap server you are working on? : abap bdc

709


Did you use buffering?

735


Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?

2166


Where do you find info on new developments in SAP?

1702


What is generic area buffering in abap?

710


What are different ABAP editors? What are the differences?

739