Problemas para traer el nombre del Vendedor en sap one con base de datos sql
estimados estoy realizando una Query en donde me piden traer el nombre del vendedor pero cuando la realizo solo me trae el numero ,
seria de gran ayuda poder tener el nombre
SELECT
T4.[CardFName] AS ‘Nombre cliente fantasía’
,T0.[DocNum]
,T0.[FolioNum] AS ‘Folio Factura’
,T0.[DocDate]
,(SELECT TOP 1 X.DocNum FROM ODLN X WHERE X.DocEntry = T1.BaseEntry) ‘N° Guía’
,(SELECT X.FolioNum FROM ODLN X WHERE X.DocEntry = T1.BaseEntry) ‘Folio Guía’
,T0.[U_NPEDIDO] AS ‘Nota de venta’
,T5.[SlpName] AS ‘Vendedor’
,A.[lastName] ‘Propietario’
,T1.[ItemCode]
,T1.[Dscription]
,T3.[ItmsGrpNam] AS ‘Familia’
,T2.[U_SUB1] AS ‘SUB FAMILIA’
,T1.[Quantity]
,CAST(T1.Price as numeric (9,0)) ‘Precio tras Descuento’
,T1.[LineTotal]
,T1.[StockPrice] * T1.[Quantity] ‘Costo Total’
,(((T1.[StockPrice] * T1.[Quantity]) * (T0.[U_G_ADMIN] / 100)) + (T1.[StockPrice] * T1.[Quantity])) AS ‘Costo final’
,CAST(T1.GrssProfit as numeric (9,0)) ‘Ganancia’
,CASE T1.StockPrice WHEN 0 THEN 100 ELSE CAST((T1.Price / T1.StockPrice) as numeric (18,2)) END ‘% Ganancia’
,T0.[U_G_ADMIN]
,T0.[U_MARGEN]
,T0.[U_COMISION]
,T0.[U_COMPARTIDO] AS ‘Numero de Vendedor’
,T0.[U_NUMFACT]
FROM OINV T0
INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry]
LEFT JOIN OHEM A ON A.[empID] = T0.[OwnerCode]
LEFT JOIN OITM T2 ON T1.[ItemCode] = T2.[ItemCode]
LEFT JOIN OITB T3 ON T2.[ItmsGrpCod] = T3.[ItmsGrpCod]
LEFT JOIN OCRD T4 ON T0.[CardCode] = T4.[CardCode]
LEFT JOIN OSLP T5 ON T0.[SlpCode] = T5.[SlpCode]
WHERE T0.[DocDate] >= [%0] AND T0.[DocDate] <= [%1]