Skip to Content
0
May 22, 2018 at 11:40 PM

query syntax help to show last invoice

151 Views

SELECT T0.[CardCode], T0.[CardName], T2.[Name], T2.[E_MailL], T0.[DocDate], T0.[DocNum], T1.[ItemCode], T1.[Dscription] FROM OINV T0  INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OCPR T2 ON T0.CntctCode = T2.CntctCode INNER JOIN OCRD T3 ON T0.CardCode = T3.CardCode WHERE T3.[CardFName] = '[%0]' AND T1.[Dscription] LIKE '%[%2]%'

Hi gurus, this query works, however I'd like to show only the last invoice per customer. New to SAP and sql, but I believe this is where you use DISTINCT and TOP clauses? How do I apply it?