Getting the error 'Cannot interpret data in file' while uopoading.

[Former Member]

Hi All,

Iam getting the error "Cannot interpret the data in file' while uploading the data from legacy system to sap using the function module 'GUI_UPLOAD'.

I have used the following parameters in the FM.

FILENAME = P_PATH1

FILETYPE = 'ASC'

DATA_TAB = I_TAB1.

Any body please suggest the solution.

Regards,

Narasimha

[Former Member]

HI,

Filetype ASC is used to read the Text files. Which filetype your are reading from the leagacy system.

[Former Member]

Hi Avanish,

Yes the legacy data is of text file format. But still getting the error.

Please suggest.

Thanks,

Narasimha

[MarcinPciak]

Hi,

- ensure no header line is provided in the file

- ensure that each column format in the file is loaded to appropriate one in the program (typing issue) i.e. you can't load text column to numeric field (the system will prompt an error)

Regards

Marcin

[Former Member]

Hi Marcin,

Yes no header line is provided in the flat file.

But iam not clear with ur 2nd point. Could u please explain it clear.

Regards,

Narasimha

[MarcinPciak]

Sure,

Suppose you have such data in the file

Cost Center --- Employee - Amount <--- Header line

23334556 5340000 45.56 <--- Data line

Now the strcutre of the table which you are loading into should be excatly as the above (in header line). Typing of each field (Const Center, Employee, Amount) should be respective to data in the file. You can't i.e. provide such data

23334567 5340000 some_text <--- Data line

in this line amount field expects only data of of type i.e. p whereas you provide type char.

Ensure then that all the fields in the file follows the same format (typing) as typings in program table.

What is also to be noticed here, is that date, time and amount fields usually generate such errors. You can only provide data in file which follow SAP internal format for this type. This is:

- for dates you have to provide YYYYMMDD i.e. 20090309

- for time provide HHMMSS - 111915

- for amount dot separator not coma i.e. 15.45 not 15,45

Therefore if you give such data in the file

Date Employee

09.03.2009 5340000

You will get an error, because SAP can't interpret 09.03.2009 as appropriate date format.

If you check all these above, and correct if necessary, you will likely upload your file without any further problems.

Regards

Marcin

[Former Member]

Hi Marcin,

Thanks for ur brief explanation.

Regards,

Narasimha

[qamar_javed]

Hi avvaru,

In the fm GUI_UPLOAD specify the field separator parameters.

And also check this link out.

http://www.sapdevelopment.co.uk/file/file_uptabpc.htm

Hope this works.

Regards,

Qamar.

Edited by: Qamar Javed on Mar 9, 2009 3:20 PM

Edited by: Qamar Javed on Mar 9, 2009 3:22 PM