topic Re: Quantity (amount) conversion as per currency in Application Development and Automation Discussions

Quantity (amount) conversion as per currency

Former Member — Fri, 05 Feb 2010 10:45:35 GMT

Dear All,

I have problem with amount conversion, my amount to be displayed in ALV should be displayed as per currency value.

Eg: Currency JPY (holds no decimals) so my amount should be displayed as 10/45/23232/56565 without decimals in ALV output. Currently it is displying amounts with 2 decimals.

So can you please suggest me the solution if you have done this already, also let me know if you need any other information.

Thanks,

Devasing

Re: Quantity (amount) conversion as per currency

Former Member — Fri, 05 Feb 2010 11:21:58 GMT

If you have more than one currencies into report add a new column with the currency and set the reference currency field of the amount field at field catalog equal with the name of currency column field. If you have only one curency set the currency field of the amount field equal to the currency

Re: Quantity (amount) conversion as per currency

Former Member — Fri, 05 Feb 2010 11:49:48 GMT

Hi,

you can use following fieldcatalog decleration.

wa_fieldcat-fieldname = 'Q_VBELN'.

wa_fieldcat-tabname = 'IT_FIANL'.

wa_fieldcat-seltext_l = 'Quotation'.

wa_fieldcat-ref_fieldname = 'WAERK'.

wa_fieldcat-ref_tabname = 'VBAP.'

Re: Quantity (amount) conversion as per currency

Former Member — Fri, 05 Feb 2010 12:44:52 GMT

Hi,

Icheck what currency field have you given in fieldcatalog.

example :

wa_fieldcat-col_pos = '5'. " Row Position

wa_fieldcat-fieldname = c_total. " field name

wa_fieldcat-ref_tabname = 'BSIK'. " Reference table

wa_fieldcat-ref_fieldname = 'DMBTR'. " Amount field

wa_fieldcat-seltext_l = text-011. " Text

wa_fieldcat-do_sum = c_x.

wa_fieldcat-ddictxt = c_l.

APPEND wa_fieldcat TO fieldcatalog.

CLEAR wa_fieldcat.

wa_fieldcat-col_pos = '6'. " Row Position

wa_fieldcat-fieldname = c_waers. " field name

wa_fieldcat-ref_tabname = 'BSIK'. " Reference table

wa_fieldcat-ref_fieldname = 'WAERS'. " currency reference

wa_fieldcat-seltext_l = text-012. " Text

wa_fieldcat-ddictxt = c_l.

thanks,