Skip to Content
avatar image
Former Member

Sap query

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 04, 2008 at 08:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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...

  • avatar image
    Former Member
    Sep 04, 2008 at 08:57 AM

    Hi,

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

    how-to-supress-carriage-return-in-file

    Good luck

    Narin

    Add comment
    10|10000 characters needed characters exceeded