- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- Zero Decimal values in AL11 file download
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Zero Decimal values in AL11 file download
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-16-2014 7:56 PM
Hi Experts,
We have a program to download data into XLS file in AL11 application server. We have a currency column to be passed on to the file. The issue here is I have a decimal value like 201.30 and 200.00 but these values are downloading in AL11 as 201.3 and 200, But I want the values as how it is passing in the string. I am using Open data set statement and inside that concatenating all fields and transferring it into file. I tried searching in the forum and find couple of links none of them helped. Could anyone advice how to overcome this?
Thanks
Siva
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-17-2014 7:47 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2014 4:13 AM
We have a program to download data into XLS file in AL11 application server.
You are having problem when you are trying to upload the quantity from excel ( presentation server ) to AL11 ( application server ) or vice versa ?
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2014 2:50 PM
I am trying to download data from my program to AL11. AL11 File format is Xls.
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2014 3:15 PM
So download the file to desktop in binary mode using CG3Y transaction. Then open the file in Notepad, and paste whatever you see there.
How are you checking the contents of xls file if it is in application server?
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2014 3:51 PM
I Have the physical path of that file in application server and i am checking there.I can see the .00 or .10 values when i open the file in note pad. But issue is when i try to open it in excel those .00 and .10 s are not coming
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2014 3:56 PM
This means you have failed to search.
This is excel issue, not abap.
Even for excel, it is as per their design.
If you type 0001 in excel and press enter, it would become 1.
This has been discussed countless time before.
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2014 4:08 PM
I know its excel Issue.Still you did not get my query.What I was asking? Is there a way to overcome this by doing some coding while writing it into Xls in AL11.
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2014 4:12 PM
Again, searching would give you possible ways to get around it. Just search "abap excel missing zero".
- SAP Managed Tags:
- ABAP Development
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2014 5:32 AM
Could you open the xls file in Notepad, and paste the contents here?
- SAP Managed Tags:
- ABAP Development
