I'm trying to create a SQVI report linking three tables: KNA1, KNVP and ADRC. I want to generate a list of business partners of a customer and their respective address information (from ADRC). I think I understand the logic, but I'm not sure of execution.
What I want is KUNN2=KUNNR and then have the ADRC report the address information. I've tried multiple ways of joining the tables, but can't seem to get it correct. Is this possible? It seems odd that SAP doesn't have a generic ship-to report to list this type of information.