Ok *success*, I think that I figured out the use of table UDF...
SELECT I.StockCode, I.Description, I.AlternateKey1 AS Family,
I.LeadTime, I.Ebq, W.Warehouse, U.RET AS QtyOnHandNoExcl,
W.QtyInTransit, W.QtyOnOrder, W.QtyAllocatedWip,
W.QtyAllocated AS QtyAllocatedSales, W.UnitCost, W.DateLastSale,
W.DateLastPurchase, W.UserField1 AS MINMAXCTRL, W.MinimumQty,
W.MaximumQty, W.ReOrderQty AS ReOrderPt, W.YtdQtySold,
W.PrevYearQtySold, I.Supplier, I.Version,
I.StockOnHold, I.CountryOfOrigin, I.PartCategory
FROM SysproSStar.dbo.InvMaster I INNER JOIN
SysproSStar.dbo.InvWarehouse W ON I.StockCode = W.StockCode OUTER
APPLY dbo.QtyOnHandNoExcl(W.StockCode, W.Warehouse, 'K') U;