Skip to Content
0
Former Member
Feb 20, 2014 at 05:00 AM

Outer left join in SQVI

1520 Views


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)

Attachments

SQVI query.jpg (243.6 kB)