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: 

Negative quantity value displayed in ALV is converting to char when viewing the excel

karthik_narayan2
Explorer

‎09-01-2017 5:00 PM

0 Kudos

Hello,

I am trying to display negative quantity value- MENGE in ALV grid display and while viewing the data in excel , this column is getting converted to text field.

As i need to perform summation on the this column, changing the cell format also not helping.

Please let know how to get the value to retained in the same format in excel without no manual intervention on excel.

Thanks,

Narayan

Preview file
1 KB
Preview file
15 KB
Preview file
29 KB
Preview file
15 KB
2 REPLIES 2

Jelena
Active Contributor

‎09-01-2017 7:16 PM

0 Kudos

It's because Excel wants "-100", i.e. minus sign upfront. Have you tried searching in Google? I'm pretty sure a similar question has been asked before...

NTeunckens
Active Contributor

‎09-01-2017 11:14 PM

0 Kudos

A few things :

  • Have you set / indicated in the FieldCatalog of your Output (ALV-Column) that your Quantity is actually defined as a Quantity Field?
  • Have you set / indicated in the FieldCatalog of your Output (ALV-Column) to allow a Sign in your Output?
  • Which datatype is your "Quantity"-Column? Is it a Z-Type or a SAP-Standard Numeric / Quantity field? Try using a type such as "MENGV" ...


If not, please check up on you FieldCatalog and make Adjustments ... Test it again.

If you still encounter problems, check with different Exporting Options => For example : Export as '.txt' and viewing it as Spreadsheet ...