Regarding decimals in grid output

[Former Member]

hi,

I have an issue in displaying the amount field in alv grid .

the amount fields in my output table are results of curency conversion from JPY to USD.

the conversion is done and amount is stored in the field as 19456.70 -

---

>with decimals

But when i see the output it appears without decimals 1,945,670

The target field type is Currency field with decimals 2.

Could you please suggest as to how to get decimals in output.

Thanks & Regards,

Prema

[Former Member]

Hai,

Did you use the Modify statement on work area / itab after the Conversion is made?

Best Regards,

rama

[former_member188685]

Do you know the Fieldcatalog option "decimals_out"

Use that inorder to get the required number of decimals.

[Former Member]

hi

if i set decimals_out = 2

then the output is coming as 1,945,670.00

it should display as 19,456.70

[Mohamed_Mukhtar]

Hi, Can you show us your code of fieldcatalogue??

[Former Member]

>

> hi,
> I have an issue in displaying the amount field in alv grid .
> the amount fields in my output table are results of curency conversion from JPY to USD.
> the conversion is done and amount is stored in the field as 19456.70 -
>with decimals
> But when i see the output it appears without decimals 1,945,670
> 
> The target field type is Currency field with decimals 2.
> 
> Could you please suggest as to how to get decimals in output.
> 
> Thanks & Regards,
> Prema

hi ,

You can define the fieldcatalog with the option

decimals_out ( type c length 6) .

OR

You can also define that field in the ALV list of character type.

but , in that case, you wont be able to sort that field with standard functionality.

Regards,

Rajesh

[Former Member]

Hello

In fieldcat set parameter CURRENCY = 'USD'

[Former Member]

hi,

Thanks a lot....my issue is solved

Regards,

Premalatha