topic Re: Does Filetype 'DBF' work with datatype string in Application Development and Automation Discussions

Does Filetype 'DBF' work with datatype string

Former Member — Mon, 17 Sep 2007 04:41:15 GMT

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.

Re: Does Filetype 'DBF' work with datatype string

Former Member — Mon, 17 Sep 2007 04:54:22 GMT

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

Re: Does Filetype 'DBF' work with datatype string

Former Member — Mon, 17 Sep 2007 05:01:32 GMT

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.