Data missing while downloading the data using GUI_DOWNLOAD

[Former Member]

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

[Former Member]

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

[dhirendra_pandit]

You can use this function module MS_EXCEL_OLE_STANDARD_DAT.

Regards

Dhirendra