topic Re: Deleting table in Application Development and Automation Discussions

Deleting table

Former Member — Tue, 08 Dec 2009 11:34:26 GMT

Hi Experts,

I created a custom table succesfully with few fields. Now, in the same table I was trying to change the data type of a field. It throwed error even after adjusting the table. So I deleted the table and tried to create it again. But its again throwing error though all the data entered are correct.

Error: No nametab exists. (problem in technical settings. Its says, technical settings is inconsistent, but im not able to see anything in log). => I have given proper enhancement category, size category, delivery class,...

I think the problem is, since I deleted it once, its not letting me to create it again. When I populated the same data into another new table and tried, the new table got created without any error. I also removed this table from wherever it was used and deleted and created once again. Still throwing error.

Please help!!

Re: Deleting table

Former Member — Tue, 08 Dec 2009 11:42:09 GMT

Hi!

Try creating the table with only 1 field, like MANDT. Enter the technical data and then activate it.

If you could activate it, then you can add the other fields.

If you can't activate it, then you have to search for OSS notes with the error number or the error message.

Regards

Tamá

Re: Deleting table

Former Member — Tue, 08 Dec 2009 11:53:48 GMT

Hi,

No impact. Its still throwing the same error.

Re: Deleting table

Former Member — Tue, 08 Dec 2009 12:21:16 GMT

I think the OSS Note 306296 is just for you:

https://service.sap.com/sap/support/notes/306296

Regards

Tamá

Re: Deleting table

Former Member — Tue, 08 Dec 2009 12:21:23 GMT

hi gomathy,

if ur table is activated and if it contains records , then sap doesn't allow you to change the data type .

So if u want to change the data type then u have to delete all the records . then try changing the datatype

Re: Deleting table

Kanagaraja_L — Tue, 08 Dec 2009 12:47:17 GMT

What is the Delivery class type? Is it 'A (Application table (master and transaction data))' ?

Can you try with Delivery class - A.

Re: Deleting table

Former Member — Tue, 08 Dec 2009 13:06:41 GMT

Hi,

Im trying to use the oss note 306296 given by Tamás. In that, the statement 'drop table tabname' is giving a dump.

It says 'An SQL error occurred when executing Native SQL.'

sorry, the other solutions are not working. The delivery class is already 'A'.

Re: Deleting table

Former Member — Tue, 08 Dec 2009 13:17:41 GMT

I think this will be some kind of basis relevant problem, and on database level the table could be deleted.

Or maybe you can use a different table name and forget this bugged one.

Regards

Tamás

Edited by: Tamás Nyisztor on Dec 8, 2009 2:17 PM

Re: Deleting table

Kanagaraja_L — Tue, 08 Dec 2009 13:33:51 GMT

Are you deleted from SE11 or SE14 ?

Have tried to delete from SE14 and Try

Re: Deleting table

Former Member — Wed, 09 Dec 2009 06:20:08 GMT

Hi All,

I tried everything. Nothing worked. Dont know why it repeatedly kept giving the error. So changed the table name.

Thanks for the help.