topic Re: Can We Sort A Database Table... in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737616#M320735 <HTML><HEAD></HEAD><BODY><P>1)If you want to sort the data, you would most probably be needing to do it for the purpose of a report or some other application. In that case, you would have to fetch the data from the database table into an internal table in your program and then sort the data using the SORT statement on internal table</P><P>2)If you are seeing the contents using SE16, its a ALV grid, so you can sort by whatever field you want.</P></BODY></HTML> Tue, 26 Dec 2006 10:27:00 GMT Former Member 2006-12-26T10:27:00Z Can We Sort A Database Table... https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737612#M320731 <HTML><HEAD></HEAD><BODY><P>Hi there...</P><P></P><P>I have to display a sap script....where the data will come directly from the data base tables and structures that are there in SAP...now the requirement is that particular field of a databse table has to be sorted before getting printed on to the SAP script...can anyone provide any leads...on this...</P><P></P><P>Pablo</P></BODY></HTML> Tue, 26 Dec 2006 10:21:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737612#M320731 Former Member 2006-12-26T10:21:53Z Re: Can We Sort A Database Table... https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737613#M320732 <HTML><HEAD></HEAD><BODY><P>read data in internal table and then do sorting in ur program on internal table and then pass the data to ur SAP script it wil be more effieicent..</P><P>amit</P></BODY></HTML> Tue, 26 Dec 2006 10:24:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737613#M320732 Former Member 2006-12-26T10:24:47Z Re: Can We Sort A Database Table... https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737614#M320733 <HTML><HEAD></HEAD><BODY><P>We can sort the data of a DB table at Internal table level. like....</P><P></P><P>select * from mara into table itab.</P><P>sort itab by natnr.</P><P></P><P>loop at itab.</P><P>write: itab.</P><P>endloop.</P><P></P><P>Cheers.</P></BODY></HTML> Tue, 26 Dec 2006 10:24:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737614#M320733 Former Member 2006-12-26T10:24:56Z Re: Can We Sort A Database Table... https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737615#M320734 <HTML><HEAD></HEAD><BODY><P>If the program is a customized one, we can get the data into an internal table, SORT and then issue for printing.</P><P></P><P>Kind Regards</P><P>Eswar</P></BODY></HTML> Tue, 26 Dec 2006 10:25:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737615#M320734 Former Member 2006-12-26T10:25:36Z Re: Can We Sort A Database Table... https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737616#M320735 <HTML><HEAD></HEAD><BODY><P>1)If you want to sort the data, you would most probably be needing to do it for the purpose of a report or some other application. In that case, you would have to fetch the data from the database table into an internal table in your program and then sort the data using the SORT statement on internal table</P><P>2)If you are seeing the contents using SE16, its a ALV grid, so you can sort by whatever field you want.</P></BODY></HTML> Tue, 26 Dec 2006 10:27:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737616#M320735 Former Member 2006-12-26T10:27:00Z Re: Can We Sort A Database Table... https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737617#M320736 <HTML><HEAD></HEAD><BODY><P>ur getting data from database and printing on sap script...but before printing, ur getting data from database to internal table or fields....U can just sort this one and print according to ur requirements.</P></BODY></HTML> Tue, 26 Dec 2006 10:59:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737617#M320736 Former Member 2006-12-26T10:59:19Z Re: Can We Sort A Database Table... https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737618#M320737 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>we can sort only I.T. it is not possible to sort dbt</P><P>If the program is a customized one, we can get the data into an internal table, SORT and then issue for printing.</P><P></P><P></P><P>deepak</P></BODY></HTML> Tue, 26 Dec 2006 14:21:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/can-we-sort-a-database-table/m-p/1737618#M320737 Former Member 2006-12-26T14:21:43Z