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?
Ravi Mansharamani 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.
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.
Edited by: Ravi D Mansharamani on Mar 26, 2008 2:21 PM