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
How we can retrieve data using secondary index. Explain with simple example?
What is maintenance view?
What is “call mode”?
What is collective search help? : sap abap data dictionary
What is retro active accounting
What is macro? : abap hr
Write the bdc table structure? : abap bdc
Explain Singleton class
What are the function modules used to create batch input session? : abap bdc
What are the contents in technical specifications?
What are the difference between call screen and leave screen?
Explain the inside concept in select-options?
What are two methods of modifying sap standard tables? : abap data dictionary
How can we set the tablespaces and extent sizes ?
Can we specify the next screen number with a variable?