What is the Difference between Transparant Tables , Pooled
& cluster Tables?
Answer / 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 |
What are Call Transaction Modes?
1 . how do u design technical documentation in abap ? 2 . what u currently devloped in sap abap ?
How do you create a table?
how to use binary search in internal table?what is the use of indexes and secondary indexes?
explain the role of CTUPARAMS structure in call transaction
3 Answers Accenture, Atos Origin, IBM,
What are indexes?
How many default tab strips are there?
what is the work of buffer in sap ?
Why do we need enhancements?
What is the function of the transport system and workbench organiser? : abap data dictionary
What is the last entry in all bdc tables? : abap bdc
In select-options, how to get the default values as current month first date and last date by default? Eg: 1/10/2006 and 31/10/2006