Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference between Transparant Tables , Pooled
& cluster Tables?
- 1 Answers
- 6109 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
Can we use on change of between select and endselect?
How will you insert record in a sorted table
What are the dynapro keywords?
Suppose there is check box along with the rows. The requirement is, select the require check boxes and press a used defined button to save all these checked row data to another table. How can you do it?
How many types of views are there? : abap data dictionary
What is the table buffer? Which type of tables used this buffer?
What are pooled tables?
how to create view in bdc..??
How to pass data from list to report?
what is leave to TRANSACTION?
How is conversion of data types done between abap/4 & external level? : abap data dictionary
In order to upload purchase order details, how you handle multiple values for a single field?
Can a constructor be declared private? If yes then in which scenario?
How many types of size categories and data classes are there? : abap data dictionary
Which bdc you prefer? : abap bdc
