Skip to Content

Duplicate Column in Excelsheet when export ALV report ?

Hi all,

i'm facing issue with the duplicate column in excelsheet when exporting alv report into excelsheet format.

Fig1: ALV Grid Output

Fig2:Export into Excelsheet.

Fig:ExcelSheet.

Fig:Fieldcat

alv-grid.png (51.9 kB)
alv-grid.png (51.9 kB)
export.png (88.9 kB)
spreedsheet.png (60.0 kB)
fieldcat.png (72.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 09, 2017 at 10:55 PM
    1. Check your FieldCatalog ... Are there double entries? Or any other inconsistency?
    2. Do an ALV Consistency Check (SAP Help link), that might offer suggestions on what might be wrong here ... See this Blogpost on its use (link) or SAP-KBA 504384 (link)
    Add comment
    10|10000 characters needed characters exceeded

  • Jul 11 at 01:50 PM

    Hello,

    The KBA 2472722 contains a Guided Answer about empty columns being exported while using the Spreadsheet format to export ALV files to excel. You can check it in order to see if your system has the corrections mentioned in the Guide.

    Regards,

    Maurício

    Add comment
    10|10000 characters needed characters exceeded