Abap Group By
REPORT zabap_gui.
DATA:
ebeln TYPE
ekpo-ebeln,
po_max TYPE p DECIMALS
2,
po_min TYPE p DECIMALS
2,
tq_max TYPE p DECIMALS
2,
tq_min TYPE p DECIMALS
2.
WRITE:/ 'PO
No',
15 'Max
PO Quantity',
35 'Min
PO Quantity',
55
'Max Target',
70 'Min
Target'.
SELECT ebeln
MAX( menge ) MIN(
menge )
MAX( ktmng ) MIN(
ktmng )
FROM ekpo
INTO (ebeln,
po_max, po_min,
tq_max, tq_min)
GROUP BY ebeln.
WRITE:/ ebeln,
15 po_max,
35 po_min,
55 tq_max,
70 tq_min.
ENDSELECT.
Serkan AKKAVAK
Computer Engineer
ABAP Developer & SAP MM SD Consultant
Contact : serkurumsal@yandex.com
Social Plugin