According to Microsoft’s description of [global temporary tables](https://learn.microsoft.com/en-us/sql/relational-databases/tables/tables?view=sql-server-ver16#temporary-tables), “… they are deleted when all users referencing the table disconnect from the instance of SQL Server”. Therefore, I would recommend using an SQL server view instead of a global temporary table in order to safely import the stored procedure when creating the desired base view.
Other useful checks would be to :
1. Test the connection to the underlying MSSQL server data source.
2. Verify if subject table/view exists in the underlaying data source and whether users using the base view have Execute privileges.
3. Verify if subject table/view can be accessed using other platforms (e.g., DBVisualiser).
For further guidelines, please check the [Creating views using SQL server procedures and functions](https://community.denodo.com/kb/en/view/document/Creating views on SQL Server Functions and Stored Procedures) KB article.
If the issue persists and you have a valid support account, create a support case in Denodo Support Site to further assist in resolving this issue.
Hope this helps!