SQVI - Need Outer Join for License table KNVL with KNA1

[Former Member]

Hello All,

I am trying to run a Quickview SQVI tcode for the following tables: KNA1, KNVL (license table) and KNVI (tax classification table).

I am trying to do an OUTER join between KNA1 and KNVL to return ALL customers from KNA1 that may OR may not

have a license record in table KNVL.

If I do a regular join between all 3 of these tables, I return only the 43 customers that DO have licenses. I want

a list of all customers I select from KNA1 - and display the 43 customers that have a license in KNVL as well as

the customers that do not.

I believe a outer join is used when you want to show entries in 1 table that are not in a second table?

Thank you -

LCP

Edited by: LCPicker on Apr 21, 2011 10:34 AM

Edited by: LCPicker on Apr 21, 2011 10:35 AM

[od_manikandan]

Hai LCPicker,

As you rightly mentioned Outer join can bring all the entries of KNA1 and KNVL entries (with value / Without value).

To make a outer join in SQVI.

Open the same SQVI in change mode,

GO TO LAYOUT MODE (F5),

GOTO DATA SOURCE tab in the right,

Change JOIN.

In the LIST DESIGN,

Select the link and right click -- Select LEFT OUTER JOIN.

Now you will get all the full report.

Regards,

Mani

[Former Member]

While you select the KUNNR field for display as output result please take KNA1-KUNNR instead of any other.

Hope this will resolve your problem.

Rgds

Dhiraj Bhaskar

[Shiva_Ram]

Check whether adding table KNVV in the query would help.

Regards,