topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Thu, 20 Dec 2007 05:57:19 GMT

SELECT SINGLE * FROM pa0028 WHERE pernr = pa0000-pernr.

Now i need to sort the std table :

SORT DESCENDING BY endda.

How can i do sooooooooo plz guide

Re: select query

former_member156446 — Thu, 20 Dec 2007 05:59:17 GMT

SELECT SINGLE * FROM pa0028 WHERE pernr = pa0000-pernr.

I dont see a table in the above select...

if it was say Itab

sort table itab by erdat descending.

Re: select query

kesavadas_thekkillath — Thu, 20 Dec 2007 06:00:59 GMT

You are just placing the data in Pa0028 header...so how can you sort it....sorting mechanism can be only performad in a itab....

If u want to fetch the last record form pa00028 then do this way.

SELECT SINGLE * FROM pa0028 WHERE pernr = pa0000-pernr order by pernr descending .

Re: select query

former_member194669 — Thu, 20 Dec 2007 06:03:21 GMT


SELECT SINGLE * FROM pa0028 WHERE pernr = pa0000-pernr
 order by pernr descending.

a®

Re: select query

Former Member — Thu, 20 Dec 2007 06:04:19 GMT

instead of using sorted by in where clause, better fetch data first and then sort like below

select * from pa0028 into table itab WHERE pernr = pa0000-pernr.

sort itab descending by endda.

if u are looking for a single record from database do like this.

SELECT * FROM pa0028

into wa_itab

upto 1 rows

sorted descending by endda

WHERE pernr = pa0000-pernr.

endselect.

Re: select query

former_member386202 — Thu, 20 Dec 2007 06:05:15 GMT

Hi,

Do like this

select * from pa0000 into table it_pa0000.

if not it_pa0000[] is initial.

select * from pa0028 into table it_pa0028

for all entries in it_pa0000

where pernr eq it_pa0000-pernr.

endif.

Regards,

Prashant

Re: select query

Former Member — Thu, 20 Dec 2007 06:19:53 GMT

this is giving error........

The SELECT SINGLE statement cannot contain the clause ORDER BY.

Re: select query

former_member156446 — Thu, 20 Dec 2007 06:24:00 GMT

that error is valid.. when u say to select single and say order by what ill it order,, it has only one... so better get data into internal table and use sort descending

SELECT * FROM pa0028

into table itab_pernr

WHERE pernr = pa0000-pernr.

sort table itab_pernr descending..

or as said in previous posts

SELECT * FROM pa0028

into table itab_pernr

WHERE pernr = pa0000-pernr

order by erdat.

Edited by: jackandjay on Dec 20, 2007 1:25 AM