topic Re: Get Last Document from document flow in Application Development and Automation Discussions

Get Last Document from document flow

Former Member — Fri, 09 Mar 2007 07:22:57 GMT

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!

Re: Get Last Document from document flow

Former Member — Fri, 09 Mar 2007 07:32:37 GMT

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

Re: Get Last Document from document flow

Former Member — Fri, 09 Mar 2007 07:34:57 GMT

Use Decending keyword

Regards

Re: Get Last Document from document flow

Former Member — Fri, 09 Mar 2007 07:42:04 GMT

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

Re: Get Last Document from document flow

Former Member — Fri, 09 Mar 2007 07:50:34 GMT

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