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
What’s value table?
A field-groups statement or an insert statement reverses storage space and transfers values. State true or false. : abap modularization
What is tmg?
What is the difference between a pool table and a transparent table?
What are the field and chain statements?
What are local objects? : abap data dictionary
If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc
Performance tuning techniques
How many main windows will be there in a page window?
What are the merits of its?-
How many primary keys can be created for a table?
What are the different types of sapscript symbols?
What is synchronous update?
Is it possible to pass data to and from include programs explicitly?
Which transaction code is used executing a report (type 1 program)? : abap data dictionary