Skip to Content
0

Query for sales employee details

Feb 16, 2017 at 08:14 AM

41

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers