05-13-2016 5:10 AM
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
05-13-2016 8:04 AM
Thanks for replies
i replaced varkey with matnr & issue is resolved
Please check below screen shot
Regards,
Gyanendra Kumar
05-13-2016 5:50 AM
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
05-13-2016 6:53 AM
To complete the topic, the limit of 120 and other restrictions are described (for example) in SAP note 355898 Restrictions on transparent tables
05-13-2016 7:42 AM
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
05-13-2016 6:20 AM
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
05-13-2016 7:49 AM
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
05-13-2016 7:44 AM
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.
05-13-2016 8:04 AM
Thanks for replies
i replaced varkey with matnr & issue is resolved
Please check below screen shot
Regards,
Gyanendra Kumar