How to see all customers having more than one ship to party?

[Former Member]

Dear Friends,

How can I see a list of customers having multiple ship to parties.

Please hlep me to get the solutions. Your help will be highly appreciated.

Best regards

Raghu ram

[Former Member]

Dear Raghu,

Good Day,

Table KNVP.

U Can try below Code in ABAP.

Query :

select kunnr,count(parvw) from knvp where PARVW = 'WE' group by kunnr, PARVW having count(parvw) > 1

Parter Function : "SH" Stored in table as "WE"

Best Regards,

KSK

[Shiva_Ram]

Hi,

Use transaction code SE16, enter the table KNVP table.

Fill the data like sales org, and enter the partner function as SH. Then in the partner counter field enter > symbol and 0 as value. Then execute. The system will display the list of customer numbers with multiple ship-to party.

If a customer number carries multiple ship-to party, then when a user creates a sales order, the system displays all the ship-to party numbers assigned to the customer (sold-to party) and the user has to select the one ship-to party.

Regards

[Former Member]

Hi Raghu,

use table

KNVP - Customer partners Master table

Thanks,

Raja

[Lakshmipathi]

Dear Raghu ram

Go to SE16, input Table KNVP and execute.

thanks

G. Lakshmipathi