topic Re: Problem with Read dataset in Application Development and Automation Discussions

Problem with Read dataset

Former Member — Tue, 24 Oct 2006 14:46:29 GMT

Hello all,

I am reading a file (stored in a DAT format on application server) with READ DATASET statement. there is one quantity field (MENGE) and Currency field (WRBTR).

When I read the file into an internal table the data record in internal table is getting appended with addition 20 like this.

Actul valueValue in internal table

WRBTR MENGE WRBTR MENGE

71.66 1 20202020071.66 2020202001.200

113.75 1 20202020113.75 2020202001.200

how to remove this additional '20'?

Has anyone faced a similar problem before?

Regards,

Anup

Message was edited by: Anup Deshpande

Re: Problem with Read dataset

FredericGirod — Tue, 24 Oct 2006 14:48:48 GMT

20 means " " (space) in hexa.

Fred

Re: Problem with Read dataset

Former Member — Tue, 24 Oct 2006 14:49:25 GMT

Hi Anup,

20 is the hexadecimal equivalent for space.

In which mode did you open the file?

Open the file in text mode. and see if the problem exists.

Regards,

Ravi

Re: Problem with Read dataset

Former Member — Tue, 24 Oct 2006 14:56:45 GMT

I think you are opening the file in binary mode and writing it.. Use text mode with encoding ... this should solve your problem

Re: Problem with Read dataset

Former Member — Tue, 24 Oct 2006 15:29:14 GMT

Hello,

I am opening the file in text mode. Still problem exists.

Regards,

Anup

Re: Problem with Read dataset

FredericGirod — Tue, 24 Oct 2006 15:33:31 GMT

maybe the problem is the conversion, you have set directly the value of the file into the table. Better is to read data into a char field and use MOVE to let SAP convert the value into the end-field.

Fred

Re: Problem with Read dataset

Former Member — Tue, 24 Oct 2006 21:38:58 GMT

Can you paste your code for the file open/read part?