Skip to Content
0
Former Member
Jul 05, 2009 at 12:26 PM

need logic for VBREVE table data fetching

619 Views

Hi all,

i am fetching the Data from VBREVE table. I have a sales Document which is Invoiced and then reversed and again Invoiced.

So, in the VBREVE table i have 3 line items.

example:

VBELN POSNR BDJPOPER WRBTR RVAMT

0010000063 000010 2008009 192,00- 0,00

0010000063 000010 2008009 192,00 0,00

0010000063 000010 2008009 192,00- 192,00-

i have similar kind of sales orders. i am taking VBELN , POSNR , BDJPOPER , WRBTR , RVAMT into one table. and in that table i don't want to take the lines which are invoiced and again reversed

0010000063 000010 2008009 192,00- 0,00

0010000063 000010 2008009 192,00 0,00.

i want to take only the line 0010000063 000010 2008009 192,00- 192,00-

How to do that.

Thanks

Kamala.