topic Sorting sequence disturbed in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sorting-sequence-disturbed/m-p/5799521#M1311421 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>I am sorting an internal table like</P><P></P><PRE><CODE>sort ITAB by F1 F3 F4.</CODE></PRE><P></P><P>but after this sort I lost my sequence and grouping of VBELN PONR. which is as below:</P><P>VBELN----<DEL>-POSNR</DEL>--<DEL>-F1</DEL><DEL></DEL></P><HR originaltext="--------" /> F2<DEL><HR originaltext="--------" />F3</DEL>--<P></P><HR originaltext="--------" /><P>F4 </P><P>80011864<DEL>- 40</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V110----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V110----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011867<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V150----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 30</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011865<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- <STRONG>V000</STRONG> &lt;&lt;&lt; GER----<P></P><HR originaltext="----" /><P> CSL </P><P></P><P>I can't add VBELN and POSNR in the sort statment coz it ll make my o/p like</P><P>VBELN----<DEL>-POSNR</DEL>--<DEL>-F1</DEL><DEL></DEL></P><HR originaltext="--------" /> F2<DEL><HR originaltext="--------" />F3</DEL>--<P></P><HR originaltext="--------" /><P>F4 </P><P>80011864<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 30</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 40</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011865<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- <STRONG>V000</STRONG> &lt;&lt;&lt; GER----<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011867<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V150----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P></P><P>Here F2 with value 'V000' is placed in between the 80011864 and 80011866 data which is useless as we have to sort on only F1 F3 and F4. So i can't add F2 in sort sequence.</P><P></P><P>i want my output like</P><P>VBELN----<DEL>-POSNR</DEL>--<DEL>-F1</DEL><DEL></DEL></P><HR originaltext="--------" /> F2<DEL><HR originaltext="--------" />F3</DEL>--<P></P><HR originaltext="--------" /><P>F4 </P><P>80011864<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 30</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 40</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011865<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V000----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011867<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V150----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P> </P><P>Please Help to solve this sorting problem.</P><P></P><P></P><P>-Maharshi</P></BODY></HTML> Wed, 01 Jul 2009 13:14:17 GMT Former Member 2009-07-01T13:14:17Z Sorting sequence disturbed https://community.sap.com/t5/application-development-and-automation-discussions/sorting-sequence-disturbed/m-p/5799521#M1311421 <HTML><HEAD></HEAD><BODY><P>Hello Friends,</P><P></P><P>I am sorting an internal table like</P><P></P><PRE><CODE>sort ITAB by F1 F3 F4.</CODE></PRE><P></P><P>but after this sort I lost my sequence and grouping of VBELN PONR. which is as below:</P><P>VBELN----<DEL>-POSNR</DEL>--<DEL>-F1</DEL><DEL></DEL></P><HR originaltext="--------" /> F2<DEL><HR originaltext="--------" />F3</DEL>--<P></P><HR originaltext="--------" /><P>F4 </P><P>80011864<DEL>- 40</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V110----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V110----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011867<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V150----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 30</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011865<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- <STRONG>V000</STRONG> &lt;&lt;&lt; GER----<P></P><HR originaltext="----" /><P> CSL </P><P></P><P>I can't add VBELN and POSNR in the sort statment coz it ll make my o/p like</P><P>VBELN----<DEL>-POSNR</DEL>--<DEL>-F1</DEL><DEL></DEL></P><HR originaltext="--------" /> F2<DEL><HR originaltext="--------" />F3</DEL>--<P></P><HR originaltext="--------" /><P>F4 </P><P>80011864<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 30</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 40</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011865<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- <STRONG>V000</STRONG> &lt;&lt;&lt; GER----<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011867<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V150----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P></P><P>Here F2 with value 'V000' is placed in between the 80011864 and 80011866 data which is useless as we have to sort on only F1 F3 and F4. So i can't add F2 in sort sequence.</P><P></P><P>i want my output like</P><P>VBELN----<DEL>-POSNR</DEL>--<DEL>-F1</DEL><DEL></DEL></P><HR originaltext="--------" /> F2<DEL><HR originaltext="--------" />F3</DEL>--<P></P><HR originaltext="--------" /><P>F4 </P><P>80011864<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 30</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011864<DEL>- 40</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011866<DEL>- 20</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V100----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011865<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V000----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P>80011867<DEL>- 10</DEL><DEL></DEL></P><HR originaltext="------" /> 300730---- V150----<DEL>- GER</DEL>--<P></P><HR originaltext="----" /><P> CSL </P><P> </P><P>Please Help to solve this sorting problem.</P><P></P><P></P><P>-Maharshi</P></BODY></HTML> Wed, 01 Jul 2009 13:14:17 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-sequence-disturbed/m-p/5799521#M1311421 Former Member 2009-07-01T13:14:17Z Re: Sorting sequence disturbed https://community.sap.com/t5/application-development-and-automation-discussions/sorting-sequence-disturbed/m-p/5799522#M1311422 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><PRE><CODE>SORT ITAB by F1 F3 F4 F2 VBELN POSNR. You get the out as follows VBELN-------POSNR-------F1------------- F2-------------F3-------------F4 80011865--- 10----------- 300730------ V000------- GER--------- CSL 80011867--- 10----------- 300730------ V150------- GER--------- CSL 80011864--- 10----------- 300730------ V100------- GER--------- CSL 80011864--- 20----------- 300730------ V100------- GER--------- CSL 80011864--- 30----------- 300730------ V100------- GER--------- CSL 80011864--- 40----------- 300730------ V100------- GER--------- CSL 80011866--- 10----------- 300730------ V100------- GER--------- CSL 80011866--- 20----------- 300730------ V100------- GER--------- CSL</CODE></PRE><P></P></BODY></HTML> Wed, 01 Jul 2009 13:42:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-sequence-disturbed/m-p/5799522#M1311422 Former Member 2009-07-01T13:42:11Z Re: Sorting sequence disturbed https://community.sap.com/t5/application-development-and-automation-discussions/sorting-sequence-disturbed/m-p/5799523#M1311423 <HTML><HEAD></HEAD><BODY><P>F2, F3, F4 have same value through out.. how will the sort work???</P><P></P><P>and on what basis 80011865 is coming between 80011866 and 80011867</P></BODY></HTML> Wed, 01 Jul 2009 13:43:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-sequence-disturbed/m-p/5799523#M1311423 Former Member 2009-07-01T13:43:12Z Re: Sorting sequence disturbed https://community.sap.com/t5/application-development-and-automation-discussions/sorting-sequence-disturbed/m-p/5799524#M1311424 <HTML><HEAD></HEAD><BODY><P>Please read the help on SORT. You will see that one of the options is STABLE. That will preserve the order for fields that are not in the SORT field list.</P><P></P><P>Rob</P></BODY></HTML> Wed, 01 Jul 2009 16:18:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-sequence-disturbed/m-p/5799524#M1311424 Former Member 2009-07-01T16:18:47Z