topic Re: No Decimals in Application Development and Automation Discussions

No Decimals

Former Member — Fri, 13 Aug 2010 05:38:23 GMT

hello masters,

is there any option to remove decimals from alv report output. (in my report i am using collect ,but there are some fields that no need decimals thats what i want to remove it.)

Thanks & Regards

Atul

Re: No Decimals

Former Member — Fri, 13 Aug 2010 05:47:48 GMT

Hi,

While building your fieldcat, put option of decimals_out = 0.

hope it helps,

regards,

Re: No Decimals

Former Member — Fri, 13 Aug 2010 06:03:42 GMT

dear Thien,

i tried this LS_CAT-DECIMALS_OUT = 0. earlier but it was not working

Re: No Decimals

Former Member — Fri, 13 Aug 2010 06:11:47 GMT

Hello


LS_CAT-DECIMALS_OUT = '0'. " <- with single quotes

Re: No Decimals

Former Member — Fri, 13 Aug 2010 06:17:43 GMT

i'm using dinamic internal table with currency field. if any possibility then pls revert me.

thnx

Atul

Re: No Decimals

RaymondGiuseppi — Fri, 13 Aug 2010 06:18:31 GMT

DECIMALS_OUT is relevant if no currency field is assigned to the field and CURRENCY is not set, else it should work.

Regards,

Raymond

Re: No Decimals

Former Member — Fri, 13 Aug 2010 06:20:50 GMT

Dear Dzed,

i tried with this also LS_CAT-DECIMALS_OUT = '0'. " <- with single quotes

Re: No Decimals

Former Member — Fri, 13 Aug 2010 06:23:00 GMT

dear Raymond,

I'm using currency field. so in curr field there is no option to remove decimals.

Re: No Decimals

Former Member — Fri, 13 Aug 2010 06:28:24 GMT

Hi,

Define one varibale type as CHAR and pass the currency field to thet variable.

pass theis varibale to ALV report.

Decimals will not appaer in teh output report.

Regards,

Pravin

Re: No Decimals

RaymondGiuseppi — Fri, 13 Aug 2010 06:30:22 GMT

Internally the currency field give the externa format, so you could only remove decimal if you change the datatype for 'DEC' or similar type (but the ALV wont now give you a subtotal per currency code)

Regards,

Raymond

Re: No Decimals

Former Member — Fri, 13 Aug 2010 06:31:09 GMT

Hi,

Declare one more field TYPE I and move that value to the new field or use FM ROUND

Regards,

Selva

Re: No Decimals

Former Member — Fri, 13 Aug 2010 06:55:03 GMT

Hi Atul,

Normally, we will refer the currency to get the correct decimal places. For eg: INR - 2 decimal, JPY - 0 decimal...

So it is not possible to hide the decimal places by referring the currency.

Also, if we are not referrering the currency, wrong value may come. For instance, in the SAP table the value will be stored as 12.00 but the actual value should be 1200 JPY.

So do as below,

Get the decimal place from the table 'TCURX' for your currency.

Create a P type variable with 2 decimals, let g_x.

Then g_x = value * 10^(2 - n), where n is the decimal place.

then write the value TO A CHAR FIELD as,

write g_x to g_c no decimals.

the assign the same to the alv internal table. Please remove the currency reference.

It shall work. Please try.

Regards,

Selva K.

Re: No Decimals

Former Member — Wed, 24 Nov 2010 05:01:00 GMT

Self answered, by taking datatype fieldcatlog

is DEC.

e.g.: ls_cat-datatype = 'DEC'.