plz help:getting latest status from the seq num

[Former Member]

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.

[FredericGirod]

Hi,

select zstat max( zseq )
       into table ...
       from zstatus
       group by zstat.

Rgd

Frédéric

[Former Member]

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

[Former Member]

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.