Skip to Content
Former Member
Oct 20, 2016 at 06:37 AM

Output of Join in graphical calculation view

243 Views Last edit Oct 24, 2016 at 10:31 PM 2 rev

Hi ,

In my graphical calculation view I am joining VBAP and LIPS table on sales doc and sales Item fields.

VBAP - Sales_doc, Sales_Item

LIPS - Sales_doc, Sales_Item, Del_doc, Del_item

When I join these 2 tables, I will get the sales orders which are delivered. But I also need the information of sales orders which are not delivered. If I perform a join on these 2 tables, I will miss out the orders which are not delivered. I Union the output of VBAP and JOin of VBAP and LIPS, I will get the duplicate rows meaning. If a Sales order has a delivery entry, I will get 2 rows . 1 for sales orders without delivery information and the second row with sales and delivery information.

Please help.