Skip to Content

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

Query

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.

Former Member
Former Member replied

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.

Regards

Ravi

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.

Regards

Ravi

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