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 the three ways for searching for Enhancements ?
What is the difference between internal tables and extract datasets? : abap modularization
List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr
can we insert a table in a table? structure in a structure, structure in a table and table in a structure?
SmartForm : how to print a smartform layout having one portrait and one landscape?
How to make changes in standard script for sales order header data?
Can any please explain me what r bundling technics in SAP?
What are the fields in a BDCTab Table.
What kind of financial periods exist in SAP? What is the relevant table for that?
Differentiate between transparent tables, cluster tables and pooled tables
what comes in Timkein written test I hope some body can tell me at this id plz tell it before 9 pm 19 march
Explain the difference between a dialog program and a report?