Skip to Content
author's profile photo Former Member
Former Member

Query for sales employee details

I am facing an issue while creating a query which will display the data from KNA1, KNB1, KNVV, KNVP, ADR6, PA0002 and PA0105.

The fields I am displaying are customer number, address, company code, sales org, personnel number (which I believe is Sales Employee), First name and last name of sales employee and his email ID.

When Icreated the query it only displays the data for sales employee which are having email ID. which means it displays only those customers if a customer has sales employee with email ID

I created the query in SQVI and SQ01 but it only displays the data as mentioned.

Is there any way I can have both data i.e. customer without sales EMP and with sales EMP (alos with and without employee email ID

Add comment
10|10000 characters needed characters exceeded

0 Answers