topic SORTing problems in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sorting-problems/m-p/6235376#M1381297 <HTML><HEAD></HEAD><BODY><P>Ladies &amp; Gentlemen</P><P></P><P>I am facing a very peculiar issue with a simple SORT statement.</P><P></P><P>The scenario is this:</P><P></P><P>1) Generate a table of Sales Unit for F4 in the sales order item. The default order of display should be Ascending by SU.</P><P></P><P>Now if i look at std. SAP, the FM F4_ALLOWED_QUANTITY_UNIT gives out a table TQTUNITS, which is sorted as</P><P></P><P>SORT TQTUNITS BY FLAGSIQTUNIT.</P><P></P><P>inside the call of FM RV_HELP.</P><P></P><P>This is all std. SAP and we have just created entries in the table.</P><P></P><P>This SORT sorts the data correctly 1st time. Howeever, if i change the data at line item, say PLANT the SU's are re determined and then this SORT gives out the data in DESECENDING order. if in debug, i go back to the SORT and F5 it again, it sorts the data correctly. i am really confused why this is happening. </P><P></P><P>Any pointers to notes or some data data i need to reset or look into?</P><P></P><P>PS: i have already checked the tables are all refereshed correctly and there are no other SORTS on this very table.</P><P></P><P>Regards</P><P>Ravish</P></BODY></HTML> Tue, 06 Oct 2009 17:31:11 GMT Former Member 2009-10-06T17:31:11Z SORTing problems https://community.sap.com/t5/application-development-and-automation-discussions/sorting-problems/m-p/6235376#M1381297 <HTML><HEAD></HEAD><BODY><P>Ladies &amp; Gentlemen</P><P></P><P>I am facing a very peculiar issue with a simple SORT statement.</P><P></P><P>The scenario is this:</P><P></P><P>1) Generate a table of Sales Unit for F4 in the sales order item. The default order of display should be Ascending by SU.</P><P></P><P>Now if i look at std. SAP, the FM F4_ALLOWED_QUANTITY_UNIT gives out a table TQTUNITS, which is sorted as</P><P></P><P>SORT TQTUNITS BY FLAGSIQTUNIT.</P><P></P><P>inside the call of FM RV_HELP.</P><P></P><P>This is all std. SAP and we have just created entries in the table.</P><P></P><P>This SORT sorts the data correctly 1st time. Howeever, if i change the data at line item, say PLANT the SU's are re determined and then this SORT gives out the data in DESECENDING order. if in debug, i go back to the SORT and F5 it again, it sorts the data correctly. i am really confused why this is happening. </P><P></P><P>Any pointers to notes or some data data i need to reset or look into?</P><P></P><P>PS: i have already checked the tables are all refereshed correctly and there are no other SORTS on this very table.</P><P></P><P>Regards</P><P>Ravish</P></BODY></HTML> Tue, 06 Oct 2009 17:31:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-problems/m-p/6235376#M1381297 Former Member 2009-10-06T17:31:11Z Re: SORTing problems https://community.sap.com/t5/application-development-and-automation-discussions/sorting-problems/m-p/6235377#M1381298 <HTML><HEAD></HEAD><BODY><P>Ladies &amp; Gentlemen</P><P></P><P>I am facing a very peculiar issue with a simple SORT statement.</P><P></P><P>The scenario is this:</P><P></P><P>1) Generate a table of Sales Unit for F4 in the sales order item. The default order of display should be Ascending by SU.</P><P></P><P>Now if i look at std. SAP, the FM F4_ALLOWED_QUANTITY_UNIT gives out a table TQTUNITS, which is sorted as</P><P></P><P>SORT TQTUNITS BY FLAGSIQTUNIT.</P><P></P><P>inside the call of FM RV_HELP.</P><P></P><P>This is all std. SAP and we have just created entries in the table.</P><P></P><P>This SORT sorts the data correctly 1st time. Howeever, if i change the data at line item, say PLANT the SU's are re determined and then this SORT gives out the data in DESECENDING order. if in debug, i go back to the SORT and F5 it again, it sorts the data correctly. i am really confused why this is happening. </P><P></P><P>Any pointers to notes or some data data i need to reset or look into? Any help will be appreciated <SPAN __jive_emoticon_name="happy"></SPAN></P><P></P><P>Any pointers??</P><P></P><P>PS: i have already checked the tables are all refereshed correctly and there are no other SORTS on this very table.</P><P></P><P>Regards</P><P>Ravish</P></BODY></HTML> Wed, 07 Oct 2009 10:03:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-problems/m-p/6235377#M1381298 Former Member 2009-10-07T10:03:59Z