Cluster Table

Step to Create Cluster Table.
Note: Whenever we create the clustered table then we must maintain the primary fields in the table clustered.
Whenever we create the clustered table then we must maintain at least one non primary key.

Creation of Cluster is two Step Process 
Step 1: Create Table Cluster.
Step 2: Create Cluster Table.

Step 1

Execute SE11.







Click on Utilities and Select Other Dictionary Objects.

Select Table pool/Cluster Radio Button, Provide Table Cluster Name and Click on Create.

Select Table Cluster Radio Button and Click on Contine.

Provide Short Description.

Place the Cursor on VARKEY and Click on Delete Row

Place the Cursor on PAGE No and Click on Insert Row

Provide the our Require Field.

Click on SAVE
Click on Goto and Select the Technical Settings

Provide Size Category

Click on Save,Check and Back Button.

Step 2: Create Cluster Table
Execute SE11.

Select the Database table Radio Button and Provide Cluster Table Name.

Click on Button

Provide short Description, Delivery Class and Display/Maintenance Allowed.

Clcik on Field Tab. And Provide Same Field name as Table Cluster name and at list one field require Non Primary key Like Name1.

Click on Save Button

Click on Technical Settings

Provide Data Class and Size Category

Click on SAVE,Check and Back Button

Click on Extras and Select Enhancement Category

Select Radio Button Can be Enhanced (Deep) and Click on Copy

Click on Save, Check and Activate Table.