topic reading data from flat file to internal table without selection screen in Application Development and Automation Discussions

reading data from flat file to internal table without selection screen

Former Member — Tue, 24 Apr 2007 12:21:46 GMT

i'm reading from presentatiion server.

i have a sample notepad file with contains perners like

now i need to read this notepad file to internal table

after reading to internal table simply i need to add one more perner through program.

for this i'm taking an internal table

Data: begin of it_p0001 occurs 0,

pernr(20),

end of it_p0001.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

FILENAME = 'C:\TEST.TXT'

FILETYPE = 'ASC'

TABLES

DATA_TAB = it_p0001.

but this function module giving an exception "File_open_error".

how to trouble shoot that.

Re: reading data from flat file to internal table without selection screen

Former Member — Tue, 24 Apr 2007 12:24:24 GMT

u would have opened the file & executed the program. close the text file & execute the program

Re: reading data from flat file to internal table without selection screen

Former Member — Tue, 24 Apr 2007 12:24:27 GMT

Hi!

The file may be opened by another application (for example with notepad).

Close the file and run your program again.

Regards

Tamá

Re: reading data from flat file to internal table without selection screen

Former Member — Tue, 24 Apr 2007 12:25:36 GMT

I know it's stupid: but does that file exist?

Anyway remember you make sure the file is close when that fm is reading it

Max

Re: reading data from flat file to internal table without selection screen

Former Member — Tue, 24 Apr 2007 12:25:44 GMT

May be the file name which u gave is not there in cfolder.

Regards

Haritha

Re: reading data from flat file to internal table without selection screen

Former Member — Tue, 24 Apr 2007 12:26:51 GMT

Hi vamsi,

Give the full path name for your Flat file. Like,

FILENAME = 'C:\Documents and Settings\Administrator\Desktop\TRAIN1.TXT'.

Thanks.

Re: reading data from flat file to internal table without selection screen

Former Member — Tue, 24 Apr 2007 12:53:23 GMT

i have checked, its not open. its close.

Re: reading data from flat file to internal table without selection screen

kathryn_mcgallicher — Tue, 24 Apr 2007 14:43:11 GMT

Is the file on your PC actually named with all caps? I'm not positive, but I think the GUI_UPLOAD filename is case-sensitive.

K--