topic Re: Data missing while downloading the data using GUI_DOWNLOAD in Application Development and Automation Discussions

Data missing while downloading the data using GUI_DOWNLOAD

Former Member — Tue, 25 May 2010 04:04:36 GMT

Hi experts,

I'm uploading the Production Order data through excel and in the transaction level it's happening fine.

After running the BDC I'm fetching the Production Order Number(AUFNR) and it's Status from the respective tables and downloading the data along with the Production Order Number(AUFNR) and it's Status using GUI_DOWNLOAD. (Version is 4.6 C)

After downloading some of the Production Order Numbers(AUFNR) and it's Status are missing in the Excel Log sheet . But it's very much there in the SAP tables and also in the transaction screen level.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

bin_filesize = v_bin_filesize

filename = v_name

filetype = 'ASC'

write_field_separator = 'X'

TABLES

data_tab = it_final

EXCEPTIONS

file_write_error = 1

no_batch = 2

- - - - - - - - -

OTHERS = 22.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

Kindly give me your suggestions regarding this.

Thanks in advance.

Jessi

Re: Data missing while downloading the data using GUI_DOWNLOAD

Former Member — Tue, 25 May 2010 05:05:13 GMT

Hi,

I am not sure why it is not coming .

But try by uncomment the bin_filesize.

Because generally the size(bin_filesize) specification is for binary files .



CALL FUNCTION 'GUI_DOWNLOAD'
EXPORTING
*bin_filesize = v_bin_filesize "Comment This
filename = v_name
filetype = 'ASC'
write_field_separator = 'X'
TABLES
data_tab = it_final.

Regards,

Raghava Channooru

Re: Data missing while downloading the data using GUI_DOWNLOAD

dhirendra_pandit — Tue, 25 May 2010 10:08:46 GMT

You can use this function module MS_EXCEL_OLE_STANDARD_DAT.

Regards

Dhirendra