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
What are the major steps will you use for tuning?
What is a table attribute?
Explain the structure of a bdc sessions?
How many default tab strips are there? How to insert more tabs in it?
The loop-endloop on extract datasets can be used without any kind of errors. State true or false. : abap modularization
Does the table can have multiple foreign keys?
How to write a code for multiple transactions? : abap bdc
What are the system fields?
What is the difference between synchronous and asynchronous update?
what is diff between idocs,bdc,rfc and bapi. give real time answer
How do you find out whether a file exits on the presentation server?
send coding to write a program to create customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA2/BAPI_QUOTATION_CREATEFR OMDATA'
What are the different methods of passing data? : abap modularization
What takes most time in SAP script programming?
Explain the inside concept in select-options?