Need to know the list of cstmers used in more than one Distribution channel

[Former Member]

Hi,

I want a list of customers that are used in more than one Distribution Channels in one of my business client.

Is there any shorcut to achieve this?

[Former Member · Accepted solution]

Hello Friend,

Check for the Table KNA1VV.

[Former Member]

Hello,

Suggest you create a little quick query (transaction SQVI) -- join tables KNA1 (so you can restrict by desired account groups) and KNVV (has channel assignment along w/sales org). Then you can see where customer assignments lie including when there are or aren't multiple assignments. Give it a try.

[Former Member]

Hi,

You can use the table KNVV in SE16n... I am not sure about any other shortcut for this.

Hope this may help in solving your problem.

Thanks