topic Re: Doubt in Select statement in Application Development and Automation Discussions

Doubt in Select statement

Former Member — Tue, 30 Oct 2007 11:42:09 GMT

Hi,

I want to select last record from the standard table. ie i want to select the record from pbhi using bdzei and pdatu. if i used that in where condition its fetching the records but i expect last record from the PBHI table. can any one plz give soln.

Point will be sure.

Gowri

Re: Doubt in Select statement

Azeemquadri — Tue, 30 Oct 2007 11:46:16 GMT

select data in itab.

sort the itab by pdatu descending.

and pick the first record .

Re: Doubt in Select statement

former_member189059 — Tue, 30 Oct 2007 11:47:39 GMT

Select into workarea

endselect

append workarea to itab

Re: Doubt in Select statement

Former Member — Tue, 30 Oct 2007 11:47:42 GMT

Hi Gowri,

Once you retrived the whole data into an internal table do like this

describe table itab lines gv_lines.

 read table itab into wa index gv_lines.
 if sy-subrc = 0.
  delete itab.
  append wa to itab.
  clear wa.
 endif.

<b>Reward points for helpful answers</b>

Satish

Re: Doubt in Select statement

Former Member — Tue, 30 Oct 2007 11:50:25 GMT

Hi,

Sort the internal table by bdzei pdatu acsending order and read the valule.

Ex : sort itab descending by <field>.

read table itab <field> index 1.

val = itab-field.

Thanks,

Sriram Ponna.

Re: Doubt in Select statement

Former Member — Tue, 30 Oct 2007 13:32:38 GMT

Do this:

SELECT        * FROM  pbhi
  UP TO 1 ROWS
  ORDER BY bdzei DESCENDING
           pdatu  DESCENDING.

ENDSELECT.

Rob