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 |
Can a posting run be deleted? : sap abap hr
Differentiate between abap memory and sap memory?
When will the current screen processing terminates?
What is a BAdi? How to implement a BAdi?
Q2.What is the special character is used to mask a single characher. 1. & 2. % 3.’_____ 4._____’
What is up-casting and down casting? with example
How to print continuous pages in smartform?my requirement is i need to print 3 pages for each customer i.e 2 pages for purchase order forms and 3rd page is terms and condition page.Likewise how can i print 100 customer pages at once continuously?
What is sap abap data classes?
What are the events in ABAP/4 language?
What is the purpose of creating symbolic a/c, what is transaction code for same? Can we assign one symbolic a/c to multiple wage types? : sap abap hr
Explain SD and MM Flow?
12 Answers Keane India Ltd, Mascon, Tech Mahindra,
Describe the difference between macro and subroutine?