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

What are the types of table fields in the sap abap?

617


What is the basic difference internal tables and database tables? : abap data dictionary

565


****THANK YOU ALL ABAP EXPERTS**** I got a JOB as ABAP Consultant in Infosys.I cleared the interview.The question posted here are really good.I cleared interview based on this material only.It really works.I thank all members who posted que&ans here. Those who are in search of job in MNC study this question set only you will get sucess. Thanks once again allinterview.com and members of this community. tulika20021@rediffmail.com

1690


What is use of transparent table in abap? How it is different from pool tables?

628


In delivery processing which step comes first picking, packing, posting goods issue ?

1630






any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?

1980


Can you define a field without a data element?

558


What is tmg?

691


What is payroll area

1815


function modules are also external subroutines. State true or false. : abap modularization

600


Can you show multiple alvs on a single screen?

596


What is the last entry in all bdc tables? : abap bdc

594


how to Create reports in SD module such as sales order report, which covers all organization levels, delivery status, invoice status, shipping details and partner function details. The data will be extracted from VBAP, VBPA, VBAK, VBUP, VBFA, KNA1, LIPS, VBRP, MARA, VBEP and KONV tables. plz mention the detail coding Tahnks, Rahul

2871


Explain what are the events used in interactive reports?

489


What are the different types of luws. What are they?

629