select x.“Payback period in year” from TOP_INVESTMENTS x

works.

There is no error in HANA table,

it is an “error” from Toad.

THE FIRST SCRIPT RUNS IN HANA STUDIO, SAME DATABASE, SAME TABLE, SAME USERNAME.

I changed the script now into:

select

case

when ( x.“Payback period in year” between 0.01 and 1.5 ) then ‘1’

when ( x.“Payback period in year” between 1.51 and 2.5 ) then ‘2’

when ( x.“Payback period in year” between 2.51 and 3.5 ) then ‘3’

when ( x.“Payback period in year” between 3.51 and 4.5 ) then ‘4’

when ( x.“Payback period in year” between 4.51 and 5.5 ) then ‘5’

when ( x.“Payback period in year” between 5.51 and 6.5 ) then ‘6’

else ‘x’

end as “Payback (y)”,

x.“CAPEX (in kEUR)” / 1000 as “Project costs (Mio. € )”

from TOP_INVESTMENTS x

where

case

when ( x.“Payback period in year” between 0.01 and 1.5 ) then ‘1’

when ( x.“Payback period in year” between 1.51 and 2.5 ) then ‘2’

when ( x.“Payback period in year” between 2.51 and 3.5 ) then ‘3’

when ( x.“Payback period in year” between 3.51 and 4.5 ) then ‘4’

when ( x.“Payback period in year” between 4.51 and 5.5 ) then ‘5’

when ( x.“Payback period in year” between 5.51 and 6.5 ) then ‘6’

else ‘x’ end != ‘x’

and everything is fine.

Holger