topic Re: pool and cluster table in Application Development and Automation Discussions

pool and cluster table

Former Member — Tue, 28 Aug 2007 20:17:07 GMT

Hi,

Can anyone please tel me how to create pool and cluster table?

I tried creating it thorugh the step provided in help.sap.com, stil i want to know how to update records in the pooled table and clustered table and how these are linked to table pool and clsuter pool.

Please help me in this

Ramya

Re: pool and cluster table

Former Member — Tue, 28 Aug 2007 22:39:54 GMT

Hi,

Why are you going to create Pool or Clustor tables? any abaper very rarely need to create a cluster or pool table...

These tables are not used for the transaction or master data. They are used to hold the customization data.

The Table Pools and Table clusters are the group of pool and cluster tables.. A Pool or Cluster table has to be assigned to a pool. The table can not exist standalone..

Read for further information:

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

Thanks and Best Regards,

Vikas Bittera.

**Points for useful answers**

Re: pool and cluster table

Former Member — Wed, 29 Aug 2007 00:04:37 GMT

Hi Thanks for your reply. But anyway i jus wanted to know how it is created and how datas wil be maintanied. i created a pool table and assigned that pool table to a table pool. But now i wanted to know how datas are goin to get stored in the pool table, coz i didnt write anythng into it and i jus created it.

Re: pool and cluster table

Former Member — Wed, 29 Aug 2007 02:54:16 GMT

"Creating Pooled Tables/Cluster Tables

" Procedure

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 'OK' 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.

reward points if it is usefull .....

Girish