Primary key deletion in custom database table

[Former Member]

hi,

I've created a ztable.In which i've have created primary key and foreign key.

I've activated the table.Now my requirement is that i want to delete the primary key as i've shoosen wrong field as primary key.

For that first of all i deleted the foreign key relationship than i have unchecked the primary key but it is giving me an error.

even though if i deleted that field having primary key it is also giving me error as "Primary key change not permitted for value table.

Please help me out if possible.

waiting for ur response.

Thanks,

Dheeraj

[Former Member]

first check and see that no active abap object is using your ztable

then change the key fields and go to se14 to activate it

[Former Member]

Make sure u dont have any data in the table..u have to delete all the data..Also make sure you are not using that table any where else.do a where used list in the table.

[Former Member]

Hi muhammad,

How to use where used list in table.Please tell me

Thanks.

Dheeraj.

[Former Member]

IN SE11 TYPE TABLE NAME, LOCATE ICON WHERE USED IN APPLOCATION TOOL BAR, CHECK ALL CHECKBOXES AND EXECUTE