What is the Difference between Transparant Tables , Pooled
& cluster Tables?
- 1 Answers
- 5424 Views
- Patni, Satyam, Siemens, I also Faced
- E-Mail Answers
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
It is possible to assign a local data object defined in a subroutine or function module to a field group. State true or false. : abap modularization
Which type of tables used this buffer?
What are the control break events in abap? : abap data dictionary
What is an abap dictionary? : abap data dictionary
Search help exit details.
Can you assign a matchcode object to a parameter? If so how?
how can we use the text randomly or circularly in smartforms.... means... suppose i have 'abap' horizantally... but i want it in vertically... how can... plz any body tell me this....
What is page window?
Differentiate between report and dialog program
Explain the relationship between a functional area, user group, and query when developing queries using the sap query tool?
Difference between /N and /BEND?
What does a lock object involve?
What is the different type of projects? : sap abap hr
In what ways we can get the context sensitive f1 help on a field?
What are the data types of internal tables?
