Creating Pooled Tables/Cluster Tables 

Procedure

...

       1.      Open the Repository Browser (Transaction Code SE80) and navigate to the package in which you want to create the pooled/cluster table.

       2.      In the context menu of the package, choose Create ® Dictionary Object ® Database Table.

A dialog box appears.

       3.      In the new dialog box, enter the name of the table and choose  with the quick info text Continue.

The maintenance screen for the table appears. The system sets table type Transparent table as default.

       4.      Make the necessary entries in the Short Description and Delivery class fields on the Delivery and Maintenance tab page.

       5.      Define the fields of the table.

Proceed as when creating a transparent table.

The types DF16_DEC/DF34_DEC/DF16_RAW/DF34_RAW are not allowed in the primary key of cluster and pool tables.

The types DF16_SCL/DF34_SCL are not allowed in cluster and pool tables.

       6.      Choose  with the quick info text Save.

       7.      Choose Extras ® Change table category.

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

       8.      Choose Copy.

You return to the field maintenance screen for the table. The Pool/cluster field is displayed on the Delivery and Maintenance tab page in addition to the standard fields.

       9.      In the Pool/cluster field, enter the name of the table pool or table cluster to which you want to assign the pooled table or cluster table.

The total key length of a pooled table cannot 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.

   10.      Proceed as when creating a transparent table (see Creating Tables).

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, you must convert the table to a transparent table.