Skip to Content
0
Former Member
Dec 19, 2007 at 09:37 PM

Gross and net sales value from invoice

1449 Views

Hi All,

I am getting VBRK-NETWR(net value) and KONV-KWERT(gross value), but gross value less than the net value in many cases, am I not getting it properly? Are the fields I used correct or not? Please help me.

Thanks,

Veni.

SELECT vbeln netwr erdat kunag

INTO TABLE ivbrk

FROM vbrk

WHERE erdat IN s_erdat.

SELECT SINGLE knumv

FROM vbrk INTO lv_knumv

WHERE vbeln = ivbrk-vbeln.

SELECT SINGLE kwert

FROM konv INTO lv_kwert

WHERE knumv = lv_knumv

AND kschl = 'PR00'.