‎2008 Mar 13 9:31 AM
hi all,
lgort is a key field in ztable. now i want to make it as non key field.
while doing this raising error. the ztable not get activated.
pls help me out how to make that field, non key field.
best regards,
m.srinivas.
‎2008 Mar 13 9:36 AM
Hi,
After u ticked out ur field as non key field, use DB utility from Utilities in SE11 to adjust the DB structure in the under-laying database.
U have to choose activate and adjust option from there.
Rgds
Pradipta
Reward points if useful
‎2008 Mar 13 9:33 AM
Hi,
In SE11, did you try doing an Utilities -> Activate and adjust Database (with Save data) ??
Cheers,
Remi
‎2008 Mar 13 9:35 AM
Hi
change the key field and goto se14
enter the table name and select direct without deleting the existing data
this will acitvate the table
Regards
Shiva
‎2008 Mar 13 9:36 AM
Hi,
In your ztable remove primary key option save it. and come to the tcode SE14>enter ZTABLE->press butoon active and adjust the database.
‎2008 Mar 13 9:36 AM
Hi,
After u ticked out ur field as non key field, use DB utility from Utilities in SE11 to adjust the DB structure in the under-laying database.
U have to choose activate and adjust option from there.
Rgds
Pradipta
Reward points if useful
‎2008 Mar 13 9:37 AM
Hi,
Atleast you need one key field for your custom table . It should be a first field of the table.
So make any other field as a key field and then you can use the table maintanence generator for adjust and activate the table using transaction sm30.
Thanks.