Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Quantity (amount) conversion as per currency

Former Member

‎2010 Feb 05 10:45 AM

0 Likes
585

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

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

Reply
3 REPLIES 3
Read only

Former Member

‎2010 Feb 05 11:21 AM

0 Likes
549

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

Read only

Former Member

‎2010 Feb 05 11:49 AM

0 Likes
549

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.'

Read only

Former Member

‎2010 Feb 05 12:44 PM

0 Likes
549

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,