what is the difference between transparent, pooled and
cluster table
Answers were Sorted based on User's Feedback
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.
Is This Answer Correct ? | 24 Yes | 14 No |
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.
Is This Answer Correct ? | 7 Yes | 4 No |
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.
Is This Answer Correct ? | 5 Yes | 2 No |
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.
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / abhinesh mishra
plz refer abap in 21 days for these kinda basic ques
Is This Answer Correct ? | 13 Yes | 25 No |
What is alv programming in abap? When is this grid used in abap? : abap hr
What is ole?
hai iam srinivas. I have done client copy in sccl for 800 client and i have stopped the process in middle unexceptedely and after some time iam unable to login into the client 800. error message is incorect password or inclient username. how to refresh the client or solve the problem. please me out in it.
You are given functional specs for a BDC program and you need to decide whether to write a method call transaction or a session. How u will decide?
HOW MANY IMPLEMENTATIONWE CAN CREATE IN BADI? WHAT IS THE USE OF REUSABLE IN BADI? HOW MANY IMPLEMENTATION IS ACTIVE IN PRODUCTION SYSTEM AT A TIME?
What is collective search help? : sap abap data dictionary
what is a field symbol?
Kindly help me to Know the process of mapping in EDI from R/3 to a convertor(third party which translates IDoc flatfile to EDIFACT /XML / FTP /HTTP ) ?
what is the difference betn end-of-page and end-of- selection?
Search help exit details.
Reports: Event functionality.
what are the tools you are using for performance tuning in a object?