snntax Error is coming in My table

[Former Member]

hi this is kumar ,

in my table press CTRL+F2.

these errors are coming .

ie. is

Check table NRIV (ABAP1/09.03.07/11:35)

Table is not yet classified

Primary key change not permitted for value table NRIV

Old key field FROMNUMBER is now non-key field

Structure change at field level (convert table NRIV)

Check on table NRIV resulted in errors.

please tell me ..its very urgent.

[Former Member]

Hi,

Go to se14,give table name, press activate & adjust database.

Now try activating your table from se11.Think u must have changed the primary key.

Regards,

Viji

[Former Member]

In SE11 itself goto UTILITIES--> DATABASE UTILITY (SE14) then there click adjust and activate.... ur table will get activated...

U might have deleted the primary key....

and regarding the check on NRIV table..

Check the data element of this field and the data element of the field in the NRIV table for which u r creating a foreign key relation... The two data elements should be the same and their domains also.. check that..!!

reward helpful answers...

sai ramesh

[Former Member]

hi Srinivas,

Go to SE14 and press button active and adjust database button to avoid errors ..

Regads,

Santosh

[Former Member]

Hi srinivas,

1. Looking to the error, it seems

u are trying to modify the standard sap table NRIV,

which is not generally allowed.

2. U have changed the primary key of the table.

3. Hence, on activation, it will give this error.

So open SE14, and enter the table name,

and Activate & Adjust from there.

regards,

amit m.