Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

data dictionary

Former Member
0 Likes
688

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.

1 ACCEPTED SOLUTION
Read only

pradiptakumar_mishra
Participant
0 Likes
676

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

5 REPLIES 5
Read only

RemiKaimal
Active Contributor
0 Likes
676

Hi,

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

Cheers,

Remi

Read only

Former Member
0 Likes
676

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

Read only

Former Member
0 Likes
676

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.

Read only

pradiptakumar_mishra
Participant
0 Likes
677

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

Read only

Former Member
0 Likes
676

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.