with cte 
 (
		[HYPE_CODE_PR]
      ,[HYPE_CODE]
      ,[HYPE_ALIAS]
      ,[parent_name]
      ,[mvz_name]
      ,[alias_name], lev
 ) as 
 (
 select 
 		[HYPE_CODE_PR]
      ,[HYPE_CODE]
      ,[HYPE_ALIAS]
      ,[parent_name]
      ,[mvz_name]
      ,[alias_name], 0 as lev from  
      [HYP_DS_TOPDOWN].[dbo].[entity_hier] eh where HYPE_CODE='MAGNIT'
      union all
       select 
 		eh1.HYPE_CODE_PR
      ,eh1.HYPE_CODE
      ,eh1.HYPE_ALIAS
      ,eh1.parent_name
      ,eh1.mvz_name
      ,eh1.alias_name, eh2.lev+1
      from 
      [HYP_DS_TOPDOWN].[dbo].[entity_hier] eh1 
      inner join cte eh2 on eh1.HYPE_CODE=eh2.HYPE_CODE_PR
 )
 select * from cte

   inner join cte eh2 on eh1.HYPE_CODE_PR=eh2.HYPE_CODE