topic Re: longest key fields in Application Development and Automation Discussions

longest key fields

Former Member — Wed, 17 Sep 2008 08:51:58 GMT

Hi all,

Can any one of you specify me the table name having the longest key fields,

that is the sum of the lengths of all the key fields should exceed 120

If any one of u know kindly revert back ASAP.

Thanks in advance,

Tulasi

Re: longest key fields

Former Member — Wed, 17 Sep 2008 08:56:29 GMT

Hi,

Not Possible.

There are two restrictions on the key fields while creating a table.

1) The maximum number of keys in a table is 16.

2) The maximum length of the key fields is 120.

Regards,

Kothand

Re: longest key fields

Former Member — Wed, 17 Sep 2008 09:26:51 GMT

Hi Kothand,

Can you please tell me the link or any reference material from where you got this point

This is beacause i need to focus more on this.

Kindly let me know.

Thanks & Regards,

Tulasi.

Re: longest key fields

valter_oliveira — Wed, 17 Sep 2008 09:32:36 GMT

Not Possible.

That's not totaly true.

BY SE11

Table ZTABLE: Key length > 120 (Restricted functionality)

Message no. DT214

Diagnosis

The key length, i.e. the sum of the field lengths of all the key fields of the table, is more than 120 bytes.

System Response

This is a warning.

Procedure

Note the following restricted fuctionality for this table:

- Table contents cannot be transported by specifying key values, at

best by specifying generic key values with a maximum length of 120

bytes.

- The table may not be used as the base table of a lock object.

Regards,

Valter Oliveira.

Re: longest key fields

Former Member — Wed, 17 Sep 2008 09:48:47 GMT

Hi Tulasi,

Yes . As Valter mentioned correctly that is not completely correct.

Actually the key length cannot exceed 255 characters. But the restriction is that if its more than 120 characters those table entries cannot be transported. Also Lock restriction is there.

So i think SAP tables dont have more than 120 characters as you have asked for example table having more than 120 characters.

Please check the following SAP Help(under Constraints heading) for reference.

http://help.sap.com/erp2005_ehp_03/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

Cheers,

Kothand

Re: longest key fields

Former Member — Wed, 17 Sep 2008 09:56:46 GMT

hi..

thank you very much..

u almost solved my problem

Thank & regards,

Tulasi.