Determine max / min value of internal table column with REDUCE

• on 30 Oct 2020
• By Attila Berencsi
• ABAP

Determine max / min value of internal table column with REDUCE

It comes handy, when you need to allocate the next item number of a document. The task is always to get the highest number first.

DATA:
  po_items	TYPE STANDARD TABLE of ekpo.
	  
DATA(max_num) = REDUCE numc5( INIT res = '00000'  FOR line IN po_items
	NEXT res = COND #( WHEN line-ebelp > res THEN line-ebelp ELSE res ) 
).

You can also get the lowest number, the complexity of comparison is up top You to do something different with a particular column. Here the focus is on the new REDUCE statement.

Applicable in NW 7.5 and onwards.