Hierarchical ALV list problem..

[sreekanthgo]

Hi All,

In my ALV report output, spreadsheet and wordprocessing buttons are not working properly. Remaining all buttons are working fine.

Can anyone give suggessions about my problem?

Thanks,

Sreekanth

[sreekanthgo]

Hi All,

In my ALV report output, spreadsheet and wordprocessing buttons are not working properly. Remaining all buttons are working fine.

Can anyone give suggessions about my problem?

Thanks,

Sreekanth

[naimesh_patel]

Hello,

If you are using Spreadsheet button to transfer the data to Excel than system put all text fields first and then numerical fields.

To avoid this you can use Local file transfer.

Regards,

Naimesh

[sreekanthgo]

Hi Nimesh,

You mean, my final internal table must have all character fields first and the numeric fields at last.

Thanks,

Sreekanth

[naimesh_patel]

No sreekanth,

system is autmatically doing that.

Like if you have itab like,

fld1 char,

fld2 char,

fld3 num,

fld4 char,

fld5 num

then when you download it, by Spreadsheet system automatically changes like fld1, fld2,fld4, fld3,fld5.

If you want to download your table in excel in the same format then use the button Local file...

Regards,

Naimesh

[sreekanthgo]

Okay Nimesh.

Thanks for your help.

Then what is the use of those two button on the report.

Thanks,

Sreekanth

[naimesh_patel]

Hello Sreekanth,

In Spreadsheet button and word, data is being transferred by the OLE. Here you have more flexiblity like you can download into pivot table, SAP macros, and simple Excel file. You can see you file open in your front (thanks to OLE), while in local transfer you have to go to specific place to open the file.

Regards,

Naimesh