Skip to Content

why distribute the report that export to excel from sap?

hi every body

I have problem with this issue . when I export the report from sap to excel , some of the cell and columns in excel are distribute .

look at this screenshots :

1-main file

2-after export

I saw the some of material that have this problem . all of these material distributed in excel :

most of them have the symbol . do you know which character is cause that . or has any role for character of the description of master data???

3.JPG (186.9 kB)
2.JPG (99.7 kB)
Capture.JPG (167.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Dec 27, 2014 at 11:04 AM

    Dear Ali Khojaloo,

    the same issue i have faced previous, the main cause is, if the material description starts with quotation mark (") and it is not end with same. it distribute materials until system finds another quotation mark in the description field. Please remove the symbol and try to export again.

    Regards,

    B V

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 27, 2014 at 09:02 AM

    Dear Khojaloo,

    Instead of Local file kindly use downloading through Spreadsheet.

    Regards,

    Karna J

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 27, 2014 at 10:01 AM

    Download it as local file in txt format.

    Then open Excel and select from Excel menu "Open file" and select your text file.

    Excel directly open then the import assistant where you can define yourself how you want to separate the fields

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 27, 2014 at 10:09 AM

    Dear @ali khojaloo,

    First of all follow the instruction given by @Karunanithi Jayapal, If still same problem is persisting

    then you can directly copy and paste from SAP to Excel for eg. select the material number to material description, press CTRL+Y & select the detail then press CTRL + C & paste in Excel sheet, hence I could be copied exactly.

    Kind Regards

    Kamlesh

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 27, 2014 at 11:45 AM

    Dear B V yadav

    thank you for your posting.I change the material descriptions and add in first or end of that . after that I report and export to excel . but this time the problem was solved .

    Regards

    ali khojaloo

    Add comment
    10|10000 characters needed characters exceeded