topic Re: input file for bdc in Application Development and Automation Discussions

input file for bdc

Former Member — Tue, 22 Jul 2008 14:16:42 GMT

Hi all,

when using bdc with data in an input file ie txt file,how should the data be defined in it.

Eg: if i have 2 fields emp_id , name ,salary, i defined it like this:

emp.txt

'101','abc',80

'102',xyz',100

'103','pqr',50

and using fm 'gui_upload to save it in itab.

But it is not coming in proper format in itab.

is the input file in proper format?

Thanx

bhakti

Re: input file for bdc

Former Member — Tue, 22 Jul 2008 14:26:28 GMT

Hi!

You can handle this file like this:

TYPES: begin of t_file,

line(1000)

end of t_file.

DATA: gt_file TYPE STANDARD TABLE OF t_file,

gs_file LIKE LINE OF gt_file.

DATA: lv_path TYPE string VALUE 'C: emp ile.txt'

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = lv_path

has_field_separator = ' ' "if the file is separated by tabulators, then put an X into this parameter

tables

data_tab = gt_file.

LOOP AT gt_file INTO gs_file.

SPLIT gs_file-line AT ',' INTO field1 field2 field3.

ENDLOOP.

Regards

Tamá

Re: input file for bdc

Former Member — Tue, 22 Jul 2008 14:31:17 GMT

Hi,

You do not need to have those single quotes in your file.

Best regards,

Kazmi

Re: input file for bdc

Former Member — Tue, 22 Jul 2008 14:31:54 GMT

Bhakti,

i feel in SDN there is zillien of thread for same you need to just search them.

Amit.

Re: input file for bdc

Former Member — Wed, 23 Jul 2008 04:02:08 GMT

Amit,

if you want to answer than do it else let people answer...

may there be zillion of same type ques...

Re: input file for bdc

Former Member — Wed, 23 Jul 2008 04:02:41 GMT

Thanx kazmi for your reply...

Re: input file for bdc

Former Member — Wed, 23 Jul 2008 08:28:28 GMT

Thanx tamas..

it did work...