Skip to Content

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 16, 2008 at 12:49 PM

    Hello,

    Check with you functional team. I guess the tables to look at VBUK and VBUP. not sure though.

    regards,

    Advait

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 08:17 AM

    hi

    for overall rejection status check the field in VBUK-ABSTK.

    blank Not Relevant

    A Not yet processed

    B Partially processed

    C Completely processed

    Add comment
    10|10000 characters needed characters exceeded