‎2010 Jul 06 2:40 PM
For every sales order we need the order quantity, delivered quantity and the open quantity and the unit type should be sales unit (not base unit). The item which is completed & rejected should not display in the report and for the item which is partially rejected open quantity should be 0.
‎2010 Jul 06 2:55 PM
Order quantity is in table VBAP, Delivered quantity is in table VBFA. Calculate the difference. Check you status codes in VBUK and VBUP, as appropriate to header or item level, or check the item rejection reason, as your specs require.
Note: the forum is a place to obtain help with specific problems; it is not a "do my work for me" source...you do the work, then post specific problems or questions that you cannot find an answer for in ABAP Help or by searching the forums, and you'll find people willing to try to help you.
‎2010 Jul 06 4:24 PM