topic Re: SQL error in the database when accessing a table. in Application Development and Automation Discussions

SQL error in the database when accessing a table.

Former Member — Wed, 01 Oct 2008 04:27:22 GMT

i have a ztable with 32 fields i am adding one more field to the ztable

as CURR 20(2) but i am geeting following dump in se11 as well as on select query.

*One of the columns addressed in a table or view

does not exist in the database.

table) exists in the ABAP/4 Dictionary, but not in

the database.*

i have adjusted and activated the table from se14

regards

vivek

Re: SQL error in the database when accessing a table.

Former Member — Wed, 01 Oct 2008 04:39:45 GMT

Hi,

R u set technical setting setting in ur table?

Regards:

Prabu

Re: SQL error in the database when accessing a table.

Former Member — Wed, 01 Oct 2008 04:46:40 GMT

its already there

data class APPL0

size category 6

others as default

let me know do i have to change something there..or may be un enhancement category...

regards

vivek

Re: SQL error in the database when accessing a table.

Former Member — Wed, 01 Oct 2008 04:48:15 GMT

hai,

sometime it will take time there is no problem.

try to reactivate the table ,that is enough.

shan.

Re: SQL error in the database when accessing a table.

Former Member — Wed, 01 Oct 2008 04:50:58 GMT

hi...

i did that yesterday and its still not working.....

regards

vivek

Re: SQL error in the database when accessing a table.

Former Member — Wed, 01 Oct 2008 04:53:02 GMT

Hi,

If you are having any table maintanance or view just delete and then recreate. before that just activate the table once again and then do.

Re: SQL error in the database when accessing a table.

Former Member — Wed, 01 Oct 2008 04:55:03 GMT

no table maintance or view exist for the table

regards

vivek

Re: SQL error in the database when accessing a table.

Former Member — Wed, 01 Oct 2008 04:56:31 GMT

Hi vivek,

Hv u tag the reference field to the Curr field.

Check that one.

thanks

Re: SQL error in the database when accessing a table.

Former Member — Wed, 01 Oct 2008 04:57:47 GMT

yes its done ..otherwise it gives syntax error.

regards

vivek

Re: SQL error in the database when accessing a table.

Former Member — Wed, 01 Oct 2008 05:16:21 GMT

Hi Vivek,

This is strange. Goto DB21. Position your Ztable and press Details button.

In the Statistics settings and ToDo Settings check what is the date in 'Changed on'?

Also check whether the Active flag as 'A'.

If all these are ok then you can check with Basis people on what is wrong in Database

Cheers,

Kothand

Re: SQL error in the database when accessing a table.

Former Member — Wed, 22 Oct 2008 10:51:49 GMT

i created a new table only...and its working in that...