problem in creating Table Cluster

[Former Member]

while creating table cluster, add one field matnr as key element after save and check it gives error 'The key is longer than the maximum allowed length 000120' and '  You cannot change function fields (PAGENO: Type INT2 with length of 5, key field)'

please check screenshot

[Former Member]

while creating table cluster, add one field matnr as key element after save and check it gives error 'The key is longer than the maximum allowed length 000120' and '  You cannot change function fields (PAGENO: Type INT2 with length of 5, key field)'

please check screenshot

[jay_kumar8]

Hi Gyanedra,

here your all key fields length is greater than 120.

Restrict the matnr length to 5 characters then it will work.

Regards

Raj

[Sandra_Rossi]

To complete the topic, the limit of 120 and other restrictions are described (for example) in SAP note 355898 Restrictions on transparent tables

[ThomasZloch]

So you think a MATNR of length 5 will "work"? Even if you manage to activate the cluster this way, it will be useless from a functional point of view.

Thomas

[Former Member]

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

1. create a table and specify the fields and other technical settings and then

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

2.Then Create another table And specify the required fields and also the settings and then

Goto  ------ >  EXTRAS ------ > Change Table Category ------ >  and select the Cluster table and in  ------ > Delivery and Maintenance ------ > Properties mention the Pooled table that u created and activate it...

Pooled and Cluster Tables - Application Development on AS ABAP - SAP Library

Regards,

Praveen

[ThomasZloch]

Creating a pool table first in order to create a cluster table? Where does this come from? Not from the link you have provided.
Did you try this yourself?

Thomas

[ThomasZloch]

This first message has been discussed and is actually quite self-explaining, isn`t it?

The second one is likely caused by PAGENO not being the bottom-most primary key field.

Thomas

...and one more thing: just tried to create a cluster myself (rarely ever had the need to do that), VARKEY 110 seems to be a default, it looks like you can change this to your needs. Just leave everything from PAGENO down unchanged.

[Former Member]

Thanks for replies

i replaced varkey with matnr & issue is resolved

Please check below screen shot

Regards,

Gyanendra Kumar