how to delete a customize table

[Former Member]

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

[Former Member]

Hi Venu,

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

Hope this helps.

Manish

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

Hi Venugopal,

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

[Former Member]

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.