Warning in SE11 - Defining tables.

[former_member187400]

Dear Expertise,

Could you share your experience to me if you have ?? :).

I define a table in SE11 whose the key has length more than 120 bytes. When i was activating the table, the warning emerged, displaying that the sum of lenght of all keys are more than 120 bytes.

Eventhough it's only a warning,,,

Does it have impact (impact to anything) ??

Could you kindly suggest me what i should do ??

Many thanks all.

Kind regards,

Niel.

[Former Member]

Normally the warning are not considered ..... But in your case it was with table and for key field ...

so check with function spec as it is required that much field length and also as primary field .

because key fields will have later check tables and primay relation with another table so we need to avoid it .

reward points if it is usefull...

Girish

[former_member187400]

Wow a quick reply ..

Tks Kumar.

But so far we need those keys whose sum of lenght is more than 120 bytes.

Do you have any suggestion beside i have to decline the length of PK ??

Many thanks Kumar.

Still need your guidance.

Kind regards,

Niel.

[Former Member]

Should not get warning message because key field length is more than 120 byte.

Talk to your senior members

Thanks

Seshu

[former_member187400]

You means i should not have got that warning message ..

But perhaps you could help me how to overcome it, here i attached the all message.

-

---

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.

-

---

Could i ignore this warning ?

Is there any impact ??

Many thanks Seshu..

Still need your guidance Seshu.

Kind regards,

Niel .

[Former Member]

Hi Niel,

Refer to note 759724.

It can throgh some light on why the key should be small.

Reward points if useful.

Regards,

Atish