Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Deliveries with no / incomplete invoice

Former Member
0 Kudos
69

I'm writing a list based on deliveries with no / incomplete invoice. At this moment i'm using the VBUP table joined with LIKP to get the sales org. My coding looks like

SELECT avbeln aposnr b~vkorg

INTO (i_data-vbeln, i_data-posnr, i_data-vkorg)

FROM vbup AS a

JOIN likp AS b

ON avbeln = bvbeln

WHERE a~vbeln GE '0080000000'

AND a~vbeln LE '0089999999'

AND a~posnr LT '900001'

AND a~fksta NE 'C'

AND b~vkorg IN p_vkorg.

I was wondering if this is the best way to know the deliveries with no / incomplete invoice. Does anybody know a better table, view ... to use.

1 REPLY 1

Former Member
0 Kudos
46

What version of R/3 are you running?

And why not run a Billing Due List - VL04 ?