Circular Table Join between KNA1 & KNVP

[AdityaKapoor]

Hello, I am trying to use SQVI to build a table join and am struggling with one part of it. 

I would like to be able to use the company code and partner function in KNVP as selection criteria to find a list of customers with their name and address (I can easily add ADRC to the table join to get detailed address details if required) and who is the sales person responsible for that customer (KUNN2 in KNVP). 

When I build the link of KNA1 to KNVP using KUNNR, it gives me the customer name and address details (even if I have to add ADRC it's easy). Problem is that now I end up with a "customer number" for my sales person responsible in KUNN2. 

I need now to run the circular reference to again look up KUNN2 = KUNNR in KNA1 to get his name vs just his SAP Customer Number. I dont know how to run this circular lookup. Does anyone else have any clue how to do this?

[Suryaprakash13 · Accepted solution]

Hi @AdityaKapoor,

Add the KNA1 as an alias table(ZKAN1_1) and pass the KUNN2 = KUNNR in the new alias table ZKAN1_1 and take the required value.

Hope this helps!!!!

Thanks and Regards,
Surya.

[AdityaKapoor · Accepted solution]

Thank You! Had no clue I could do this. Also, quick question - if I am using SQVI for table join, its confusing in the final output to have Name 1 showing up twice... is there a way to change the heading of the column?