database table activation

[Former Member]

hi gurus,

I have add a new field to ztable created by some one and activated I received the bellow wornings.

( I did se14 -> adjust and activate database to reflect the changes to database ). what I need to avoid these wornings.

1) Enhancement category for include or subtype missing

Message no. DT193

2) Enhancement category for table missing

Message no. DT192

Procedure

Maintain the enhancement category in the table or structure maintenance in the ABAP Dictionary.

3) Table ZQM_INS_STATUS: 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.

thanks in advance,

padmaja

[Former Member]

Padmaja,

Post at [ABAP Dictionary forum|; for quicker & proper solution.

Srini

[Former Member]

Hi Padmaja,

There are two problems here

1) Enhancement Category : Goto SE11 -> table name -> change -> extras -> Enhancement Category , Please provide the proper enhancement category.

2) The key fields length is > 120 characters , disable one of the field as keyfield.

[Former Member]

Hi satish,

I have seen that Enhancement Category , and corrected but The key fields length is > 120 characters , disable one of the field as keyfield is not rectified what to do .

database table fields all are key fields except this doknr field.

hope i am clear.

tell me what steps I have to do to avoid the worning.

thanks in advance,

padmaja.

[Former Member]

hi,

Make sure that you only specify the character fields before the first non-character key field and enter the key with a generic ending. Enter the generic symbol directly after the specified part of the key.

You must enter the generic symbol at the latest in the 120th character of the key.

thanks

[Former Member]

>

> but The key fields length is > 120 characters , disable one of the field as keyfield is not rectified what 
> database table fields all are key fields except this doknr field.
> tell me what steps I have to do to avoid the worning.
> padmaja.

simple

1.To avoid warning "The key fields length has to be < 120 characters "

I guess u have around 10 key fields in ur Z table.

If this is Transactional table then,You can reconsider the Table design..

say like having unique number(Key) for an particular Document Creation / transaction (via SNRO)...etc

2.If this master table ...U can ignore the warning

Cheers

[Former Member]

Hi,

My ztable is having 7 fields out of the them 6 are key fields.

I didn't get what u r saying.I don't know whether that table is transactional or master table.

how to know it.

actually i am new to abap , so kindly replay me.

thanks in advance,

padmaja.

[Former Member]

HI,

The total length of the Key fields cannot exceed more the 120 chars so you need to reduce the length of the ley fields are make one or more fields of you key fields as normal fields just un tick the Key check box.

[Former Member]

thanks to all.

my problem is solved and i rewarded the points.

have a great day.

padmaja