topic Re: problem in creating Table Cluster in Application Development and Automation Discussions

problem in creating Table Cluster

Former Member — Fri, 13 May 2016 04:10:37 GMT

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

Re: problem in creating Table Cluster

jay_kumar8 — Fri, 13 May 2016 04:50:32 GMT

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

Re: problem in creating Table Cluster

Former Member — Fri, 13 May 2016 05:20:01 GMT

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

Re: problem in creating Table Cluster

Sandra_Rossi — Fri, 13 May 2016 05:53:55 GMT

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

Re: problem in creating Table Cluster

ThomasZloch — Fri, 13 May 2016 06:42:12 GMT

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

Re: problem in creating Table Cluster

ThomasZloch — Fri, 13 May 2016 06:44:16 GMT

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.

Re: problem in creating Table Cluster

ThomasZloch — Fri, 13 May 2016 06:49:37 GMT

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

Re: problem in creating Table Cluster

Former Member — Fri, 13 May 2016 07:04:41 GMT

Thanks for replies

i replaced varkey with matnr & issue is resolved

Please check below screen shot

Regards,

Gyanendra Kumar