topic Re: Alter Table Not Possible in Application Development and Automation Discussions

Alter Table Not Possible

bjorn-henrik_zink — Thu, 25 Aug 2005 10:00:30 GMT

Hi,

I'm trying to alter a database table with a field 'Quantity' type 'VRFMG'. When I try to activate the table I get the following message:

Table is not yet classified

TABLENAME-QUANTITY (specify reference table AND reference field)

Field QUANTITY: Type change

ALTER TABLE is not possible

Table TABLENAME is modified (Deleted or deleted/created new)

Check on table TABLENAME resulted in errors

Anyone who knows how I can solve this problem?

Thanks in advance.

Elvez

Re: Alter Table Not Possible

Former Member — Thu, 25 Aug 2005 10:09:38 GMT

Add another field which is of type unit (eg MEINS ).

All quantity type fields must be linked to corresponding unit fields (in the same or other table) otherwise it would be meaningless (eg a quantity of 12.345 is meaningless unless you say whether it KG or M..., this unit is stored separately in a unit field that you need to specify).

You can add the unit field, and then make the reference in the tab currency/Quantity fields in SE11.

cheers,

Re: Alter Table Not Possible

athavanraja — Thu, 25 Aug 2005 10:10:12 GMT

from transaction se11 go to the edit mode of the table

click on the currency/quantity fields tab

agains the field name in question maintain ref table and field name

it could be from the same table or from other table.

Regards

Raja

Re: Alter Table Not Possible

Former Member — Thu, 25 Aug 2005 10:11:38 GMT

hi,

I thing the table has some entries. Delete all the entries and try to modify the field, it will work, or you delete the field and create the new one.

Cheers,

Sasi

Re: Alter Table Not Possible

Former Member — Thu, 25 Aug 2005 10:56:55 GMT

When you put field quantity or amount in a dictionary table, you have to specify a reference field: if your field is a quantity then your reference field is a unit field, if your field is a amount then your reference field is a currency field.

It doesn't need that the referenced fields are in the same table (for example the reference field of BSEG-DMBTR is T001-WAERS).

Re: Alter Table Not Possible

bjorn-henrik_zink — Thu, 25 Aug 2005 10:58:01 GMT

Great - thanks - it solved the problem.

Elvez

Re: Alter Table Not Possible

bjorn-henrik_zink — Thu, 25 Aug 2005 12:16:01 GMT

How do I delete the table entry? (I get the same error as mentioned above)

Thanks.

Re: Alter Table Not Possible

Former Member — Thu, 25 Aug 2005 12:24:12 GMT

I can't understand what you want to delete

Re: Alter Table Not Possible

bjorn-henrik_zink — Thu, 25 Aug 2005 12:27:49 GMT

I want to delete the database field 'quantity' that I just created

Re: Alter Table Not Possible

Former Member — Thu, 25 Aug 2005 12:31:47 GMT

You place cursor on field you want to delete, so push icon 'CUT'

Re: Alter Table Not Possible

bjorn-henrik_zink — Thu, 25 Aug 2005 12:33:45 GMT

When I activate the database I receive the following message:

TABL TABNAME was not activated

Check table TABNAME

Table is not yet classified

Field QUANTITY was deleted

ALTER TABLE is not possible

Structure change at field level (convert table TABNAME)

Check on table TABNAME resulted in errors

Re: Alter Table Not Possible

Former Member — Thu, 25 Aug 2005 12:38:02 GMT

You try to use DATABASE UTILITY to activate the database, go to UTILITIES->DATABASE UTILITY, so choose DIRECT and push ACITVATE and ADJUST DATABSE

Re: Alter Table Not Possible

bjorn-henrik_zink — Thu, 25 Aug 2005 12:45:10 GMT

Thanks that did the trick.

Re: Alter Table Not Possible

Former Member — Thu, 25 Aug 2005 13:04:57 GMT

TABL TABNAME was not activated

Check table TABNAME

Table is not yet classified

Field QUANTITY was deleted

ALTER TABLE is not possible

Structure change at field level (convert table TABNAME)

Check on table TABNAME resulted in errors

You have changed the structure your, so now you have to convert table. You can do that by only DATABASE UTILITY, if it fails, probably there is a problam in database table. You can try to delete database table and then re-created it.