topic Re: database table activation in Application Development and Automation Discussions

database table activation

Former Member — Fri, 20 Mar 2009 04:31:41 GMT

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

Re: database table activation

Former Member — Fri, 20 Mar 2009 05:24:54 GMT

Padmaja,

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

Srini

Re: database table activation

Former Member — Fri, 20 Mar 2009 06:47:59 GMT

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.

Re: database table activation

Former Member — Fri, 20 Mar 2009 07:08:57 GMT

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.

Re: database table activation

Former Member — Fri, 20 Mar 2009 07:24:25 GMT

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

Re: database table activation

Former Member — Fri, 20 Mar 2009 11:12:18 GMT


> 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

Re: database table activation

Former Member — Fri, 20 Mar 2009 11:34:21 GMT

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.

Re: database table activation

Former Member — Fri, 20 Mar 2009 11:53:55 GMT

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.

Re: database table activation

Former Member — Sat, 21 Mar 2009 05:04:26 GMT

thanks to all.

my problem is solved and i rewarded the points.

have a great day.

padmaja