topic Re: How to create cluster table? in Application Development and Automation Discussions

How to create cluster table?

Former Member — Tue, 29 Aug 2006 04:54:51 GMT

Hi all ,

I need to create cluster table... please could u help me..

Regards,

srinivas

Re: How to create cluster table?

Former Member — Tue, 29 Aug 2006 04:57:03 GMT

For creating cluster tables first u have to create table pool ...

create a table and specify the fields and other tecnical settings and

then Goto EXTRAS --> Change Table Category and selct the Pooled table and activate it...

Then Create another table And specify the required fileds and also the settings and then Goto EXTRAS --> Change Table Category and selct the Cluaster table and in Delivery and Maintainence Properties mention the Pooled table that u created and activate it...

Following is the step by step procedure.

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

Re: How to create cluster table?

sridharreddy_kondam — Tue, 29 Aug 2006 04:57:26 GMT

Hi srinivas,

For creating cluster tables first u have to create table pool ...

create a table and specify the fields and other tecnical settings and

then Goto EXTRAS --> Change Table Category and selct the Pooled table and activate it...

check this

If any further required u r welcome...

Regards,

Sridhar reddy

Re: How to create cluster table?

sridharreddy_kondam — Tue, 29 Aug 2006 04:58:47 GMT

Hi srinivas,

first u have to create Table pool/cluster.. then cluster/pool tables..

Just goto SE11 .. UTILITIES --> Other Dictionary Objects

and selct and create accordingly

Regards,

Sridhar

Re: How to create cluster table?

Former Member — Tue, 29 Aug 2006 05:12:05 GMT

Hi,this may help u..

1. 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.

2. 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.

3. Choose Extras ® Change table category.

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

4. 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.

5. 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.

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

All the attributes of the technical settings can be maintained for pooled tables and cluster tables. Before you can access these attributes, however, you must convert the table to a transparent table.