topic Re: data type issue in Application Development and Automation Discussions

data type issue

rbharathi123 — Thu, 26 Oct 2023 04:34:57 GMT

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

Re: data type issue

Sandra_Rossi — Thu, 26 Oct 2023 05:01:10 GMT

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.

Re: data type issue

RaymondGiuseppi — Thu, 26 Oct 2023 08:49:40 GMT

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