how to select latest 3 record for each id
code :
SELECT
A~OPBEL
A~XBLNR
A~VKONT
A~FAEDN
A~ABRZU
E~COKEY
A~WAERS
SUM( A~BETRW ) AS AMOUNTX ,
e~VERTRAG
INTO TABLE @IT_TABLE
FROM DFKKOP AS A
INNER JOIN EVER AS E
ON A~VKONT = E~VKONTO
WHERE
E~COKEY IN @SO_DIST
AND A~VKONT IN @CUSTNO AND A~HVORG IN ('0100','MCON') AND A~AUGST <> 9
AND A~ABWKT = @SPACE
GROUP BY A~OPBEL ,A~XBLNR , A~VKONT , A~FAEDN ,A~ABRZU , E~COKEY,A~WAERS , e~VERTRAG
HAVING SUM( A~BETRW ) <> 0
ORDER BY A~VKONT ,
A~ABRZU DESCENDING .
"ORDER BY A~VKONT , A~FAEDN
LOOP AT IT_TABLE ASSIGNING FIELD-SYMBOL(<QUAN_A>) .
MOVE-CORRESPONDING <QUAN_A> TO WA_TABLE.
WA_TABLE-AMOUNTX = <QUAN_A>-AMOUNTX / 10 .
.
WA_TABLE-VERTRAG = sy-TABIX .
APPEND WA_TABLE TO LIST.
ENDLOOP.

s for each id