topic Re: ALV Layout Problem in Application Development and Automation Discussions

ALV Layout Problem

Former Member — Mon, 17 Mar 2008 07:32:06 GMT

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

Re: ALV Layout Problem

Former Member — Mon, 17 Mar 2008 07:41:25 GMT

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

Re: ALV Layout Problem

Former Member — Mon, 17 Mar 2008 08:04:45 GMT

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.

Re: ALV Layout Problem

Former Member — Mon, 17 Mar 2008 08:17:47 GMT

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

Re: ALV Layout Problem

giancarla_aguilar — Fri, 18 Apr 2008 05:17:52 GMT

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 😃