Skip to Content
author's profile photo senthil gajendran
-1
senthil gajendran

ALV TO DOWNLOAD THE EXCEL

Posted on Jul 23, 2020 at 07:00 AM 59 Views

code.txtop.jpgexcel-op.jpg

Hi Expert,

I have one task to download the report in "Excel" format. I have designed the ALV but i have issue's in it..

1. My download .XLS format NOT showing the 1st and last column header's name?

2. "the sorted value of price ,currency,weight and unit" value not display in excel download?

Please guidance me what mistake i made. (Attached my code , output(ALV) , excel ).

Thanks,

Senthil.

op.jpg (106.3 kB)
excel-op.jpg (96.5 kB)
code.txt (5.9 kB)
Add a comment
10|10000 characters needed characters exceeded

Comment on This Question

Assigned Tags

Related questions

2 Answers

  • author's profile photo Sandra Rossi
    Sandra Rossi
    Posted on Jul 23, 2020 at 01:01 PM
    0

    1. My download .XLS format NOT showing the 1st and last column header's name?

    Your internal table has first component 'MANDT', hence the downloaded file has MANDT at first position. So you should add 'MANDT' as first column header (T_HEADER).

    2. "the sorted value of price ,currency,weight and unit" value not display in excel download?

    Your internal table doesn't contain what is displayed in the ALV. If you want your internal table contain the sum of columns by currency code, you have to do code it yourself (not related to ALV).

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo senthil gajendran
    senthil gajendran
    Posted on Jul 23, 2020 at 08:47 AM
    -1

    Hi Expert,

    Please find my custom-table.


    table.jpg (97.2 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Sandra Rossi
      Jul 23, 2020 at 12:54 PM

      Please use the COMMENT button for comments, questions, adding details, replying to OP comment, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

      If you want to target someone, if this person has posted an Answer, use the button REPLY, if this person is the Original Poster of the question he/she will be automatically informed, otherwise copy/paste their hyperlinked name so that the person receives a warning (NB: @ doesn't work/but typing this character will suggest hyperlinked names).

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.