topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Fri, 18 Apr 2008 13:37:39 GMT

I have a database table in which i have two fields

startdate and enddate

suppose i have 10 records inmy database table i want to

01.01.2000 31.01.2000

01.02.2000 28.02.2000

and so on

and the last record is

01.10.2000 31.10.2000

now i want to write a select statement to retrieve the latest date ie the last record

can anyone help me in this

Re: select statement

Former Member — Fri, 18 Apr 2008 13:39:12 GMT

select max ( date ) from <database table> where <Condition>.

Regards,

Ravi Kanth Talagana

Re: select statement

Former Member — Fri, 18 Apr 2008 13:41:12 GMT

Write the select as :

select * from <table> into table itab

where startdate <= enddate

and enddate >= startdate.

if sy-subrc = 0.

sort itab by enddate descending.

endif.

Re: select statement

Former Member — Fri, 18 Apr 2008 13:41:47 GMT

hi,

do this way ....


select * from <table> into table itab where <conditions>.
if sy-subrc = 0.
  sort itab by end_date descending.
  read table itab index 1.
  if sy-subrc = 0.
   < this will give the latest end date record >
  endif.
endif.

Re: select statement

Former Member — Fri, 18 Apr 2008 13:45:28 GMT

guys i know the way of getting the data in the internal table and sorting it

but is there any select single statement that i can apply here

Re: select statement

Former Member — Fri, 18 Apr 2008 13:45:54 GMT

Hello,


select single * from <table> into <ls_table> order by final_date descending .

Regards,

Re: select statement

Former Member — Fri, 18 Apr 2008 13:47:11 GMT

Hey Ram,u can use a macro : rp_provide_from_last to retrive latest record from the internal table.Lets say u r program flow is like this.

Tables : Pernr.

Infotypes : 0002.

Get pernr.

RP_PROVIDE_FROM_LAST P0002 SPACE PN-BEGDA PN-ENDDA.

IF PNP-SW-FOUND NE 1

REJECT.

ENDIF.

Hope u got it.If found useful Reward points.

Re: select statement

Former Member — Fri, 18 Apr 2008 13:47:45 GMT

thanks

Re: select statement

Former Member — Fri, 18 Apr 2008 13:47:55 GMT

Check this..

select * from <table>
up to 1 rows
into wa 
where condition
order by date descending.
endselect.


example: ---

data: wa type vbap.

select * from 
vbap up to 1 rows
into wa
where vbeln eq '1234' 
order by posnr descending.
endselect.

Re: select statement

Former Member — Fri, 18 Apr 2008 13:58:13 GMT

hi ram

here is the query which will be help fl to u and also satisfy all test case

let ur table name is itab with headerline.

select startdate

enddate

into ( itab-startdate , itab-enddate )

from itab

where

startdate = max ( startdate )

enddate = max ( enddate ) .

if sy-subrc = 0 .

if startdate = enddate.

write:/ enddate.

elseif startdate is < enddate.

write:/ enddate.

endif.

Reward if helpfull.