SAP Query output download to Excel

[Former Member]

Hi All,

Once I export/download Query Output to Excel the fields are not in the order of Actul Query output

<u><i><b>Char fields are treated as Key fields and displayed Left side.</b></i></u>

As it is a SAP Query where to keep this kind of setting(key columns = 0).?

Thanks in advance and useful answer will be awarded.

cheers!!

Komatsu

[Former Member]

when u download data to excel sheet, u can't handle the data from SAP....The data in excel takes excel properties and accordingly data gets adjusted to the formats of excel.

If u need formatting u need to use OLE concepts in SAP from which u can set the formats of Excel Sheet.

[Former Member]

pls change the data type to <b>dbf</b> in gui_download and checkout if it works

[Former Member]

It is a Query