Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sales order. ImP

Hello,

we are getting all the order which are not rejected look at the statement below

SELECT vbap~vbeln

vbap~posnr

vbap~erdat

vbap~kzwi2

vbak~auart

vbak~kunnr

vbak~vkorg

vbak~vtweg

vbak~spart

INTO TABLE p_it_salesorders

FROM vbap INNER JOIN vbak

ON vbapvbeln = vbakvbeln

WHERE vbap~erdat BETWEEN l_ytddate AND p_last_date

AND ( vbak~auart = 'ZCR'

OR vbak~auart = 'ZOR'

OR vbak~auart = 'ZDR'

OR vbak~auart = 'ZKE'

OR vbak~auart = 'ZRP'

OR vbak~auart = 'ZRE' )

AND vbap~abgru EQ space.

And doing some calculations and showing the output in AVL..

I got a modified spec , the point is stated below:

NEW Spec point: Change the output so that it shows the Shipped $ values only (Order lines which are invoiced / Partially invoiced)

How do we get lines which are shipped( invoiced/partially invoiced.

may be we need to check in VBUk table.. donno exactly.. help me out..

regards,

nazeer

Edited by: N a z e e r on Oct 16, 2008 5:59 PM

Edited by: N a z e e r on Oct 16, 2008 6:12 PM

Edited by: N a z e e r on Oct 16, 2008 6:13 PM

Tags:
Not what you were looking for? View more on this topic or Ask a question