Application Development 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: 

How to get thousand separator in excel using if_ixml_element for an amount field

former_member281310
Explorer

‎11-14-2017 11:52 AM

0 Kudos

I am using a custom report to download and send the data in an email using if_ixml_element. While downloading the amounts are in general data format. User require the same in number format. I'm able to download in Number format, but currently, it is not displaying with thousand separators. Can anyone help how I can achieve this using this interface?

I'm not using abap2xlsx as this is an old program and doing minor modifications. Please help me on this.

1 REPLY 1

former_member549008
Explorer

‎01-02-2018 4:15 AM

0 Kudos

This can be achieved by using string templates. If you are passing the amount to a string .

Data: lv_tot_amt_pay TYPE string,

ls_total_amount_payable type waers.

lv_tot_amt_pay = |{ ls_total_amount_payable CURRENCY = 'RM' NUMBER = USER }|.