ALV Layout Problem

[Former Member]

Hi,

I changed a ALV Report format...but when i want to save it in a local file i.e. excel.. it's format will be changed...

Plz Tell me, what is problem..

Thanks...

[Former Member]

Hi,

You can also use OLE from ABAP (look at development classes under BC-CI and

BC-FES-OAC and transaction OLE).

http://help.sap.com/saphelp_46c/helpdata/EN/e9/0be7 75408e11d1893b0000e8323c4

f/frameset.htm

http://help.sap.com/saphelp_46c/helpdata/EN/52/cc23 7cdb3611d1bced080009b4534

c/frameset.htm

Please reward points if useful.

Regards

Rose

[Former Member]

hi ,

do like this..

wa_fieldcat-fieldname = 'MATNR'.

wa_fieldcat-reptext_ddic = 'Material number'.

append wa_fieldcat to it_fieldcat.

clear wa_fieldcat.

replace this ..

wa_fieldcat-fieldname = 'MATNR'.

wa_fieldcat-tabname = 'MARA'.

wa_fieldcat-seltext_m = 'Material no'.

append wa_fieldcat to it_fieldcat.

clear wa_fieldcat.

ur problem solved..

regards,

venkat.

[Former Member]

Hi dear...

Plz. Note that I m not creating a zreport...

i m using standard t.code..and after execution it...when data display...that format i changed...

Now plz explain...

[giancarla_aguilar]

Hello, Prince.

Sorry, I don't have a solution for you. I just want to add that I too experienced the same problem. Specifically, Export to Spreadsheet from any ALV report, standard or customized, causes the columns' layout to re-arrange in the Excel display. I noticed, the columns with date and numeric values are placed on the end of the Excel sheet, disregarding their positions in the ALV report.

Temporary solution can be, to change their value data types to CHAR.

But if anybody out there can offer a permanent solution from SAP notes, etc., please share it to us.

Thanks 😃