topic Re: Roundong Function Module in Application Development and Automation Discussions

Roundong Function Module

arvind_soni — Wed, 29 Nov 2006 05:58:01 GMT

Hi,

Is there any function module in SAP for rounding of the numbers e.g if 100.91 is passed it should show 101.00.

Thanks in advance

Arvind

Re: Roundong Function Module

anversha_s — Wed, 29 Nov 2006 05:58:50 GMT

hi,

use

ceil

eg:

lold = 99.8.

lnew = ceil( lold ).

write lnew.

rgds

Anver

Re: Roundong Function Module

jayanthi_jayaraman — Wed, 29 Nov 2006 06:04:17 GMT

Hi,

DATA n TYPE p DECIMALS 2.

DATA m TYPE p DECIMALS 2 VALUE '-5.55'.

n = ceil( m ). WRITE: / 'CEIL: ', n.

The output appears as follows:

CEIL: 5.00-

Re: Roundong Function Module

arvind_soni — Wed, 29 Nov 2006 06:06:55 GMT

Anver ,

Can you tell me what should be syntax.

Thanks

Re: Roundong Function Module

anversha_s — Wed, 29 Nov 2006 06:08:47 GMT

hi,

DATA: ws_data TYPE p VALUE '9.90',
ws_data1 TYPE p.

ws_data1 = CEIL( ws_data ).

WRITE ws_data1.

rgds

Anver

Re: Roundong Function Module

Former Member — Wed, 29 Nov 2006 06:08:48 GMT

use abs r ceil

check this example...

DATA: I TYPE I,

P TYPE P DECIMALS 2,

M TYPE F VALUE '-3.5',

D TYPE P DECIMALS 1.

P = ABS( M ). " 3,5

I = P. " 4 - business rounding

I = M. " -4

I = CEIL( P ). " 4 - next largest whole number

I = CEIL( M ). " -3

I = FLOOR( P ). " 3 - next smallest whole number

I = FLOOR( M ). " -4

I = TRUNC( P ). " 3 - integer part

I = TRUNC( M ). " -3

D = FRAC( P ). " 0.5 - decimal part

D = FRAC( M ). " -0.5

check this link

-charitha

Re: Roundong Function Module

gopi_narendra — Wed, 29 Nov 2006 06:09:26 GMT

CEIL itself is teh syntax

VAR1 = CEIL(VAR).

wat a CEIL does is - it gives the smallest integer number that is not smaller than the value of the argument arg.

Regards

- Gopi

Re: Roundong Function Module

arvind_soni — Wed, 29 Nov 2006 06:32:35 GMT

Hi,

DATA n TYPE p DECIMALS 2.

DATA m TYPE p DECIMALS 2 VALUE '5.25'.

n = ceil( m ). WRITE: / 'CEIL: ', n.

and the output is shown as ' 6.00' but it should be '5.00'.

Please let me know if any other method is there .

Re: Roundong Function Module

jayanthi_jayaraman — Wed, 29 Nov 2006 06:38:39 GMT

Hi,

It will return the lowest value.SInce 5 is less than 6,output is 5.

If you use floor ( 5.25 ),that will return you 6.But that will be the output even if you give floor (5.75).

You need to do manual programming.

Function

Result

abs

Absolute value of argument.

sign

Prefix of the argument : 1 x > 0

SIGN( x ) = 0 if x = 0

-1 x < 0

ceil

Smallest integer value not smaller than the argument.

floor

Largest integer value not larger than the argument.

trunc

Integer part of argument.

FRAC

Fraction part of argument.

Re: Roundong Function Module

anversha_s — Wed, 29 Nov 2006 06:41:48 GMT

hi jayathi,

a small correction in ur post.

floor -> give the lower round value.

5.5 -> 5

ciel -> give the highr rounded value.

5.5 -> 6.

keep doing the helps

rgds

Anver.