what is the difference between transparent, pooled and
cluster table

Answer Posted / hari

Table pools (pools) and table clusters (clusters) are
special table types in the ABAP Dictionary. The data from
several different tables can be stored together in a table
pool or table cluster. Tables assigned to a table pool or
table cluster are referred to as pooled tables or cluster
tables.


Table Pools
===========
A table pool or table cluster should be used exclusively for
storing internal control information (screen sequences,
program parameters, temporary data, continuous texts such as
documentation). Data of commercial relevance is usually
stored in transparent tables.

A table in the database in which all records from the pooled
tables assigned to the table pool are stored corresponds to
a table pool.

Table Clusters
==============

Several logical data records from different cluster tables
can be stored together in one physical record in a table
cluster.

A cluster key consists of a series of freely definable key
fields and a field (Pageno) for distinguishing continuation
records. A cluster also contains a long field (Vardata) that
contains the contents of the data fields of the cluster
tables for this key. If the data does not fit into the long
field, continuation records are created.

Is This Answer Correct ?    24 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the function of the transport system and workbench organizer?

816


Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?

1770


Explain what is sequence of event triggered in report?

716


What are the personnel administration related infotypes? : abap hr

751


What is the max. No. Of structures that can be included in a table or structure? : abap data dictionary

720






How do you control printer functions from sapscript?

906


What is the difference between collect and append statements?

736


How will you find manager of an employee

1010


Define alv programming in abap?

905


Can matchcode object contain ids with different update types? : abap data dictionary

770


Explain difference between primary key and unique key?

673


What does the insert statement in extract datasets do? : abap modularization

729


How to use messages in lists?

748


How to read files and process BDC's automatically ?

1800


1.why dont use top of page. wat is the use? 2. wat is sub screen? 3. why u select the session method in bdc ? how many records wil be updated on that time? 4.why dont use start form in script? 5.wat is difference b/w dilldown and interactive report? 6. wat is pf status interactine report?

2541