What is the Difference between Transparant Tables , Pooled
& cluster Tables?
- 1 Answers
- 5602 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
How to split one Invoice into Multiple ( Step by Step)?
Explain the difference between a pool table and a transparent table and how they are stored at the database level?
What are the dynamic actions and how to configure it? : sap abap hr
PLEASE HELP ANYONE ON THIS ISSUE,is there any problem with this function module :RHPQ_T77BX_ADD_QUALIS_OF_DPLAN. IT IS TRIGGERING BEFORE COMPLETION OF THE DEVELOPMENT PLAN but it has to trigger after compltion of development plan..this issue raised in my project..so reply urgently..thanks in advance..
What are the client dependant objects in abap / sap?
****THANK YOU ALL ABAP EXPERTS**** I got a JOB as ABAP Consultant in Infosys.I cleared the interview.The question posted here are really good.I cleared interview based on this material only.It really works.I thank all members who posted que&ans here. Those who are in search of job in MNC study this question set only you will get sucess. Thanks once again allinterview.com and members of this community. tulika20021@rediffmail.com
What is the relationship existing between the various data elements? : abap data dictionary
dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?
How many types of data classes are there in sap abap? : abap data dictionary
Different types of locks?
Does sap handle multiple currencies?
What does the extract statement do in extract datasets?
Polymorphism real time scenario
What is an Open Item in SAP? How will you find an Open Item in SAP?
What is pretty printer?
