Skip to Content

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

Creating query (SQ01) about customer data

Hello experts,

I'm creating one query about customers data

The tables involved in query are: KNA1, KNVV, KNVP, PA0002 and ADR6.

Table ADR6 contains the email address of customer, but not all customers have the emails address informed. Therefore not all customers have record in this table.

When I execute query, the customers without any record in ADR6 are not displayed in the list.

How could I display on the query list also the customers without record in ADR6 ? (Displaying BLANK as e-mail address).



Former Member
Former Member replied


While linking Tables to ADR6, put ADR6 Right side of the other table, click on joint and make sure that is only connected with the customer number, delete all other joints (if there).

Execute again, sure u will get.



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