tables

[Former Member]

hi to all,

can any one provide me examples of cluster and pool tables in sd and mm modules.

thanx and regards,

lokanadhan.k

[vyende]

Transaction SE11. Pull down on "Database table". Expand selection (Shift+F7).

Select/Unselect cluster or pool table on additional selections. Press Enter.

Anyway: examples include VTIUL (pooled table), MHND (cluster)

[former_member189059]

Pool table

A database table defined in the ABAP Dictionary whose database instance is assigned to more than one table defined in the ABAP Dictionary. Multiple pool tables are assigned to a table pool in the database. The key fields of a pool table have to be character-type fields. The table pool's primary key consists of two fields: TABNAME for the name of a pool table, and VARKEY for the interdependent contents of the key fields in the corresponding pool table. The non-key fields of the pool table are stored in compressed format in their own column, called VARDATA, of the table pool. The only way to access pool tables is by using Open SQL. Joins are not allowed.

Table Pool

Database table in the database that contains the data of several pool tables.

Cluster Table

Database table defined in the ABAP Dictionary, whose version on the database is not only assigned to one table defined in the ABAP Dictionary. Several cluster tables are assigned to a table cluster in the database. The intersection of the key fields of the cluster tables forms the primary key of the table cluster. The other columns of the cluster tables are stored in compressed form in a single column VARDATA of the table cluster. You can access cluster tables only via Open SQL, and only without using joins.

Table Cluster

Database table in the database that contains the data of several cluster tables.

Note: Never mix up with a database table that has the necessary structure for storing data clusters in database tables and in the shared memory. Those are called INDX-type, with reference to the database table INDX supplied by SAP. Data clusters are groupings of data objects for transient and persistent storage in a selectable storage medium. A data cluster can be processed using the statements IMPORT, EXPORT, and DELETE FROM.

1) T040, T040A--pooled

2) BSEG, BSES---->cluster

Pooled tables can be used to store control data (e.g. screen sequences, program parameters or temporary data). Several pooled tables can be combined to form a table pool. The table pool corresponds to a physical table on the database in which all the records of the allocated pooled tables are stored.

A001

A004

A005

A006

A007

A009

A010

A012

A015

A016

A017

A018

A019

A021

A022

Cluster tables contain continuous text, for example, documentation. Several cluster tables can be combined to form a table cluster. Several logical lines of different tables are combined to form a physical record in this table type. This permits object-by-object storage or object-by-object access. In order to combine tables in clusters, at least parts of the keys must agree. Several cluster tables are stored in one corresponding table on the database.

AUAA

AUAB

AUAO

AUAS

AUAT

AUAV

AUAW

AUAY

BSEC

BSED

BSEG

BSES

BSET

CDPOS

you can refer to the link http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm for standard documentation.

reward points if it is helpful.

[Former Member]

hi,

goto DD02L table.In that in the table category give whatever the category u want i.e.either pooled or cluster.Then u can get the list of pooled and list of cluster tables.

[Former Member]

Hi,

u can able to find all kind of tables in dd02l

Regards,

praveen