topic Sorting in SAP Query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sorting-in-sap-query/m-p/6031912#M1349480 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P>We have a Query for tables EBAN and EBKN with some additional fields fetched from Add-On Tables.</P><P></P><P>This Query had a performance issue, therefore we created new Program with the existing logic of Query.</P><P></P><P>This program woks well with improved performance. But the order of the records (Sorting)is different from the Query however the number of records and the data is absolutely correct.</P><P></P><P>On analysis found that in Query FGroups was used and the sorting was done by command 'SORT AS TEXT' on the extract dataset. But i could not figure out the fields on which the sorting happening in the query.</P><P></P><P>Would like to know the SORTING order in this situation !! Has anybody faced this issue ? Any input will be appreciable.</P><P></P><P>Thanks In Advance.</P><P></P><P>Praveen</P></BODY></HTML> Tue, 04 Aug 2009 08:24:02 GMT Former Member 2009-08-04T08:24:02Z Sorting in SAP Query https://community.sap.com/t5/application-development-and-automation-discussions/sorting-in-sap-query/m-p/6031912#M1349480 <HTML><HEAD></HEAD><BODY><P>HI All,</P><P></P><P>We have a Query for tables EBAN and EBKN with some additional fields fetched from Add-On Tables.</P><P></P><P>This Query had a performance issue, therefore we created new Program with the existing logic of Query.</P><P></P><P>This program woks well with improved performance. But the order of the records (Sorting)is different from the Query however the number of records and the data is absolutely correct.</P><P></P><P>On analysis found that in Query FGroups was used and the sorting was done by command 'SORT AS TEXT' on the extract dataset. But i could not figure out the fields on which the sorting happening in the query.</P><P></P><P>Would like to know the SORTING order in this situation !! Has anybody faced this issue ? Any input will be appreciable.</P><P></P><P>Thanks In Advance.</P><P></P><P>Praveen</P></BODY></HTML> Tue, 04 Aug 2009 08:24:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-in-sap-query/m-p/6031912#M1349480 Former Member 2009-08-04T08:24:02Z Re: Sorting in SAP Query https://community.sap.com/t5/application-development-and-automation-discussions/sorting-in-sap-query/m-p/6031913#M1349481 <HTML><HEAD></HEAD><BODY><P>Closing this thread.</P></BODY></HTML> Wed, 05 Aug 2009 01:31:31 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sorting-in-sap-query/m-p/6031913#M1349481 Former Member 2009-08-05T01:31:31Z