contact person of partner function sales orders

[Former Member]

Hi,

i need to save in all the sales orders the contact person. But i need to know who is the contact for the AG partner and the contact for RE ,....

How can i do? How i know the contact person is from who partner function.

Thanks

[Former Member · Accepted solution]

Hello Friend,

Go to Table KNVP(Customer Master Partner Functions) and give the relevant customers to get the partner function attached to that related partner.

[Former Member · Accepted solution]

ok, thanks.

the problem is if i have the same partner AG and RW, for example, how can i know who is the contact person of AG and the contact person o RW. Consider AG and RW is the same customer, but i have 2 contact person diferents.

Thanks

[jignesh_mehta3 · Accepted solution]

Dear Friend,

Option 1:

From KNVK you can get Customer-wise Contact Partner Details.

From KNVP you can get Partner Function-wise (AG, RE, etc) details of Customer codes.

Now take these data into Excel & run a Vlookup. You will have a ready list of Partner Function-wise Contact Persons.

Option 2:

You can gererate a Query in SQ00 & Link KNVK & KNVP Tables.

Hope this helps...

Thanks,

Jignesh Mehta