how do you work with semi colon separated files in bdc ?

Answer Posted / ravi kanth @ reliance sap

There is FM GUI_UPLOAD which will help you in this.
Its has got one parameter calles has_field_separator . Here you can pass comma. So that this will take care while uploading the data in Internal table.

CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
filename = wf_file
filetype = 'ASC'
has_field_separator = ','
* HEADER_LENGTH = 0
* READ_BY_LINE = 'X'
* DAT_MODE = ' '
* CODEPAGE = ' '
* IGNORE_CERR = ABAP_TRUE
* REPLACEMENT = '#'
* CHECK_BOM = ' '
* IMPORTING
* FILELENGTH =
* HEADER =
TABLES
data_tab = it_data
EXCEPTIONS
file_open_error = 1
file_read_error = 2
no_batch = 3
gui_refuse_filetransfer = 4
invalid_type = 5
no_authority = 6
unknown_error = 7
bad_data_format = 8
header_not_allowed = 9
separator_not_allowed = 10
header_too_long = 11
unknown_dp_error = 12
access_denied = 13
dp_out_of_memory = 14
disk_full = 15
dp_timeout = 16
OTHERS = 17

Hope this will help you.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different types of mode (run code) in call transaction method?

565


How to debug rfc function module?

694


Which function module reads the data for particular infotype ? : abap hr

552


What is your approach to find exit and BAdi?

867


What are the differences between domain and data element?

574






Badi concepts

922


Give few names of pooled tables in sap ?

1505


What are the differences between table controls and step loops?

559


What does nw 7.4 sp 05/nw 7.5 sp 02 offers in abap?

690


Can I execute user exits? If yes, how?

592


What are data classes? What are the various data classes available for selection? : abap data dictionary

559


Define structure in abap data dictionary?

617


when u prefer lsmw?

624


Can we set page headers to details lists?

587


What is transparent table?

600