topic Re: how to delete a customize table in Application Development and Automation Discussions

how to delete a customize table

Former Member — Wed, 29 Nov 2006 10:31:45 GMT

HI,

I need to delete a customize table . But while trying to delete the table it's showing a message " Still used in dictionary. can't delete'. because this table is used by some programs and search helps. How to delete the table?

Thanks & regards

sandeep

Re: how to delete a customize table

Former Member — Wed, 29 Nov 2006 10:40:43 GMT

Hi Venu,

Do where use list for this table and delete/replace every where its been used.

Hope this helps.

Manish

Re: how to delete a customize table

Former Member — Wed, 29 Nov 2006 10:41:16 GMT

hi,

comment out the program lines using the particular table.

You can find the list of programs using Where used list.

Once the program lines are commented out or deleted, you can continue with deleting your table

Re: how to delete a customize table

Former Member — Wed, 29 Nov 2006 11:04:01 GMT

it might be that this table is been used in programs/sub routinues/ FM etc....Go to SE11 & specify the table name & check where all this table has been used & goto that particular code and either comment the code or delete the code...After everything is done, U can delete the customized table from database.

Re: how to delete a customize table

Former Member — Wed, 29 Nov 2006 11:13:37 GMT

if you want to forcefully delete the table without commenting the program line,

when the pop-up giving the message , don't click on ok tick , c

lick on trash icon,it will delete the table.

Re: how to delete a customize table

Former Member — Wed, 29 Nov 2006 12:16:25 GMT

Thanks for ur rely! but deletion of table is only possible when it refer to nothing or refers to only abap programs . Because my program refers to some search helps and screens and programs i am not able to delete it. Even in SE56 and SE57 showing the same message.

Is there any way to delete the table with out affecting the programs and search help( without commenting the part of programs that uses tha table and deleating the search help).

Is it possible to create anather customize with same attribute and fields and replacing the new table with old table.

Thanks @ Regards

sandeep

Re: how to delete a customize table

Former Member — Wed, 29 Nov 2006 14:49:41 GMT

Please do a where used list on the table

then it will show u the list of object useing this table.

Then remove the code or the table name from the code.

after u remove this u can delete the code.

Point if it help u.

Regards

Lakshmikanth.t.v

Re: how to delete a customize table

Former Member — Thu, 30 Nov 2006 05:30:11 GMT

Hi Venugopal,

seems like your query is answered. Kindly close your thread and reward helpful answers

Re: how to delete a customize table

Former Member — Fri, 08 Dec 2006 09:17:38 GMT

hi,

A table can ONLY be deleted if its not used by any other Programs.

To delete a table,

1) Type the name of the table in the Data Dictionary.

( With the where-used list check if this table is used in any other programs ).

2)Then choose Delete. After confirmation of deletion a dialog box tells if table still has data.