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 is projection view?
What is the difference between a structure and a table? : abap data dictionary
Reports: Event functionality.
Explain the difference between a pool table and a transparent table and how they are stored at the database level?
What is the use of lock objects?
What are logical databases?
What is the difference between skip and reserve?
What is the difference between data elements and domains? : abap data dictionary
Differentiate between the uline and write: sy-uline statements if any?
Value table VS check Table.
What is a table attribute? : abap data dictionary
What is personnel sub are
What are the steps in a bdc session? : abap bdc
wat are the process that can be executed & tracked in a workflow?
how to Create reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data will be extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables. plz mention the detail coding Tahnks, Rahul