topic Cluster table..... in Application Development and Automation Discussions

Cluster table.....

Former Member — Fri, 28 Sep 2007 10:59:53 GMT

Hi all,

In sap there are some Cluster and Pooled tables, but how to see those tables, i.e for example BKPF and BSEG are the cluster tables, but how to these are the cluster tables?

Regards,

sudharsan.

Re: Cluster table.....

Former Member — Fri, 28 Sep 2007 12:00:26 GMT

question is not clear, plz come again

Re: Cluster table.....

Former Member — Fri, 28 Sep 2007 13:01:26 GMT

BSEG is a cluster table, but BKPF is transparent.

Look at table RFBLG to see the different clusters.

Rob

Re: Cluster table.....

suredarreddy_pulimamidi — Sat, 29 Sep 2007 13:50:54 GMT

to find out the different types of tables in SAP goto table dd02l and give TABCLASS as TRANSP Transparent table

CLUSTER Cluster table

POOL Pooled table

you found a lot of tables.

if helpful reward some points.

Re: Cluster table.....

Former Member — Sat, 29 Sep 2007 14:04:23 GMT

BKPF is not cluster table

BSEG is the cluster table

Goto SE11 and you can see all tables here..

Check the below link :

http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm

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

Popular Cluster table : BSEG

Thanks

Seshu