Skip to Content
avatar image
Former Member

Amount truncated while exporting to Excel

Hi SAP Gurus,

I have an issue. whenever I use the option of "Export to excel" for a particular report, my amount field gets truncated. (Like if an amount is 123456, downloaded excel displays only 123). I am the only one facing this issue and all my colleagues are able to download the report correctly. I face this issue for every SAP report.

Your guidance is highly appreciated

Thanks

PN

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 06, 2015 at 11:30 AM

    Thank you all for your suggestion.

    The issue turned out to be SAP GUI issue and was resolved after the GUI was re-installed. (this may be due to the recent system upgrade at our end)

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 03, 2015 at 11:20 AM

    If the data contains any special marks in the text etc. it gets truncated. Check whether your data contains " ! ' ~ # etc type of marks, you need to correct the master data / documents posted, then try to re-download it again.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Prachi,

      Are all of them are using the same way that you are trying to download, same download option?

      Do you have the same authorization access?

      Check your user settings / parameters in SU3 and compare with your users?

      Is excel is properly installed or do you have any desktop issue? Whether you both have the same operating system working on? - This should not be an issue, but worth to check.

      Can your colleague can download the same report on your machine with his / her login in the same way that you are trying to download?

  • avatar image
    Former Member
    Nov 03, 2015 at 01:38 PM

    As a solution, right click on output and click on excel to download it to required path in correct format.

    Here it is dividing with 1000 every time.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Did you try right click on output and click on excel to download it to required path in correct format.

      This truncation is happening like (/1000) with some setting.