topic Re: SELECT in Application Development and Automation Discussions

SELECT

Former Member — Mon, 26 Feb 2007 09:48:04 GMT

Hi ,

i need to select only one row from table eipa where the date(bedat) is the latest.

is anyone know how can i do this?

thanks,

dana.

Re: SELECT

Former Member — Mon, 26 Feb 2007 09:51:04 GMT

In the select query add the addition BYPASSING BUFFER which guarantees that the data you read is the most up to date

Re: SELECT

Former Member — Mon, 26 Feb 2007 09:52:16 GMT

SELECT SINGLE * FROM eipa 
              INTO TABLE i_eipa.
if sy-subrc = 0.
 SORT i_eipa descending by bedat.
 READ i_eipa INTO wa_eipa INDEX 1.
ENDIF.

Hope this solves ur query.

SELECT SINGLE * FROM eipa 
              INTO wa_eipa 
              ORDER BY bedat.

Reward if this helsp.

Re: SELECT

Former Member — Mon, 26 Feb 2007 09:52:25 GMT

Hi ,

u can try as follows.

select max( bedat ) from eipa into v_bedat where (your condtions).

select * from eipa where bedat = v_bedat.

Regards,

Sumit

Re: SELECT

Former Member — Mon, 26 Feb 2007 09:52:40 GMT

Hello,

Check this:

Try using the below

Select * from eipa 
up to 1 rows
where ....
order by object bedat descending.

Vasanth

Re: SELECT

Former Member — Mon, 26 Feb 2007 09:52:49 GMT

Hi,

You can sort the internal table and then read the first row.

select * from eipa into table itab.

sort itab descending by bedat.

read table itab into wa_itab index 1.

regards,

Beejal

**reward if this helps

Re: SELECT

sreeramkumar_madisetty — Mon, 26 Feb 2007 09:54:45 GMT

You can use select single or select upto 1 rows for your requirement.

Regards,

kumar

Re: SELECT

anversha_s — Mon, 26 Feb 2007 09:54:55 GMT

hi,

chk this.

1. select all the records to an internal table.

2. sort by date.

3. read the internal table, the latest bedat will be in top.

Regards

Anver

Re: SELECT

Former Member — Mon, 26 Feb 2007 09:59:11 GMT

Dana,

CLEAR EIPA.

SELECT MAX( bedat ) FROM EIPA INTO eipa-bedat

WHERE ........your conditions.

if not eipa-bedat is initial.

select * from eipa where bedat = eipa-bedat.

endif.

pls. reward if useful

Re: SELECT

Former Member — Mon, 26 Feb 2007 10:01:20 GMT

hi dana,

try this:

TABLES: EIPA.

SELECT * FROM EIPA order by bedat descending.

write: eipa-infnr.

exit.

ENDSELECT.

regards, dieter

Re: SELECT

Former Member — Mon, 26 Feb 2007 12:31:56 GMT

thank you very much,for all your replies.

you helped me solve the problem,

thank you very much.