Skip to Content
Nov 09, 2016 at 07:27 AM

Missing field content in a vendor fields when downloaded to Excel from alv report.



I need Help I have a collapsing report that I created with

REUSE_ALV_GRID_DISPLAY I have sorted the alv with Lifnr and Vendor name It works perfectly but issue starts when I download it to Excel the Vendor name is missing in the collapsed mode of Excel but when you drill down its there.They want to see it before they even stretch it.Or If you can help me display the subtotals and grandtotal only maybe it will sove the problem.

Note: I download to excel with standard toolbar List-Export-Spreadsheet.

My sort.

wa_sort-fieldname = 'LIFNR' .
wa_sort-up = 'X'.
APPEND wa_sort TO gt_sort.

wa_sort-fieldname = 'NAME' .
wa_sort-up = 'X'.
wa_sort-subtot = 'X'.
wa_sort-tabname = 'ITAB'.
APPEND wa_sort TO gt_sort