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.