Alter Table Not Possible

[bjorn-henrik_zink]

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

[Former Member]

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,

[bjorn-henrik_zink]

Great - thanks - it solved the problem.

Elvez

[bjorn-henrik_zink]

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

Thanks.

[Former Member]

I can't understand what you want to delete

[bjorn-henrik_zink]

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

[Former Member]

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

[bjorn-henrik_zink]

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

[Former Member]

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

[bjorn-henrik_zink]

Thanks that did the trick.

[Former Member]

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.

[athavanraja]

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

[Former Member]

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

[Former Member]

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).