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: 

data type issue

rbharathi123
Explorer

‎2023 Oct 26 5:34 AM

0 Kudos
329

Dear Experts,

Below show field ZQAMOUNT having data type P(17.dec2).Previous amount field had a C(20), to achieve a sum after downloading that report to excel i have changed data type from character to packed decimals. The issue is Because of packed decimals it is taking minimum value as 0.00. Requirement is that Whenever I download the report to excel I should not get 0.00 for ZQAMOUNT Field as shown below.

Its like multiple data type for single field in internal table.

Kindly some please share me an idea how to do it.

Regards,

Bharathi

Preview file
64 KB
Preview file
18 KB
Preview file
53 KB
2 REPLIES 2

Sandra_Rossi
Active Contributor

‎2023 Oct 26 6:01 AM

266

Sorry but I don't have a single idea what your code looks like, how you display the ALV grid, what is your field catalog, how you "download the report to excel", etc.

raymond_giuseppi
Active Contributor

‎2023 Oct 26 9:49 AM

266

Create a true currency amount field (CURR) associated to a currency code (CUKY)

  • When amount is zero and code is not initial you get zeroes with decimal place of the currency
  • When amount is zero and code is initial you get space

Else if you use ALV try to set no_zero in the field catalog