Table function

If you want to obtain data from a Table-valued Function in your database, you can create a view that queries the function, and set a data type / data store up on the view, same way as you would for a normal table. 

I do this in one scenario where a report is generated by a function that creates/returns a temporary table, ended up being better for performance this way in my scenario, where lots of data is aggregated for a weekly summary.

CREATE view [dbo].[VIEW_FROM_FUNCTION]
as

select 
[Col1],
[Col2]
/*etc*/
from dbo.fn_YOUR_TABLE_VALUED_FUNCTION()

GO

I am getting the error while creating new Data type

Did you try to follow the advised steps in the error message?

Did you try to follow the advised steps in the error message?