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 do you mean by pooled tables in sap abap? Also explain what do you mean by table pool? : abap data dictionary
How to select valid lines for secondary list?
What are the buffering options in abap?
What is payroll driver
What is update task
Explain the difference between function group and function module?
How to create a button in selection screen ?
What is roles and responsibilities of sap hr consultants? : sap abap hr
What are the check tables?
What is transparent table?
What are Table control and tab strip control in dialog programming ?
How do you set up background jobs in sap? What are the steps?
Suppose there is a secondary index on 4 non-key fields A,B,C & D. There are 3 select queries :- a) one on basis of A, B, C , D b) Second on basis of A, B, C c) Third on basis of D, C,B, A In which all situations , the above secondary index will be used?
What are the differences between macro and subroutine?
What is an Open Item in SAP? How will you find an Open Item in SAP?