Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A


hello, friends.

i am trying to do SQVI query for tables KNA1 and ADRC. my intention is to display customer number, name, Street, Street 2, Street 3 and Street 4.

however, there seems to be no link between these 2 tables. what are the other tables i should join with the above and in what sequence?

many thanks.


Hi jonathan yap,

Go to table KNA1, put ur customer number and get the field - Address Number ( ADDRNUMBER )

Now take this address number and go to table ADRC

Now as per as your question

Street 2 = STR SUPPL1

Street 4 = STR SUPPL3

Street 5 = LOCATION

Hope this will solve your query

So based on these two tables your query should work.

Reward points if helpful.



Hi John,

I think if you are in SQVI, and you have done table join for KNA1 and ADRC .

Then delete the default link that you can see by right click -> delete link

Now go to KNA1 table and find field name - ADRNR and select it and create your own manual link to tabel ADRC - field ADDRNUMBER.

This should surely work.

Reward accordingly.



Edited by: Ravi D Mansharamani on Mar 26, 2008 2:21 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question