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
What is web dynpro for abap?
Difference between select option and ranges ?
How we can give authorization on the fields of table control in a dialog-programming?
What is meant by search help? : sap abap data dictionary
What is function group?
Explain what is an rdbms?
What is gui status? How to create /edit gui status?
Normally how many and what files get created when a transaction program is written?
What are the commands used for interactive reports?
What is the functionality of BIZTALK and how it handles the IDOC’s and how u will transfer the IDOCS to the BIZTALK ?
Can i Have Some Realtime Examples On Modulepool programming.
What are the difference between tables and structures? : abap data dictionary
Explain the systems fields used for interactive lists and lists?
Reports: Event functionality.
What is a batch input session? : abap hr