Sales order. ImP
we are getting all the order which are not rejected look at the statement below
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..
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