Skip to Content
0
May 18, 2020 at 07:51 PM

how to select latest 3 records for each id

110 Views

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

Attachments

id.jpg (253.6 kB)