topic Re: Issue while using Function Module REUSE_ALV_LIST_DISPLAY. in Application Development and Automation Discussions

Issue while using Function Module REUSE_ALV_LIST_DISPLAY.

former_member576008 — Mon, 25 May 2009 09:35:14 GMT

Hi,

I am currently using REUSE_ALV_LIST_DISPLAY function module for ALV display.

CALL FUNCTION 'REUSE_ALV_LIST_DISPLAY'

EXPORTING

i_callback_program = sy-repid

is_layout = l_layout

it_fieldcat = t_fieldcat

it_events = t_events

TABLES

t_outtab = t_final1

EXCEPTIONS

program_error = 1

OTHERS = 2.

The problem which I am facing is that when I try to download to Excel from the ALV display the Columns headings and corresponding data are getting misaligned.Like heading is getting downloaded at seperate column and their corresponding data in another column.

Could you please suggest your views on this issue.

Thanx in advance.

Re: Issue while using Function Module REUSE_ALV_LIST_DISPLAY.

Former Member — Mon, 25 May 2009 09:38:39 GMT

This occurs due to the insufficient line size. Try to reduce the lengths of the fields as much as possible and specify the line-size in the REPORT statement.

Regards,

Shailaja

Re: Issue while using Function Module REUSE_ALV_LIST_DISPLAY.

former_member576008 — Mon, 25 May 2009 09:54:01 GMT

Hi,

Tried increasing the line size from 30 to 255 but didnt work. Could you plz suggest ?

Thnx.

Nandha

Re: Issue while using Function Module REUSE_ALV_LIST_DISPLAY.

Former Member — Mon, 25 May 2009 10:00:21 GMT

Hi,

Check the link. this is a sample program used to download data from alv to excel sheet.

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/11099070-0b01-0010-fd9d-af9dc9302fa5

regards,

mani

Re: Issue while using Function Module REUSE_ALV_LIST_DISPLAY.

former_member576008 — Wed, 19 Jan 2011 11:10:50 GMT

got it thanks