topic Re: pool tables in Application Development and Automation Discussions

pool tables

Former Member — Fri, 23 May 2008 12:00:54 GMT

what is the diff between table pool and pooled tables?

Re: pool tables

Former Member — Fri, 23 May 2008 12:06:34 GMT

hi,

Pooled Table : Pooled tables are logical tables that must be assigned to a table pool when they are defined. Pooled tables are used to store control data. Several pooled tables can be cominied in a table pool. The data of these pooled tables are then sorted in a common table in the database.

The below link is to .... how to create pooled table

http://help.sap.com/saphelp_46c/helpdata/en/81/415d363640933fe10000009b38f839/frameset.htm

Regards,

Re: pool tables

Former Member — Fri, 23 May 2008 12:21:05 GMT

Hi SRK,

I will tell you in a simple words,

Pooled Table is the table which has less number of tables with less number of fields,For pool we no need to do technical settings.

EX:A001.

Whereas Cluster tables have large number of small tables present in it.For cluster tables we need to do technical settings.

Ex:BSEG

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.

reward points if useful.

Thanks,

Khan.

Re: pool tables

Former Member — Mon, 26 May 2008 10:50:21 GMT

hi,

A table pool (or pool) is used to combine several logical tables in the ABAP/4 Dictionary. The definition of a pool consists of at least two key fields and a long argument field (VARDATA).

Pooled tables :

These are logical tables, which must be assigned to a table pool when they are defined. Pooled tables can be used to store control data (such as screen sequences or program parameters).