Skip to Content
avatar image
Former Member

Report Customer's Ship-To Parties and address information (Ship-to Report)

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 12, 2016 at 03:29 AM

    Did you remove the proposed link between KNA1 and ADRC (DATE_FROM to ERDAT) and create a manual join link on ADRNR between these two?

    Also, I hope you added KNVP-PARVW, KNVP-VKORG, KNVP-VTWEG, KNVP-SPART as list and selection criteria.

    I tried the SQVI in my sandbox and the joins worked.

    Add comment
    10|10000 characters needed characters exceeded