topic What are Cluster Tables? in Application Development and Automation Discussions

What are Cluster Tables?

Former Member — Thu, 26 Apr 2007 08:30:31 GMT

What are Cluster Tables?

Re: What are Cluster Tables?

Former Member — Thu, 26 Apr 2007 08:32:36 GMT

hi Sai,

<b>Cluster table</b>

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.

Can check this link for more clarity

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

Regards,

Santosh

Message was edited by:

Santosh Kumar Patha

Re: What are Cluster Tables?

Former Member — Thu, 26 Apr 2007 08:32:45 GMT

Cluster tables: A single table in the database (cluster) have a one to many relationship in the dictionary.

Re: What are Cluster Tables?

Former Member — Thu, 26 Apr 2007 08:33:39 GMT

hi,

<u>Cluster table</u>

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.

Rgds

Anver

Re: What are Cluster Tables?

Former Member — Thu, 26 Apr 2007 08:34:39 GMT

sai,

CLUSTER Tables :-

Table clusters (clusters) are special table types in the ABAP Dictionary

The data from several tables is 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 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.

Can check this link for more clarity

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

Don't forget to reward if useful...

Re: What are Cluster Tables?

Former Member — Thu, 26 Apr 2007 08:36:03 GMT

Hi sai,

1. Cluster table means that,

In abap dictionary there are many tables (cluster tables),

2. But They all are linked to only one database table (actual physical table in database).

3. Eg. BSEG is in abap dictionary.

BSEG won't be there in actual database, instead,

they corresponding table name is RFBLG

which has the corresponding fields

MANDT CLNT 3

BUKRS CHAR 4

BELNR CHAR 10

GJAHR NUMC 4

PAGENO INT2 5

TIMESTMP CHAR 46

PAGELG INT2 5

VARDATA RAW 3800

All the data of BSEG fields, is stored in

VARDATA in encoded format. The primary keys are also saved.

regards,

amit m.

Re: What are Cluster Tables?

Former Member — Thu, 26 Apr 2007 08:37:55 GMT

Hi Sai,

Cluster Table also appears like Transparent table but consists of huge data, so consumes more time to fetch the records from it.

You can't join it with other tables to fetch the data.(BSEG in FI, KONV table for pricing are clusters)

in HR all PCL1, PCL2, 3 are clusters of similar type.

Creating a cluster table.

http://help.sap.com/saphelp_erp2005/helpdata/en/cf/21f0b7446011d189700000e8322d00/frameset.htm

Following is the step by step procedure.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f0b7446011d189700000e8322d00/content.htm

To access cluster table:

http://fuller.mit.edu/hr/cluster_tables.html

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

Regards,

Padmam.

Re: What are Cluster Tables?

Former Member — Thu, 26 Apr 2007 12:22:03 GMT

hi,

Tables r of three types.

1. Transparent table.

2. Pool table

3.Cluster table.

1.In cluster table it uploads system data.

2.It is many to 1 relationship.

3.It is a small collection of large tables.

4.It consists of n number of records.

where as in pool table it is a collection of large number of small tables.

if useful dont forget to reward with points.

with regards,

madhuri.

Re: What are Cluster Tables?

Former Member — Thu, 26 Apr 2007 19:03:11 GMT

Hi,

A table cluster combines several logical tables in the ABAP/4 Dictionary. Several logical rows from different cluster tables are brought together in a single physical record. The records from the cluster tables assigned to a cluster are thus stored in a single common table in the database.

Regards,

Bhaskar