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.

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.

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.

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.

Answer / abhinesh mishra

plz refer abap in 21 days for these kinda basic ques

1/ what r the driver programe used in your script ? 2 / can we change from classical report to interactive report ?

2 Answers   IBM,

What are the main uses of the primary key?

0 Answers  

what are the main events that are used in an ALV report?

6 Answers  

When was the sap abap being created?

0 Answers  

How to print continuous pages in smartform?my requirement is i need to print 3 pages for each customer i.e 2 pages for purchase order forms and 3rd page is terms and condition page.Likewise how can i print 100 customer pages at once continuously?

2 Answers   Cap Gemini,

What is updated Function Module.

3 Answers   IBM, Intelligroup,

what is the difference detween EDI AND ALE?

5 Answers  

what is the use of control_form?

2 Answers  

23) How to create one page in landscape and the other page in portrait in Scripts?

2 Answers  

How to handle Error in LSMW. This is urgent anybody know this answer plz post me...

2 Answers   Cap Gemini,

Hi all, For the past 1 year, I have been trying for job in SAP as a fresher, but no calls,no interviews.I know showing fake experience is unethical, but i dont have any alternative.After showing fake experience now iam getting calls,but still i feel guilty.Friends i have some questions. 1. If suppose i tell the truth in interview that i have shown fake experience,what would be the interviewer's reaction? Will accepting the fake go negative against me? 2.Whether i should accept the fake in technical round itself? (or) Maintain the fake,prove myself strong in technical round &then accept the fake in HR round? 3.Some of my friends(who have shown fake and well settled in MNC's ) are telling that during interview u should never accept as fake i.e., u should act confidently as a real experienced guy.Even if the interviewer come to know that u r a fake guy, but seeing ur confidence level ,he/she will select u ? Is it true? Friends, particularly interviewer's , HR's please give me ur valuabe solutions.Other's suggestions are also welcome.

6 Answers  

What are table clusters?

0 Answers