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
Explain the different types of mode (run code) in call transaction method?
How to debug rfc function module?
Which function module reads the data for particular infotype ? : abap hr
What is your approach to find exit and BAdi?
What are the differences between domain and data element?
Badi concepts
Give few names of pooled tables in sap ?
What are the differences between table controls and step loops?
What does nw 7.4 sp 05/nw 7.5 sp 02 offers in abap?
Can I execute user exits? If yes, how?
What are data classes? What are the various data classes available for selection? : abap data dictionary
Define structure in abap data dictionary?
when u prefer lsmw?
Can we set page headers to details lists?
What is transparent table?