topic Re: Need a Function Module in Application Development and Automation Discussions

Need a Function Module

Former Member — Tue, 14 Feb 2006 19:16:30 GMT

Hi All,

I am using 'GUI_DOWNLOAD' to download excel file.

In this case if any field having leading zeros it is removed.I want any option in this FM which will retain the leading zeros or any other FM which will do the same.

Regards,

Jeetu

Re: Need a Function Module

RichHeilman — Tue, 14 Feb 2006 19:17:51 GMT

I don't know of any that will retain the leading zeros. Maybe it will if you make the field in your internal table as a char field and move the value with leading zeros to it.

Nope, just tested it. That doesn't work.

Regards,

Rich Heilman

Re: Need a Function Module

Former Member — Tue, 14 Feb 2006 19:27:12 GMT

I don't think that you can achieve this...I just review all the GUI_DOWNLOAD params...and there's no option for what you want to do...

Greetings,

Blag.

Re: Need a Function Module

Former Member — Tue, 14 Feb 2006 19:34:25 GMT

hi jeetu,

that is not the problem with the function module because that is the property of excel file to supress leading zeros. if you want just open a excel and try to save an entry with leading zeros ..

thanks

aditya

Re: Need a Function Module

Former Member — Tue, 14 Feb 2006 19:34:49 GMT

Hi Jeetu,

I just worked on this & found that if you append '' in front of the field with leading zeros,you will get them in the downloaded excel.

data: begin of itab occurs 0,

test(10),

end of itab.

itab-test = '''000120'.

append itab.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

BIN_FILESIZE =

FILENAME = 'C:/FILE.XLS'

FILETYPE = 'ASC'

APPEND = ' '
WRITE_FIELD_SEPARATOR = ' '
HEADER = '00'
TRUNC_TRAILING_BLANKS = ' '
WRITE_LF = 'X'
COL_SELECT = ' '
COL_SELECT_MASK = ' '
DAT_MODE = ' '
CONFIRM_OVERWRITE = ' '
NO_AUTH_CHECK = ' '
CODEPAGE = ' '
IGNORE_CERR = ABAP_TRUE
REPLACEMENT = '#'
WRITE_BOM = ' '
TRUNC_TRAILING_BLANKS_EOL = 'X'
WK1_N_FORMAT = ' '
WK1_N_SIZE = ' '
WK1_T_FORMAT = ' '
WK1_T_SIZE = ' '
IMPORTING
FILELENGTH =

TABLES

DATA_TAB = ITAB

FIELDNAMES =

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.