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.