Sap query

[Former Member]

Dear All,

Currently I am working in Client ECC6 and I got a problem in SAP query.

In my Query selection we store the data in Private File in .txt format.

Now user is saying that when he got the file,at end of each row he find ASCII(13) (carriage return)

And also at end of that file.

Just few days before our system Upgraded from 4.6C to ECC6.

Previously he got ASCII(10) (Line feed) at end of each row.which is correct value.

I checked the whole query in SQ01/SQ02.

you take a look at the following hexadecimal dump of the first two lines you can see that the End of Line char is 0d:

0000000: 3141 4242 0945 4546 2031 3038 3020 2842 1ABB.EEF 1080 (B

0000010: 3129 2053 7061 7265 732c 2052 656f 7264 1) Spares, Reord

0000020: 6572 2f45 7874 6572 2f41 7574 6f09 3230 er/Exter/Auto.20

0000030: 3209 5632 0d31 4144 4209 4545 4620 3130 2.V2.1ADB.EEF 10

0000040: 3830 2028 4231 2920 5370 6172 6573 2c20 80 (B1) Spares,

0000050: 5265 6f72 6465 722f 4578 7465 722f 4175 Reorder/Exter/Au

0000060: 746f 0932 3032 0956 4d0d to.202.VM.

The correct file should contains the character 0a:

0000000: 3141 4242 0945 4546 2031 3038 3020 2842 1ABB.EEF 1080 (B

0000010: 3129 2053 7061 7265 732c 2052 656f 7264 1) Spares, Reord

0000020: 6572 2f45 7874 6572 2f41 7574 6f09 3230 er/Exter/Auto.20

0000030: 3209 5632 0a31 4144 4209 4545 4620 3130 2.V2.1ADB.EEF 10

0000040: 3830 2028 4231 2920 5370 6172 6573 2c20 80 (B1) Spares,

0000050: 5265 6f72 6465 722f 4578 7465 722f 4175 Reorder/Exter/Au

0000060: 746f 0932 3032 0956 4d0a

Could you please give any suggestion for this why system picked that value.

Thanks in advance.

Kind regards,

Moni

[Former Member]

Moni

Talk to the Basis Person... I think it is related to some BASIS setting in SAP or File Server and nothing to do with ABAP.

Thanks

Amol Lohade

[Former Member]

Thanks for your reply...i already discussed with BASIS team ,they said that from there end everything is ok..means all the setting like previous .

Any guess...

Thanks...

[narin_nandivada3]

Hi,

Check this thread.. Im not sure it can help you or not and more over is it related to your module or not..

Good luck

Narin