Skip to Content
Oct 07, 2014 at 10:25 AM

Needing help with ABAP Query


Dear forumers,

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.



Join.jpg (208.3 kB)
query screen.jpg (48.6 kB)
infoset.jpg (111.2 kB)