longest key fields

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[valter_oliveira]

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.

[Former Member]

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

[Former Member]

hi..

thank you very much..

u almost solved my problem

Thank & regards,

Tulasi.