Does Filetype 'DBF' work with datatype string

[Former Member]

Hi all,

I am trying to download to excel using filetype 'DBF' for FM 'GUI_DOWNLOAD'.

the problem is that it does download for the fields which are of type string.

How do u do that?

Is there any other way to download to excel as I also want to retain leading zeros.

Thanks,

Mohammed.

[Former Member]

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = FILENAME

FILETYPE = 'ASC'

TABLES

DATA_TAB = BUFFER

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE = 4

NO_AUTHORITY = 5

UNKNOWN_ERROR = 6

HEADER_NOT_ALLOWED = 7

SEPARATOR_NOT_ALLOWED = 8

FILESIZE_NOT_ALLOWED = 9

HEADER_TOO_LONG = 10

DP_ERROR_CREATE = 11

DP_ERROR_SEND = 12

DP_ERROR_WRITE = 13

UNKNOWN_DP_ERROR = 14

ACCESS_DENIED = 15

DP_OUT_OF_MEMORY = 16

DISK_FULL = 17

DP_TIMEOUT = 18

FILE_NOT_FOUND = 19

DATAPROVIDER_EXCEPTION = 20

CONTROL_FLUSH_ERROR = 21

OTHERS = 22

[Former Member]

Hi Mohammad,

There are 2 different methods of downloading the data to the excel file but both of them belong to the download to the Application server.

According to the first method,once the list is saved on the Application server and you go to the T-code AL11,display the list and then go to System at the menu bar and click on List and then Save and then to the Local file as excel format and the data gets downloaded in the excel file.

Secondly,once the list is displayed in the Application server,write the T-code CG3Y and it will prompt you for the location on the Presentation server along with the file format.Give the file format as .XLS and you are done.

In case,you have any further clarifications,do let me know.

Regards,

Puneet Jhari.