topic minimum value in Application Development and Automation Discussions

minimum value

Former Member — Thu, 11 May 2006 12:43:53 GMT

Hi all,

I have 2 values,

a = 2300.

b = 2700.

I want to find the minimum value of this 2 by using "Min" function can you tell me the syntex.

Re: minimum value

Former Member — Thu, 11 May 2006 12:45:51 GMT

hii

use less than

if (a < b)

write:/ a ,is minimum .

else.

write:/ b ,is minimum .

hope this helps

Thanks& Regards

Naresh

Re: minimum value

Simha_ — Thu, 11 May 2006 12:48:11 GMT

Hi u dont have seperately 'MIN' function.

But u can have aggregate function to be used in the select statement.

If u want which is smaller.

U can use.

If a>b.

Write: b 'is minimum'.

endif.

cheers

simha.

Re: minimum value

Former Member — Thu, 11 May 2006 12:48:17 GMT

if u want the syntax is

MIN( [DISTINCT] fdescriptor )

check this code


DATA: name     TYPE scustom-name, 
      postcode TYPE scustom-postcode, 
      city     TYPE scustom-city, 
      min      TYPE sbook-loccuram. 

SELECT scustom~name scustom~postcode scustom~city 
         MIN( sbook~loccuram ) 
       INTO (name, postcode, city, min) 
       FROM scustom INNER JOIN sbook 
         ON scustom~id = sbook~customid 
       WHERE sbook~fldate BETWEEN '20010101' AND '20011231' AND 
             sbook~carrid   = 'LH '                         AND 
             sbook~connid   = '0400' 
       GROUP BY scustom~name scustom~postcode scustom~city 
       ORDER BY scustom~name. 
  WRITE: / name, postcode, city, min. 
ENDSELECT.

Re: minimum value

vinod_gunaware2 — Thu, 11 May 2006 12:49:31 GMT

Use the following logical operators to compare two data objects with different data types:

Meaning

equal to

not equal to

less than

less than or equal to

greater than

greater than or equal to

regards

vinod

Re: minimum value

Former Member — Thu, 11 May 2006 12:49:53 GMT

Hi Manankumar,

Create your own Z function module.To the Function module give two values as Import parameters and Get the minimum value as Export Parameter.

The code for Function module as follows.

FUNCTION ZMINMUM.

*"----

""Local Interface:

*" IMPORTING

*" REFERENCE(I_VALUE1) TYPE I

*" REFERENCE(I_VALUE2) TYPE I

*" EXPORTING

*" REFERENCE(E_MIN) TYPE I

*"----

if i_value1 < i_value2.

e_min = i_value1.

else.

e_min = i_value2.

endif.

ENDFUNCTION.

Assign function module to a Function group.

Thanks,

Vinay

Re: minimum value

Former Member — Thu, 11 May 2006 12:58:47 GMT

GOOD

THE SYNTAX IS

MIN( [DISTINCT] col)

IT RETURNS THE MINIMUM VALUE IN THE COLUMN COL.

THANKS

MRUTYUN

Re: minimum value

Former Member — Thu, 11 May 2006 13:04:40 GMT

u have create your z fun.

pass 2 values to it.

return minimun value from it.

u can calculate min value using,

if a < b.

min = a.

else.

min = b.

endif.