Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

missing column in excel sheet when downloading from SAP using CL__GUI_ALV_GRID

pashasapcha
Participant

‎2023 Oct 03 12:23 PM

0 Kudos
993

Hi Gurus,

I have created a report program and displayed on alv grid with CL_GUI_ALV_GRID .

when i DOWNLOAD it to excel, I found one column no. 6 CLASS of USR02 is missing in excel sheet though I can see it on my alv grid.

I have maintained field catalog properly but still facing the issue.

total columns are 15. but from the above pic you can see only 14 are showing it is leaving the 6th column.

you can see the fieldcat is maintained properly.

Preview file
24 KB
Preview file
26 KB
Preview file
14 KB
3 REPLIES 3

raymond_giuseppi
Active Contributor

‎2023 Oct 03 12:49 PM

898

First perform The Consistency Check (This class is much more tolerant of many errors in the display than in the Excel export.)

NB: And sorry, but 'you can see the fieldcat is maintained properly' is not exact, check Required Fields of the Field Catalog. (or use CL_SALV_TABLE)

fprokopiuk
Active Participant

‎2023 Oct 03 1:49 PM

0 Kudos
898

Can you try to rename the column? Maybe CLASS is somehow restricted word in some part of the process...

Sandra_Rossi
Active Contributor

‎2023 Oct 03 7:12 PM

0 Kudos
898

This is obsolete ALV, prone to errors, loss of time and money, etc. Can't you go for modern ALV?