Column name and Table Name can they be same?

Hi Experts,

I am learning on Join types is SAP HANA Modeling.

Created a "State" table with State and Sname as below

State

State Sname

MI MICHIGAN

AL ALABAMA

Now when I am writing a SQL SELECT Sname from "State" , It is working fine. But when I give

Select State from "State" it is saying invalid column name.

So if table name and Column cannot be the same why is it allowing while creating the table.(I uploaded a csv file data and created this table)

Am I missing some settings/some thing some where. Searched for this error but didn't get any answer. hence posting it.

Thanks in Advance.

Regards,

Archana