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: 

Function module GUI_DOWNLOAD: currency format (decimal places)

former_member545771
Explorer

‎04-04-2019 5:54 PM

0 Kudos

I'm using function module GUI_DOWNLOAD to download some finance data. Currencies such as Taiwan Dollar, Hungarian Forint, ..., have no decimal places but are stored with decimal places in the database. For example, 1.50 TWD in the amount field of the database is actually 150 TWD. In queries I can join the reference table of the amount field to show the correct format. However, I don't know how to get the right format in the export file using GUI_DOWNLOAD. Any ideas?

Thanks in advance!

1 REPLY 1

DoanManhQuynh
Active Contributor

‎04-05-2019 3:49 AM

I think you may have to WRITE it with CURRENCY to a character column and download it instead of original currency column.