Cannot select root node of hierarchy via Column View SQL

[thilo_kntzele]

Hi experts,

in our HANA Column View we do not receive any records if we select the root node of a parent-child hierarchy. Can you please tell us how to set up our hierarchy, so it also returns values for the root node?

We have set up a parent-child hierarchy with two root nodes:

If we query the view for PARENT_NODENAME = SER367, we receive two records, as expected:

However, if we query for the nodey column ST_HIER, we do not receive any results:

The node column is defined as follows: