Skip to Content
author's profile photo Former Member
Former Member

ALV Report to Excel Conversion

Dear Experts,

I am facing a problem when converting my ALV report display to Excel.

In the report i have sorted on Invoice No. and Value using SORTCAT.

As a result for n number of items for a particular invoice the Invoice No and Value will only be shown once. It will repeat for all the Line items.

But when i convert it into excel at that time the functionality does not work. The values get repeated again for the Line Items.

Can anyone help me out with how to keep the display intact when converting to Excel.

Thanks,

Regards,

Jitesh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 06:48 AM

    Merge the cells in Excel.

    Regards,

    Krishna.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 06:50 AM

    Hi,

    This is link for your querry how-to-view-alv-grid-output-in-excel-formatnot-dow

    Regards,

    Flavya

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 06:50 AM

    Which path r u using for download?

    Use Export (ALV menu bar) -> Local File -> Spreadsheet to download into excel file.

    Regards,

    Aparna

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 06:51 AM

    Hi,

    I hope the below link will help you.

    http://www.scribd.com/doc/7247824/Alv-Output-to-Excel

    Thanks & Regards,

    Khushboo.

    Edited by: khushboo Brahmbhatt on Dec 18, 2008 7:52 AM

    Edited by: khushboo Brahmbhatt on Dec 18, 2008 7:59 AM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.