Skip to Content

Problem with download alv data

Hi Experts,

I have ALV report to display orders and sto data with some field will be traffic lights,So the problem is if i will download that displayed data in excel sheet that traffic light field data also downloading but i want it should blank while downloading.Anyone can help me for this requirement.

I.e field 1  is trafficlight so i passed value in report for signal purpose green '@08@'.

so downloading time also its downloading that value in excel sheet like  @08@.

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 08, 2015 at 10:49 AM

    Hi Ram,

    first you have to add one function-button to download data at the time of displaying ALV so that this button will be displayed on ALV screen.

    Second, you have to write your own subroutine which will be triggered when user pressed this new button on the screen. You have to remove trafficlight values from your internal table which you passed to the ALV and then use this modified internal table to download it using GUI_DOWNLOAD FM.

    You can use parameter I_callback_user_command in FM for REUSE_ALV* and you have to create subroutine with same name in your program where you will write your own code to download data.

    Regards,

    Sid

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 10:58 AM

    Hi Ram

    When clicking on download you are passing data taking from alv  right.

    so delete that particular field from internal table and pass it to download function--this must happens only when downloading

    if you need empty field loop the internal table ,blank the particular field and append to new internal table ,pass the new internal table to download function.

    Thanks

    Vamsi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 11:15 AM

    Hi Ram,

    As mentioned by Mohan Vamsi, its advisable to hide/delete 'traffic light' column while downloading.

    If user insists on having traffic light while downloading the alternative solution is download data  as 'HTML format'(.htm), then copy html file to excel.

    Thanks and regards,

    Greeshma.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 08, 2015 at 11:25 AM

    Hi Ram,

    Here, you have to use Events of ALV and will have to handle downloading pragmatically using Upload Function module. While downloading skip that field.

    You have to use Callback_Use_Command to hand the tool in alv report.

    Many Thanks / Himanshu Gupta

    Add comment
    10|10000 characters needed characters exceeded