cancel
Showing results for 
Search instead for 
Did you mean: 

Query for sales employee details

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (0)