Get Last Document from document flow

[Former Member]

I would like to retrieve last document flow's document. i use VBFA and pass Preceding sales and distribution document to where condition and get Subsequent sales and distribution document but i don't know how to get the latest one.

I use

select single VBELN into last_doc from vbfa

where VBELV = 'preceding doc'

order by ERDAT ERZET

but it's not work. How can i do that. Thanks!

[Former Member]

Hi,

Give descending..

select VBELN UP TO 1 ROWS

into last_doc from vbfa

where VBELV = 'preceding doc'

order by ERDAT ERZET <b>DESCENDING</b>

ENDSELECT.

THanks,

Naren

[Former Member]

The Error "The SELECT SINGLE statement cannot contain the clause ORDER BY." Thanks

[Former Member]

Use Decending keyword

Regards

[Former Member]

try like this

data : begin of vbfat occurs 0,
        last_doc like vbfa-vbeln,       
        last_date like vbfa-erdat,
        end of vbfat.
        
 select vbeln max( erdat ) into table vbfat from vbfa
        where VBELV = 'preceding doc'
          group by vbeln.
loop at vbfat.
<do the processing.>
endloop.

regards

shiba dutta