topic Re: Select single in Application Development and Automation Discussions

Select single

Former Member — Wed, 15 Apr 2009 11:56:47 GMT

Hi to every one

Can any one tell me how to get the latest updated record using select single.

Edited by: vinay raj on Apr 15, 2009 2:06 PM

Re: Select single

Former Member — Wed, 15 Apr 2009 12:06:34 GMT

Hi,

Can you write you select statement here?

I think you are not using key fileds in where condition.

Regards

Krishna

Re: Select single

Former Member — Wed, 15 Apr 2009 12:10:01 GMT

Hi Vinay,

You can do one thing.

take the records into table ITAB. insetead of SELECT SINGLE.....

then do below

SORT itab by date DESCENDING.
read table itab into wa with index 1.
if sy-subrc = 0.
append wa to itab_new..
endif.

now your ITAB_NEW having the latest record

Thanks!

Re: Select single

Former Member — Wed, 15 Apr 2009 12:18:38 GMT

Iam using this in smart form.

I want to display the latest process order number from afpo table.

the query is as follows :

select single aufnr from afpo into g_aufnr where matnr = caufvd-matnr.

CAUFVD is the structure.

Re: Select single

Former Member — Wed, 15 Apr 2009 12:26:27 GMT

hi,

try this it will get the latest process order number from afpo table




*latest process order number from afpo table.

SELECT max(aufnr) from afpo into g_aufnr 
 where matnr = caufvd-matnr

Regards,

Prabhudas

Re: Select single

Former Member — Wed, 15 Apr 2009 12:29:26 GMT

Hi,

Just verify is there any field is storing the creation or changing time of order. Otherwise there must be a date field. try to use those fields.

Re: Select single

kesavadas_thekkillath — Wed, 15 Apr 2009 12:32:34 GMT

not select single.

Ex: use select max( mblnr ) from mkpf.

Re: Select single

Former Member — Wed, 15 Apr 2009 12:36:48 GMT

Hi,

If you have something unique for identifying that last value in your table than use select single with where condition for retrieving last record.

Otherwise use

Select.

endselect.

for retrieving your last record from multiple line item.

Regards,

Himanshu

Re: Select single

former_member203501 — Wed, 15 Apr 2009 12:41:09 GMT

do one thing...

use if there is a date field use like this ..

sort it_tab by date descending .

read table it_tab index 1.

Re: Select single

Former Member — Wed, 15 Apr 2009 12:44:43 GMT

Hi,

use stmt.....

select max(AUFNR) from AFPO into var.

regards,

ajit.

Re: Select single

Former Member — Wed, 15 Apr 2009 12:46:31 GMT

use this

select the dat into itab1

SORT itab1 by date DESCENDING.

read table itab1 into w_itab with index 1.

if sy-subrc = 0.

append w_itab to itab2..

endif.

Re: Select single

Former Member — Wed, 15 Apr 2009 13:10:56 GMT

Thankyou for all your replies.

My issue has been resolved.

Re: Select single

Former Member — Wed, 15 Apr 2009 13:11:17 GMT

i got the solution