Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Help for query that not work in SAP query generator.

Hi All,

I have done this request :

Select T0.slpname as 'Nom du commercial', T10.CA2008 as 'CA N-2'

FROM OSLP T0 left outer join (SELECT T11.SlpCode, sum(T11.[DocTotal]- T11.[VatSum]) as 'CA2008'

FROM ORDR T11 INNER JOIN OFPR T12 ON T11.FinncPriod = T12.AbsEntry INNER JOIN OACP T13 ON T12.Category = T13.PeriodCat

WHERE T11.DocDate>='[%0]' AND T11.DocDate<='[%1]' Group by T11.SlpCode) T10 on T0.SlpCode=T10.SlpCode

Group by T0.slpname, T10.CA2008

This work fine in SQL management studio but not in SAP with the query generator. When i'm execute this query i've got this error :

'Must specify table to select from'

Thanks for your help.

Best Regards,

Michael

Former Member
Not what you were looking for? View more on this topic or Ask a question