Answer / 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.

Answer / devi

transparent table: Having one to one relationship with table
definition in the database. we can use it in the inner join
and in index.
pooled tables: having many to one relationship with the
database. we cant use it in inner join and index.
clustered table:having many to one relationship with database.
stores a single table in the sap db, having a common primary
key.

Answer / vijju

Transparent table has master and transitional data.
we create the transparent tables maximum in ddic. it has one to one relationship between ddic and database.

cluster and pooled tables has control data. it has internal details of system means descriptions, program parameters, screen sequences etc..
it is many to one relationship. ie many tables of cluster/pooled tables has one database table.
cluster has primary key but pooled doesn't.

Answer / eswar

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.

Answer / abhinesh mishra

plz refer abap in 21 days for these kinda basic ques

What are the differences between a database index and a match code?

0 Answers  

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..

0 Answers  

What is the significance of technical settings (specified while creating a table in the data dictionary) ?

0 Answers  

What do you understand by work area and internal tables in abap? Why do we use it?

0 Answers  

WHAT IS DOCUMENTATION?WHY IT IS USED?

2 Answers   Accenture,

In select-options, how to get the default values as current month first date and last date by default?

0 Answers  

What are the standard macros do we use in HR ABAP

2 Answers  

What are the dis-advantages of logical databases? : abap hr

0 Answers  

Update function modules are classified as either v1 or v2. Which type of update is performed first and in what mode (asynchronously, synchronously or locally) can each type be processed in?

0 Answers  

how do we call multiple transactions in session method? (plzz with code)

1 Answers  

as a tem leader whats tools u have used in sap

2 Answers   Accenture,

What functions does a data dictionary perform ?

0 Answers