Need urgent advise on SQVI left join.
I am trying to link Purchasing Document Header with Delivery Item with Shipment Item and Header table. The purpose is to have all the PO/STO records with the corresponding shipment details. As there might be less records in the shipment table and all PO records will be need, I include an outer left join between LIPS and VTTP. I got what I want to have the PO records, DN number and shipment number, shipment number will be blank if there are no record. The issue arise when I add the VTTK table inner join with the VTTP, which is not returning any records. Can anyone pls tell me what have I done wrong?
Here is the join condition:
EKKO (EBELN) inner join EKPO (EBELN)
EKPO (EBELN, MATNR) inner join LIPS (MATNR, VGBEL)
LIPS (VBELN) left outer join VTTP (VBELN)
VTTP (TKNUM) inner join VTTK (TKNUM)