SQVI - Table join bet KNA1, ADRC and ADR6

[Former Member]

Hi All

I have created a query using SQVI and using the table join of KNA1, ADRC and ADR6. The connecting point between KNA! and ADRC is KUNNR and ADDR. And the connetion between ADRC and ADR6 is between ADDR and ADDR.

The idea is to pass the customer number in KAN1 and get the address number through which we pass in ADRC to get the postal address and with the same address number we pass in ADR6 to get the email of the customer.

Im not getting any output for this combination. Can you please help?

[Former Member]

Hi Vinod,

TRY THIS, It may work.

Take table knvv, kna1& adrc

Make join between KNVV & KNA1 through KUNNR & create 2nd join between KNA! & ADRC through ADRNR from KNA1 & ADDRNUMBER from ADRC.

Regards

San

[p391977]

This message was moderated.

[former_member675784]

This message was moderated.

[Lakshmipathi]

Dear Vinod

Try with the following:-

In table KNVK you will get Contact person no (PRSNR) assigned to customer. From KNA1 you will get the adress no (ADRNR).

Pass ADRNR into ADR6-ADDRNUMBER and fetch ADR6-SMTP_ADDR

thanks

G. Lakshmipathi

[former_member605601]

if you want join you take two tables you have taken one kna1 i didnt find the two. select the table join and select the fields which you want and execute

[Former Member]

Problem is with the join fields. Join as mentioned below and execute the query:

1) KNA1-ADRNR to ADRC-ADDRNUMBER

2) ADRC-ADDRNUMBER to ADR6-ADDRNUMBER

Regards,

GSL.

[Former Member]

Did that but no luck