Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Key length > 120 (Restricted functionality) Error

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

rainer_hbenthal
Active Contributor
0 Kudos

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.

6 REPLIES 6

rainer_hbenthal
Active Contributor
0 Kudos

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.

0 Kudos

Hello Rainer,

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

BR,

Suhas

0 Kudos

Hi Rainer,

Can u Pls explain it in detail?

Regds,

Sam.

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

mawasey03
Participant
0 Kudos

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 .