topic Re: data dictionary in Application Development and Automation Discussions

data dictionary

Former Member — Thu, 13 Mar 2008 09:31:00 GMT

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.

RemiKaimal — Thu, 13 Mar 2008 09:33:56 GMT

Hi,

In SE11, did you try doing an Utilities -> Activate and adjust Database (with Save data) ??

Cheers,

Remi

Former Member — Thu, 13 Mar 2008 09:35:46 GMT

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

Former Member — Thu, 13 Mar 2008 09:36:33 GMT

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.

pradiptakumar_mishra — Thu, 13 Mar 2008 09:36:43 GMT

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

Former Member — Thu, 13 Mar 2008 09:37:29 GMT

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.