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
Showing results for 
Search instead for 
Did you mean: 
Read only

ALV

Former Member
0 Likes
560

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.

6 REPLIES 6
Read only

Former Member
0 Likes
538

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

Read only

shishupalreddy
Active Contributor
0 Likes
538

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

Read only

0 Likes
538

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.

Read only

anversha_s
Active Contributor
0 Likes
538

hi,

in the field catlog,

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

rgds

anver

pls mark hlpful answers

Read only

Former Member
0 Likes
538

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

Read only

Former Member
0 Likes
538

try with TECH option

wa_fieldcat-TECH = 'X'.

and also check SP_GROUP option