Report to show customer without sales rep

[Former Member]

Dear Experts.

Is there anyway or any report to show customer that don't have sales rep tag to it in Partner Function?

[Former Member]

Hi Nehemiah -

I know this is very painful but if volume of customer is less then use following method -

1.Extract all Sold to Party's and their sales area in separate sheet

2.Create a query joining KNA1 and KNVP where partner function (PARVW) = PE ( or partner function of  Sales Rep).Download Sold to and its sales area in another sheet.

3.Now using excel compare both sheets by Vlookup and extract the customers from Step 1 which are not present in Step 2.

If the volume of customer is very large,then we can also use MS Access Queries otherwise we can simply write an ABAP Program.

Let us know, if you need more explanation on any of the method explained above.

Thanks & Regards

Amit Gupta

[Former Member]

hi

check for the Sold-to-party whose partner function PE is not available...........

regards

satish

[Former Member]

Hi,

I believe there is no such standard report but you can try with table KNVP in SE16N.

Go to the table Se16N.....Unselect all the selection parameters and select ONLY Customer and Partner Function and execute. later you can filter on the Partner function column.

You can also try VC/2 but the problem is that its a fact sheet and it is slow . It is OK for a single customer if you wanted to see what all PF the customer has.

Regards

PJ