topic Re: Key length > 120 (Restricted functionality) Error in Application Development and Automation Discussions

Key length > 120 (Restricted functionality) Error

Former Member — Mon, 28 Sep 2009 13:06:44 GMT

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.

Re: Key length > 120 (Restricted functionality) Error

rainer_hbenthal — Mon, 28 Sep 2009 13:23:36 GMT

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.

Re: Key length > 120 (Restricted functionality) Error

SuhaSaha — Mon, 28 Sep 2009 13:27:46 GMT

Hello Rainer,

I think it is 120bytes & not 120 characters. I think that there is difference between the two

BR,

Suhas

Re: Key length > 120 (Restricted functionality) Error

Former Member — Mon, 28 Sep 2009 13:28:32 GMT

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).

Re: Key length > 120 (Restricted functionality) Error

Former Member — Mon, 28 Sep 2009 13:31:54 GMT

Please have a look at SAP note : 355898 regarding restrictions on transparent tables

Re: Key length > 120 (Restricted functionality) Error

Former Member — Tue, 29 Sep 2009 12:02:59 GMT

Hi Rainer,

Can u Pls explain it in detail?

Regds,

Sam.

Edited by: sam24 on Sep 29, 2009 2:03 PM

Re: Key length > 120 (Restricted functionality) Error

mawasey03 — Sun, 12 Jan 2014 12:03:46 GMT

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 .