topic Problem in fetching data in Interface report in Application Development and Automation Discussions

Problem in fetching data in Interface report

Former Member — Sat, 12 Sep 2009 07:51:26 GMT

Hi SAP Gurus,

I am having a problem while fetching data from .csv file in interface.

Previously , the file of format .csv is fetched into SAP successfully.

Now the new File format is same but some VB script is written in that .csv file. .

so, when i am uploading the new file it is showing garbage data(I have seen in the internal table). that is the data in the file is visible in a different format like !!@!@!###((*&&#&#&.

I am using the following statement for uploading.

OPEN DATASET FILE_PATH FOR INPUT MESSAGE MSG IN TEXT MODE ENCODING DEFAULT.

Please suggest.

Thanks & Regards,

Pavan.B

Re: Problem in fetching data in Interface report

Former Member — Sat, 12 Sep 2009 13:28:32 GMT

hi,

try to upload using C13Z_FILE_UPLOAD_BINARY.

Re: Problem in fetching data in Interface report

jaideepsharma — Sat, 12 Sep 2009 13:46:30 GMT

Hi,

Check if some columns are added or deleted in new .csv file. If yes, then check if VBScript is using column name and the format of the column has got changed in new file. Accordingly, change the old column name to new column name in VBScript.

I faced a similar problem and found that two new columns were added in the file. As per the script it was expecting the "AW" column to be numeric while it was changed and new column was inserted so now the AW was not numeric instead it was DATE field. I changed the hardcoded column value "AW" in the VBScript to "AY".

KR Jaideep,