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 Difference between At Line selection and At user-command?

742


What is protect & endprotect?

651


What is the bapi?

698


What are the difference between pool tables and transparent tables?

717


Explain what are the system fields? Explain?

663






Define structure in abap data dictionary?

702


How many types of tables exists and what are they in data dictionary? : abap data dictionary

807


What statement will be found in an sap application program that implements a function module exit?

656


What are the different types of views in sap? : abap data dictionary

700


What is payroll driver ? : abap hr

706


How do you Export a session ?

1533


What are the components of sap scripts? : abap hr

677


What are null values? : abap data dictionary

735


Explain the use of insert and append statement in sap abap?

696


How do you set up background jobs in sap? What are the steps?

652