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

In the abap/4 dictionary tables can be defined independent of the underlying database (t/f). : abap data dictionary

704


There is a delivery that is being created through the ABAP code and in the middle it says delivery created but someone is modifying , how would you rectify this issue

7578


What are the events used in abap in the order of execution?

559


What is an update type with reference to a match code id? : abap data dictionary

585


What is For-period and In-period

1733






Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary

614


What is the difference between function group and function module?

517


What are the different database integrities?

577


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

567


I am getting the (first) page number and the remaining records displayed in another list in another page BUT the PAGE Number is not displayed? What is the code/solution?

1535


What is the function of a domain? : abap data dictionary

586


What is the use of enqueue function module? : sap abap data dictionary

579


What is sap script? Describe its components.

597


How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?

623


What are system fields for secondary lists?

607