topic Re: Sorting an internal table by date. in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514321#M236891 <HTML><HEAD></HEAD><BODY><P>Hello J.J</P><P></P><P>The explicit version of your SORT statement is:</P><PRE><CODE>SORT it_stpo BY andat ASCENDING stpoz DESCENDING.</CODE></PRE><P></P><P>Because ASCENDING is the default sorting direction.</P><P>If you want to sort all fields of your itab in descending order your statement must look like:</P><PRE><CODE>SORT it_stpo DESCENDING BY andat stpoz.</CODE></PRE><P></P><P>Regards</P><P> Uwe</P></BODY></HTML> Mon, 14 Aug 2006 20:02:53 GMT uwe_schieferstein 2006-08-14T20:02:53Z Sorting an internal table by date. https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514314#M236884 <HTML><HEAD></HEAD><BODY><P>SORT it_stpo BY andat stpoz DESCENDING.</P><P></P><P> before sort</P><P> DATUV ANDAT STLKN STPOZ </P><P>1. 20020118|20020118|00000002|00000004|</P><P>2. 20060711|20060811|00000004|00000008|</P><P>3. 20060801|20060811|00000005|00000011</P><P>4. 20020515|20020515|00000003|00000006</P><P></P><P>AFTER SORT..</P><P> DATUV ANDAT STLKN STPOZ </P><P>1. 20020118|20020118|00000002|00000004</P><P>2. 20020515|20020515|00000003|00000006|</P><P>3. 20060801|20060811|00000005|00000011</P><P>4. 20060711|20060811|00000004|00000008|</P><P></P><P>what I expected was to see Record # 3 as my first record after the sort ?</P><P></P><P>Any ideas?</P></BODY></HTML> Mon, 14 Aug 2006 19:55:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514314#M236884 Former Member 2006-08-14T19:55:11Z Re: Sorting an internal table by date. https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514315#M236885 <HTML><HEAD></HEAD><BODY><P>Are you sure DATUV &amp; ANDAT are of type DATS?</P><P></P><P>~Suresh</P></BODY></HTML> Mon, 14 Aug 2006 19:58:44 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514315#M236885 suresh_datti 2006-08-14T19:58:44Z Re: Sorting an internal table by date. https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514316#M236886 <HTML><HEAD></HEAD><BODY><P>You either need to explicitly state "descending" after each filed in the sort statement or one time before all fields. Your statement actually translates to sort it_stpo by andat ascending stpoz descending.</P></BODY></HTML> Mon, 14 Aug 2006 20:00:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514316#M236886 Former Member 2006-08-14T20:00:01Z Re: Sorting an internal table by date. https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514317#M236887 <HTML><HEAD></HEAD><BODY><P>typed as follows:</P><P></P><P></P><P> BEGIN OF it_stpo OCCURS 10,</P><P> datuv TYPE stpo-datuv,</P><P> andat TYPE stpo-andat,</P><P> stlkn TYPE stpo-stlkn,</P><P> stpoz TYPE stpo-stpoz,</P><P> ltxsp TYPE stpo-ltxsp,</P><P> potx1 TYPE stpo-potx1,</P><P> END OF it_stpo.</P></BODY></HTML> Mon, 14 Aug 2006 20:00:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514317#M236887 Former Member 2006-08-14T20:00:23Z Re: Sorting an internal table by date. https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514318#M236888 <HTML><HEAD></HEAD><BODY><P>Can you please try this statement instead.</P><P></P><P></P><P></P><PRE><CODE> sort it_stpo descending by andat stpoz . </CODE></PRE><P></P><P>Regards,</P><P>Rich Heilman</P></BODY></HTML> Mon, 14 Aug 2006 20:00:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514318#M236888 RichHeilman 2006-08-14T20:00:54Z Re: Sorting an internal table by date. https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514319#M236889 <HTML><HEAD></HEAD><BODY><P>SORT it_stpo BY andat DESCENDING stpoz DESCENDING.</P></BODY></HTML> Mon, 14 Aug 2006 20:01:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514319#M236889 Former Member 2006-08-14T20:01:40Z Re: Sorting an internal table by date. https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514320#M236890 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please try this.</P><P></P><PRE><CODE>SORT it_stpo BY andat DESCENDING stpoz DESCENDING.</CODE></PRE><P></P><P>Regards,</P><P>Ferry Lianto</P></BODY></HTML> Mon, 14 Aug 2006 20:02:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514320#M236890 Former Member 2006-08-14T20:02:09Z Re: Sorting an internal table by date. https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514321#M236891 <HTML><HEAD></HEAD><BODY><P>Hello J.J</P><P></P><P>The explicit version of your SORT statement is:</P><PRE><CODE>SORT it_stpo BY andat ASCENDING stpoz DESCENDING.</CODE></PRE><P></P><P>Because ASCENDING is the default sorting direction.</P><P>If you want to sort all fields of your itab in descending order your statement must look like:</P><PRE><CODE>SORT it_stpo DESCENDING BY andat stpoz.</CODE></PRE><P></P><P>Regards</P><P> Uwe</P></BODY></HTML> Mon, 14 Aug 2006 20:02:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-an-internal-table-by-date/m-p/1514321#M236891 uwe_schieferstein 2006-08-14T20:02:53Z