topic Re: ALV in Application Development and Automation Discussions

ALV

Former Member — Tue, 26 Sep 2006 06:32:34 GMT

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.

Re: ALV

Former Member — Tue, 26 Sep 2006 06:34:26 GMT

in the fieldcatalog for that particular field set the NO_OUT property to 'X'.

Re: ALV

shishupalreddy — Tue, 26 Sep 2006 06:35:17 GMT

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

Re: ALV

anversha_s — Tue, 26 Sep 2006 06:54:05 GMT

hi,

in the field catlog,

set <b>no_out = 'X'.</b>

rgds

anver

pls mark hlpful answers

Re: ALV

Former Member — Tue, 26 Sep 2006 07:03:35 GMT

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.

Re: ALV

Former Member — Tue, 26 Sep 2006 07:07:21 GMT

Why don't you try the option of creating variants.

Re: ALV

Former Member — Tue, 26 Sep 2006 07:22:13 GMT

try with TECH option

wa_fieldcat-TECH = 'X'.

and also check SP_GROUP option