topic Re: Sap query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/4489544#M1062628 <HTML><HEAD></HEAD><BODY><P>Moni</P><P></P><P>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.</P><P></P><P></P><P>Thanks</P><P></P><P>Amol Lohade</P></BODY></HTML> Thu, 04 Sep 2008 08:31:28 GMT Former Member 2008-09-04T08:31:28Z Sap query https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/4489543#M1062627 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P>Currently I am working in Client ECC6 and I got a problem in SAP query.</P><P>In my Query selection we store the data in Private File in .txt format.</P><P>Now user is saying that when he got the file,at end of each row he find ASCII(13) (carriage return)</P><P>And also at end of that file.</P><P></P><P>Just few days before our system Upgraded from 4.6C to ECC6.</P><P>Previously he got ASCII(10) (Line feed) at end of each row.which is correct value.</P><P></P><P>I checked the whole query in SQ01/SQ02.</P><P>you take a look at the following hexadecimal dump of the first two lines you can see that the End of Line char is <STRONG>0d:</STRONG></P><P>0000000: 3141 4242 0945 4546 2031 3038 3020 2842 1ABB.EEF 1080 (B</P><P>0000010: 3129 2053 7061 7265 732c 2052 656f 7264 1) Spares, Reord</P><P>0000020: 6572 2f45 7874 6572 2f41 7574 6f09 3230 er/Exter/Auto.20</P><P>0000030: 3209 5632 <STRONG>0d</STRONG>31 4144 4209 4545 4620 3130 2.V2.1ADB.EEF 10</P><P>0000040: 3830 2028 4231 2920 5370 6172 6573 2c20 80 (B1) Spares, </P><P>0000050: 5265 6f72 6465 722f 4578 7465 722f 4175 Reorder/Exter/Au</P><P>0000060: 746f 0932 3032 0956 4d<STRONG>0d</STRONG> to.202.VM. </P><P>The correct file should contains the character <STRONG>0a</STRONG>:</P><P>0000000: 3141 4242 0945 4546 2031 3038 3020 2842 1ABB.EEF 1080 (B</P><P>0000010: 3129 2053 7061 7265 732c 2052 656f 7264 1) Spares, Reord</P><P>0000020: 6572 2f45 7874 6572 2f41 7574 6f09 3230 er/Exter/Auto.20</P><P>0000030: 3209 5632 <STRONG>0a</STRONG>31 4144 4209 4545 4620 3130 2.V2.1ADB.EEF 10</P><P>0000040: 3830 2028 4231 2920 5370 6172 6573 2c20 80 (B1) Spares, </P><P>0000050: 5265 6f72 6465 722f 4578 7465 722f 4175 Reorder/Exter/Au</P><P>0000060: 746f 0932 3032 0956 4d<STRONG>0a</STRONG> </P><P></P><P>Could you please give any suggestion for this why system picked that value.</P><P></P><P>Thanks in advance.</P><P></P><P>Kind regards,</P><P>Moni</P></BODY></HTML> Thu, 04 Sep 2008 07:57:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/4489543#M1062627 Former Member 2008-09-04T07:57:10Z Re: Sap query https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/4489544#M1062628 <HTML><HEAD></HEAD><BODY><P>Moni</P><P></P><P>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.</P><P></P><P></P><P>Thanks</P><P></P><P>Amol Lohade</P></BODY></HTML> Thu, 04 Sep 2008 08:31:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/4489544#M1062628 Former Member 2008-09-04T08:31:28Z Re: Sap query https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/4489545#M1062629 <HTML><HEAD></HEAD><BODY><P>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 .</P><P></P><P>Any guess...</P><P></P><P>Thanks...</P></BODY></HTML> Thu, 04 Sep 2008 08:34:29 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/4489545#M1062629 Former Member 2008-09-04T08:34:29Z Re: Sap query https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/4489546#M1062630 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check this thread.. Im not sure it can help you or not and more over is it related to your module or not..</P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="5655930"></A></P><P></P><P></P><P>Good luck</P><P>Narin</P></BODY></HTML> Thu, 04 Sep 2008 08:57:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sap-query/m-p/4489546#M1062630 narin_nandivada3 2008-09-04T08:57:54Z