I need some help with an ABAP query, hope you all can provide me with some insight here.
In an existing ABAP query, I am required to edit it so that if a sales order item has been delivered, this sales order item must be excluded from the query output. This is done based on checking if VBUP-LFSTA = 'C' - in which case, the particular sales order item will be excluded from the query output.
In summary, here is what I've done to edit the query according to the requirement:-
JOIN tables in the query - I've added LIPS and VBUP tables to the existing query
Infoset query - I've added Delivery Status <> 'C' here
The selection screen of the query - filtering records by delivery status, VBUP-LFSTA <> 'C'
However, the resulting query output turned out to be inaccurate. Sales order items that have been delivered are shown in the output with the delivery status shown as 'B' here - when in fact, the delivery status of the specific sales order items in VBUP-LFSTA is actually 'C'.
What can I do to rectify this?
Please help. Any inputs will be greatly appreciated.
Many thanks in advance.