topic Re: Sorting Issue in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/10292050#M1832990 <HTML><HEAD></HEAD><BODY><P>I haven't used it yet, but try use addition STABLE to SORT statement <SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro jive_emote" src="https://community.sap.com/748/images/emoticons/happy.gif"></SPAN></P></BODY></HTML> Wed, 23 Apr 2014 07:37:41 GMT Tomas_Buryanek 2014-04-23T07:37:41Z Sorting Issue https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/10292049#M1832989 <HTML><HEAD></HEAD><BODY><P>Hi Experts</P><P></P><P>I have an internal table which has customer master texts</P><P></P><P>Sort statement is done after fetching all&nbsp; the customer texts from different text id</P><P></P><P>sort regio kunnr txtid</P><P></P><P>before sorting</P><P></P><P>table contents are</P><P></P><P>regio&nbsp;&nbsp; kunnr&nbsp;&nbsp;&nbsp;&nbsp; txtid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tdtext&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; text</P><P>inv&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp; z001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shipping instructions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; site id......</P><P>inv&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp; z001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shipping instructions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dxx.....</P><P>inv&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp; z001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shipping instructions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cons......</P><P></P><P>after sorting</P><P>inv&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp; z001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shipping instructions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cons......</P><P>inv&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp; z001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shipping instructions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; site id......</P><P>inv&nbsp;&nbsp;&nbsp;&nbsp; 20000&nbsp;&nbsp;&nbsp;&nbsp; z001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; shipping instructions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; dxx.....</P><P></P><P>even though the sorting is done on regio kunnr and txtid but the text is also getting effected</P><P></P><P>Can you please explain the reason</P><P>Is there any way to solve this issue&nbsp; </P><P></P><P>Thanks</P><P>Pawan Akella</P></BODY></HTML> Wed, 23 Apr 2014 06:53:27 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/10292049#M1832989 former_member191728 2014-04-23T06:53:27Z Re: Sorting Issue https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/10292050#M1832990 <HTML><HEAD></HEAD><BODY><P>I haven't used it yet, but try use addition STABLE to SORT statement <SPAN __jive_emoticon_name="happy" __jive_macro_name="emoticon" class="jive_macro jive_emote" src="https://community.sap.com/748/images/emoticons/happy.gif"></SPAN></P></BODY></HTML> Wed, 23 Apr 2014 07:37:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/10292050#M1832990 Tomas_Buryanek 2014-04-23T07:37:41Z Re: Sorting Issue https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/10292051#M1832991 <HTML><HEAD></HEAD><BODY><P>Hello Pawan,</P><P>&nbsp; Can you try with <STRONG>SORT itab AS TEXT</STRONG>. Hope this will solve your issue. Please let know.</P><P></P><P>Regards,</P><P>Anubhab</P></BODY></HTML> Wed, 23 Apr 2014 07:41:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/10292051#M1832991 anubhab 2014-04-23T07:41:56Z Re: Sorting Issue https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/10292052#M1832992 <HTML><HEAD></HEAD><BODY><P>Hi Pawan,</P><P></P><P>Try tomas suggested solution.It should work.</P><P></P><P>Regards,</P><P>Sudeesh Soni</P></BODY></HTML> Wed, 23 Apr 2014 07:47:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-issue/m-p/10292052#M1832992 Former Member 2014-04-23T07:47:03Z