topic Re: decimal point conversion in Application Development and Automation Discussions

decimal point conversion

Former Member — Thu, 10 Jan 2008 17:21:43 GMT

hi,

How to remove decimal points. The field in my program is a quantity field. In the o/p list display it is displayed as for example as 24,000.00. But i dont want to display .00(decimal point) it should be displayed as 24,000.

How to do this. Is there anyway to do this plz help me out.

Re: decimal point conversion

Former Member — Thu, 10 Jan 2008 17:23:54 GMT

If it is NOT ALV...


WRITE  itab-menge DECIMALS 0.

Re: decimal point conversion

Former Member — Thu, 10 Jan 2008 17:32:31 GMT

Hi Ramya,

You can use the Function Module 'MURC_ROUND_FLOAT_TO_PACKED'.

Or you can also use the following code to round up:

DATA: num1 TYPE f, num2 TYPE p.

num1 = '1.666666'.

num2 = num1.

WRITE num2.

Reward points if helpful..

Regards,

Goutham.

Re: decimal point conversion

Former Member — Thu, 10 Jan 2008 17:35:02 GMT

its an alv report so how to suppress the decimal points.suggest me

Re: decimal point conversion

Former Member — Thu, 10 Jan 2008 17:40:14 GMT

in field catalogue you can do like this...


fieldcatalog-fieldname   = 'MENGE'.
fieldcatalog-seltext_m   = 'PO quantity'.
fieldcatalog-decimals_out   = 0.

another way in internal table declaration...you change like this..


*menge LIKE itab-menge.  
menge(16) TYPE p DECIMALS 0.

Re: decimal point conversion

Former Member — Thu, 10 Jan 2008 17:40:17 GMT

Hi Ramya,

Check this out..

http://help.sap.com/saphelp_erp2004/helpdata/en/ff/4649a6f17411d2b486006094192fe3/content.htm

Reward points if helpful..

Regards,

Goutham.

Re: decimal point conversion

Former Member — Thu, 10 Jan 2008 17:50:59 GMT

hi,

Actually the quantiy field which i am using in the program is

msl like zupi5t-msl "quantity

data type of this field is QUAN.

the values in the zupi5t table are with decimal points as

720.000-, 50,059.000-, 94.000- etc.

Now how can i suppress the decimal point so that i can display the o/p as 720, 50,059, 94.

The fn module which u mentioned MURC_ROUND_FLOAT_TO_PACKED how to pass the parameters.Is this is useful in my case?

plz suggest i need this urgently.

Re: decimal point conversion

Former Member — Thu, 10 Jan 2008 18:02:33 GMT

Hi Ramya,

DATA: num1 TYPE f value '19567.468323'.

num2 TYPE p .

(using 'Pattern' button which is beside 'pretty printer' button, call the function..)

CALL FUNCTION 'MURC_ROUND_FLOAT_TO_PACKED'

EXPORTING

if_float = num1

IF_SIGNIFICANT_PLACES = 15

IMPORTING

EF_PACKED = num2

write num2.

Reward points if helpful..

Regards,

Goutham.

Re: decimal point conversion

Former Member — Thu, 10 Jan 2008 18:43:21 GMT

Hi Ramya,

Here is a sample code to remove the decimals:

data: test type p decimals 2 ,

test1 type p.

test = '24000.00'.

test1 = test.

write test1.

Here test1 is declared of type p with no decimals.

So when test is moved into test1,the decimals are automatically removed.

Reward if helpfull.

Thanks,

Kashyap

Re: decimal point conversion

Former Member — Fri, 11 Jan 2008 07:23:19 GMT

hi perez,

u solved my issue. Thank u very much.