SQL error in the database when accessing a table.

[Former Member]

Hi

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

[Former Member]

Hi,

R u set technical setting setting in ur table?

Regards:

Prabu

[Former Member]

hi

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

[Former Member]

hai,

sometime it will take time there is no problem.

try to reactivate the table ,that is enough.

shan.

[Former Member]

hi...

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

regards

vivek

[Former Member]

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.

[Former Member]

hi

no table maintance or view exist for the table

regards

vivek

[Former Member]

Hi vivek,

Hv u tag the reference field to the Curr field.

Check that one.

thanks

[Former Member]

hi

yes its done ..otherwise it gives syntax error.

regards

vivek

[Former Member]

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

[Former Member]

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