topic Re: snntax Error is coming in My table in Application Development and Automation Discussions

snntax Error is coming in My table

Former Member — Fri, 09 Mar 2007 06:11:12 GMT

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.

Re: snntax Error is coming in My table

Former Member — Fri, 09 Mar 2007 07:23:31 GMT

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

Re: snntax Error is coming in My table

Former Member — Fri, 09 Mar 2007 08:30:18 GMT

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

Re: snntax Error is coming in My table

Former Member — Fri, 09 Mar 2007 08:37:50 GMT

hi Srinivas,

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

Regads,

Santosh

Re: snntax Error is coming in My table

Former Member — Fri, 09 Mar 2007 09:14:00 GMT

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.