09-28-2009 2:06 PM
Hi Experts,
I created a ZTable with 4 Primary Key fields.The sum of all these fields is 175.When I am activating the table it is showing the following error.
Key length > 120 (Restricted functionality)
Message no. DT214
The key length, i.e. the sum of the field lengths of all the key fields of the table, is more than 120 bytes.
Is there any solution to solve this problem?
Regds,
Sam.
09-28-2009 2:23 PM
No. Key len is limited to 120 chars.
You can choose another PK like timestamp or an additianil unique id aund put secondary unique index on the fields you need.
09-28-2009 2:23 PM
No. Key len is limited to 120 chars.
You can choose another PK like timestamp or an additianil unique id aund put secondary unique index on the fields you need.
09-28-2009 2:27 PM
Hello Rainer,
I think it is 120bytes & not 120 characters. I think that there is difference between the two
BR,
Suhas
09-29-2009 1:02 PM
Hi Rainer,
Can u Pls explain it in detail?
Regds,
Sam.
Edited by: sam24 on Sep 29, 2009 2:03 PM
09-28-2009 2:28 PM
Hello
There is one of the restrictions on the key fields: the maximum length of the key fields is 120.
Read this for details: http://help.sap.com/erp2005_ehp_03/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm
You need to reduce number of key fields or length of this fields (down to 120 and less).
09-28-2009 2:31 PM
Please have a look at SAP note : 355898 regarding restrictions on transparent tables
01-12-2014 12:03 PM
Dear Former Member
Please goto change table in SE11 and remove the check boxes for primary key in table so that number of primary keys are reduced.And then activate before transporting.
Please put ratings if this helps .