Problem with download alv data
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@.
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.