07-03-2006 2:37 PM
hi to every one,
i want the latest status for corresponding sequential no
table(staus table zstatus)
zstat(status) zseq(seq number)
dan 1
dan 2
dan 3
cann 1
cann 2
i want to fetch latest status ie dan which is having seq no 3.ok
plz help me in this issue.
07-03-2006 2:40 PM
Hi,
select zstat max( zseq )
into table ...
from zstatus
group by zstat.
Rgd
Frédéric
07-03-2006 2:40 PM
Hi,
select zstat max( zseq )
into table ...
from zstatus
group by zstat.
Rgd
Frédéric
07-03-2006 2:41 PM
Hello Rajkumar,
U can try this code.
data: itab like zstatus occurs 0 with header line.
Select * into itab where zstat = 'DAN'.
Sort itab by zseq desending.
read table itab index 1.
I tink this code will solve ur problem.
Regards,
Vasanth
07-05-2006 8:19 AM
hi to all
iam devolping an alv report i need an urgent help in that plz help me in this issue
plz i want a status and actual date for cooresponding max sequential no which is in some z table. plz help me in this issuue . it is urgent.