Can we Able to create a Cluster Table??giv me any example?

[Former Member]

How to create a cluster Table ????

give me any example of cluster table which SAP already defined??

[Former Member]

You can look at CDPOS, BSEG tables, which are cluster table.

Regards,

Ravi

Note - Please mark all the helpful answers

[Former Member]

Hi,

1) go to se11 transaction

2) go to utilities/other dictionary objects

3) press create button

4) It will prompt u whether u want to create Cluster / Pooled, select the appropriate one

-Satya Priya

[Former Member]

can u giv me brief description ...y we want 2 create a Cluster Table????

[Former Member]

Hi Srinivasan,

Sometimes, several tables can be linked by a common key. The ABAP/4 Data Dictionary can also combine these tables into a single table [Cluster Table].

Note: Both Pooled and Cluster Tables are stored as tables within the database. Only the structures of the two table types which represent a single logical view of the data are defined within the ABAP/4 Data Dictionary. These tables are commonly loaded into memory (i.e., 'buffered') due to the fact they are typically used for storing internal control information and other types of data with little or no external (business) relevance.

-Satya Priya

[Former Member]

hi...

cluster table :

A cluster table has many to 1 relationship...

A few tables in the R/3 DDIC .. but only one table in DATABASE...

And i think cluster tables shud have atleast one primary key in common

Cluster table are much more complex and you cannot display the data of a cluster table directly....

Cluster table have to be read and displayed via your ABAP program...

To find the cluster behind a cluster table, just go to the attributes of the table.

or go thro these information i got abt cluster table.

A table cluster is used to combine several tables. In the process several lines from different tables are combined in a single record. The records of all tables combined in a table cluster are stored in one table in the database.

A cluster contains a transparent cluster key which must be the first part of the key of all tables assigned to the cluster.

A table cluster also has a long field which contains the data from the tables on this key. If the data does not fit into this field, continuation records are created.

example for cluster table:

BSEG is a cluster table consisting data from tables

BSID,BSAD,BSIS,BSAS,BSIK,BSAK which all are transperent tables.

to create a cluater table:

1) go to se11 transaction

2) go to utilities

3) press create button

4) It will prompt u whether u want to create Cluster / Pooled table

5) select wat u want to create-either cluster or pool.

***reward if my ans is helpful.

[Former Member]

hi srinivas,

check it out,

Creating Pooled Tables/Cluster Tables

Procedure

In the initial screen of the ABAP Dictionary select object type Table, enter a table name and choose Create.

The field maintenance screen for the table is displayed. Table type Transparent table is set as default.

Make the necessary entries in the Short description and Delivery class fields on the Attributes tab page. Then define the fields of the table.

Proceed as when creating a transparent table. Save your entries.

Choose Extras ® Change table category.

A dialog box appears in which you have to select the table type Pooled table or Cluster table.

Choose Select.

You return to the field maintenance screen for the table. Field Pool/cluster name is displayed on the Attributes tab page in addition to the standard fields.

Enter the name of the table pool or table cluster to which you want to assign the pooled table or cluster table in field Pool/cluster name

Note that the total key length of a pooled table may not exceed the key length of the associated table pool. The key of a cluster table must correspond to the key of the associated table cluster.

Proceed as when creating a transparent table (see Creating Tables). Remember that you cannot create indexes for pooled or cluster tables.

Here is the corresponding link

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

if u find it useful mark the points

Regards,

GUDURI