Issue while using Function Module REUSE_ALV_LIST_DISPLAY.

[former_member576008]

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.

[Former Member]

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

[former_member576008]

Hi,

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

Thnx.

Nandha

[Former Member]

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-af9dc930...

regards,

mani

[former_member576008]

got it thanks