topic Re: Upload data from flat file into module pool program in Application Development and Automation Discussions

Upload data from flat file into module pool program

sachin_soni — Tue, 08 May 2007 09:32:20 GMT

Hi all,

i have data in my flat file in the following format:

0:2000:2029:34

now i have a module pool interface and i need to catch the figures into text boxes on the click of that button.if somebody can help i shall be delighted.

thanks and regards,

sachin

Re: Upload data from flat file into module pool program

Former Member — Tue, 08 May 2007 09:37:01 GMT

sachin ,

try this 1st upload the data into the internal table.using GUI_upload

Map the fields of the internal table to the fields of the module pool interface.

you have to write ur code in the PAI on the click of that button.

say if that button is display.

when 'display'.

call function GUI_upload.

map the fields and then display it..........

Re: Upload data from flat file into module pool program

Former Member — Tue, 08 May 2007 09:38:44 GMT

Use the SPLIT statement.

SPLIT <fieldname> at ':' into <field1>....

Hope this helps.

Sudha

Re: Upload data from flat file into module pool program

sachin_soni — Tue, 08 May 2007 09:53:58 GMT

sudha can u be a bit more clear please ,

Re: Upload data from flat file into module pool program

sachin_soni — Tue, 08 May 2007 09:57:38 GMT

and ankur , can V upload ':' separated values into ITABs???

Re: Upload data from flat file into module pool program

Former Member — Tue, 08 May 2007 10:05:16 GMT

declare the itab with field type string.

and upload the data into itab.

using split statement separate the values into different fields.

move this field values to screen fields.

Re: Upload data from flat file into module pool program

Former Member — Tue, 08 May 2007 10:05:29 GMT

sachin ,

Try using this

HAS_FIELD_SEPARATOR = '<b>:</b>'

i guess you can do it

else the next option is take a string upload the data in the string and then split the data using SPLIT as told by sudha................

Re: Upload data from flat file into module pool program

Former Member — Tue, 08 May 2007 10:17:47 GMT

check this code.............

DATA: i_file like rlgrap-filename value '/usr/sap/tmp/file.txt'.

DATA: begin of it_datatab occurs 0,

row(500) type c,

end of it_datatab.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = i_file

filetype = 'ASC'

TABLES

data_tab = it_datatab "ITBL_IN_RECORD[]

EXCEPTIONS

file_open_error = 1

OTHERS = 2.

Re: Upload data from flat file into module pool program

Former Member — Tue, 08 May 2007 10:27:55 GMT

hi Sachin,

Here is the dummy code for you...............

say there are only 4 fields in the flat file as mentioned

0:2000:2029:34

data : begin of itab occurs 0 ,

f1,

f2(4),

f3(4),

f4(2),

end of itab.

DATA: i_file type string

value 'C:\Documents and Settings\amarwaha\Desktop\test.txt'.

DATA: begin of it_datatab occurs 0,

row(500) type c,

end of it_datatab.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = i_file

filetype = 'ASC'

TABLES

data_tab = it_datatab "ITBL_IN_RECORD[]

EXCEPTIONS

file_open_error = 1

OTHERS = 2.

loop at it_datatab.

split it_datatab-row at ':' into itab-f1 itab-f2 itab-f3 itab-f4.

append itab.

endloop.

now itab has all the data in the four fields...........

Re: Upload data from flat file into module pool program

sachin_soni — Tue, 08 May 2007 10:29:24 GMT

ankur , the code doesnt takes care of ':' separator here

Re: Upload data from flat file into module pool program

sachin_soni — Tue, 08 May 2007 10:36:50 GMT

thx pal , u made it simple.

Re: Upload data from flat file into module pool program

MarcelloUrbani — Tue, 08 May 2007 10:37:45 GMT

I just want to add one note: gui_upload reads the file from your local pc, and doesn't work in background.

If the file is not reachable from your PC or you want to read it from a batch job, you should use open dataset/read dataset instead.

Re: Upload data from flat file into module pool program

Former Member — Tue, 08 May 2007 10:52:09 GMT

just create internal table with character dat type and in pbo module write

module upload, double click on upload and

in code

call function 'GUI_UPLOAD'

exporting

importing

tables

i_itab = tablename[]

...

reward points if helpful.

with regards,

suresh babu.