topic Re: Function Module in Application Development and Automation Discussions

Function Module

Former Member — Mon, 04 Dec 2006 07:13:53 GMT

Hi all,

I have a Z table with a field with numeric values.

I need to get the highest value from that field.

I feel it'll be a performance issue to select all records & search the highest value by looping.

So, does anyone know any function module which does the same..?

Re: Function Module

Former Member — Mon, 04 Dec 2006 07:18:03 GMT

You can select all the records into an internal table and then sort the internal table on the numeric field descending.

Regards

Mohamed Mansoor

Re: Function Module

Former Member — Mon, 04 Dec 2006 07:18:10 GMT

1. SELECT using ORDER BY clause into Table directly and read the first entry

2. SELECT into a SORTED Table directly and read the first entry

3. SELECT into a table, SORT manually using SORT command and then read the first entry.

SORT has to happen by the field you are looking for.

Regards,

Ravi

Note - Please mark all the helpful answers

Re: Function Module

amit_khare — Mon, 04 Dec 2006 07:18:20 GMT

Hi,

you may use Select with MAX.

SELECT MATNR MAX(mblnr) into table itab

from mseg

group by matnr

where matnr in s_matnr.

Regards,

Amit

Re: Function Module

Former Member — Mon, 04 Dec 2006 07:19:02 GMT

Hi,

Select MAX( <col> ) INTO lv_max

FROM ztable.

DATA: lv_max TYPE ztable-<col>.

Regards,

Goutham

Re: Function Module

Former Member — Mon, 04 Dec 2006 07:19:51 GMT

hi,

Select all entries of Z table to an internal table.

Sort itab in the descending fashion wrt the field you are looking for highest value

Then you can read the itab with index 1 and that is the highest value of that particular field

Re: Function Module

h_senden2 — Mon, 04 Dec 2006 07:22:02 GMT

Just use a select statement like :

select max( seatsmax ) into l_max from sflight.

Re: Function Module

Former Member — Mon, 04 Dec 2006 07:25:10 GMT

use aggregate function while selecting....