‎2006 Sep 26 7:32 AM
Hi experts,
I have an ALV grid in my program output. I need a column to be hidden during display. But I need this column output should be included when it is exported to EXCEL. I can manage this using the Layout management. Whereas i need to implement this directly in the code. i.e using settings in field catalog. Is there any way to do this.
By implementing this in code, i can avoid showing that particular column in layout management.
Thanks in advance.
‎2006 Sep 26 7:34 AM
in the fieldcatalog for that particular field set the NO_OUT property to 'X'.
‎2006 Sep 26 7:35 AM
Hi ,
Populate the fieldcatalog of that filed whic you want to hide using NO-DISPLAY attibute of the fieldcatalog structure
FCAT-NO_DISPLAY = 'X'.
THIS WILL SOLVE YOUR PROBLEM
THANKS
‎2006 Sep 26 8:03 AM
Hi Ram,
There is no attribute named NO_DISPLAY in the fieldcatalog structure named LVC_S_FCAT.
And also friends the option NO_OUT doesn't allow the column to be download as well.
So Ganesh requirement is to hide a column in alv grid and also to get the same hidden column to be downloaded to EXCEL.
Thanks in advance.
‎2006 Sep 26 7:54 AM
hi,
in the field catlog,
set <b>no_out = 'X'.</b>
rgds
anver
pls mark hlpful answers
‎2006 Sep 26 8:07 AM
‎2006 Sep 26 8:22 AM
try with TECH option
wa_fieldcat-TECH = 'X'.
and also check SP_GROUP option