Deleting table

[Former Member]

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!!

[Former Member]

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á

[Former Member]

Hi,

No impact. Its still throwing the same error.

[Former Member]

I think the OSS Note 306296 is just for you:

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

Regards

Tamá

[Kanagaraja_L]

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

Can you try with Delivery class - A.

[Former Member]

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

[Former Member]

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'.

[Former Member]

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

[Kanagaraja_L]

Are you deleted from SE11 or SE14 ?

Have tried to delete from SE14 and Try

[Former Member]

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.