how to resolve the z table activation error?

[Former Member]

I have a Z table.

Added a couple of fields and activated it. it was fine.

then changed one of the fields as a key field and activated it.

it took a long time even though there is no data and terminated.

I removed the key indicator and tried activating it. it showed errors.

Then I deleted it using SE14 and recreated with the same name. Now I am getting the following error:

See log E4911620080227134551:ACT

TABL ZPRICECONDN was not activated

Check table ZPRICECONDN (E49116/02/27/08/13:45)

Enhancement category for table missing

/ Table ZZPRICECONDN: Key length > 120 (Restricted functionality)

A table called ZPRICECONDN exists in the database

/ No active nametab exists for ZPRICECONDN

Termination due to inconsistencies

/ Table ZPRICECONDN (Statements could not be generated)

/ Error number in DD_DECIDE (9)

/ Check on table ZPRICECONDN resulted in errors

How to resolve this?

Do I have to do any database manipulations?

I looked at 306296 but DROP command is not available in ABAP?

Pl advise.

Thanks

Ven

[former_member226234]

Hi,

Reduce the total length to less or equal to 120 characters.

Regards,

Sandeep

[Former Member]

Sandeep,

Pl read through the error and it says about the nametab.

this is the actual error.

120 is just a warning.

[Former Member]

Hi,

GOto Tcode 'SE14' --> Enter table name -->Press Edit button

--->Below you will find Active and adjust the data and select the radio button "Save data" and save it.

[ravisankara_varaprasad]

Hi,

Adjust the database table using SE14 to avoid this error.

Kind Regards,

Ravi Sankar.Z

[Former Member]

Hi,

Whenever you make some changes to the database table, you need to activate it through the

database utility function (SE14).

Enhancement category for table missing:

to resolve this: SE11>>Table name>> Extras>>Enhancement category...and choose the option 'can be enhanced'.

/ Table ZZPRICECONDN: Key length > 120 (Restricted functionality)

Reduce your key fields length to <120.

After doing those changes activate it through the database utility.

I hope, it will work for you.

Regards,

Jallu

[Former Member]

Solved - The nametab issue was resolved by copying the name tab from another table that was created on the same lines as this table in question.