Partner function report

[gomatheeswaran_palaniappa]

Hi,

We have one requirement to take the list of customers in all the sales areas who have all the defined partner functions except Group customer, Master customer and Owner IBU (Z functions).

Any pointers on this will be of great help.

Thanks and Regards,

P Gomatheeswaran.

[Former Member · Accepted solution]

Hi,

You can get this by following tthis

1. Goto SE16

2. enter table KNVP

3. On the partner type Click on the Arrow for multiple selection.

4. Click on the single values with red light

5. Enter the partner funciton which is not required

6. Click on copy in bottom

7. Execite it.

Thanks,

Raja

[gomatheeswaran_palaniappa · Accepted solution]

Hi Raja,

Thanks for your response. But the solution is not fulfilling.

Hope, I have not clearly described my case. Let me explain. Pl take a customer, for example 200000043. This has been extended to all sales areas. This customer has payment terms SP, SH, BP, PY except GC, MC, OI in some sales areas. The GC, MC, OI functions are common irrespective of sales area. So, I need to identify in which sales area this data is missing and fill it. In other terms, I need the data which is not in KNVP table

From the solution provided I can get the data of SP, SH, BP, PY for all customers and all sales area. That is not required in my case.

Thanks & Regards,

P Gomatheeswaran

[Former Member · Accepted solution]

Hi There,

If you have created the customer with partners then it will definitely be in KNVP, as it records all the Customer partner.

As per my understanding of your requirement do this :

1. Find all the Customers with GC, MC, OI partners.

2. Find all the customers with SP, BP, SH, PY partners

3. Filter the customers

The easier way is take help of ABAPer write a small code and filter the customer.

Thanks,

raja

[Former Member]

Hi

Edited by: bahlrohit1 on Jul 7, 2009 3:06 PM

[Former Member]

Hi

Can Get the same from Customer Master Partner Function Table KNVP and not selecting the three partner functions using NOT EQUAL TO , Red Light Icon in Partner Function Field (PARVW).

Rohit