Which ship to party assigned to sold to party

[former_member358181]

Hi,

I have created the ship to party & assigned the sold to party. How can find out which ship to party assigned to the same sold to party? Is it available in any standard report in sap?

Pl provide the solution for above requirement

Useful answers duly rewarded

Regards,

Devendra

[Lakshmipathi · Accepted solution]

Dear Devendra

run table KNVP

thanks

G. Lakshmipathi

[former_member358181 · Accepted solution]

Dear G. Lakshmipathi,

Thanks for replay, I have run table KNVP for showing the customer code but I want the customer code & name.

Can you tell which table shows the customer name?

Regards,

Devendra

[Lakshmipathi · Accepted solution]

Dear Devendra

If you would like to have the customer name also, then you have to table join in SQVI with the combination of tables KNA1 & KNVP.

thanks

G. Lakshmipathi

ps:- If your issue is answered, please close the thread with points

[Former Member · Accepted solution]

Lakshmipathi:

Quick question which tcode will help you to run that table ? Also how do you do table joint ?

Vanbills

[Lakshmipathi · Accepted solution]

Dear vanbills

SE16 - TCode to run any table

SQVI - If you want to join multiple tables

thanks

G. Lakshmipathi

[Former Member]

Hi deva,

I think there is no standard report to find which ship to party is assigned to sold to party

But we can find out in customer master records only in sales area data.

Thanks

Sarvesh

[former_member358181]

Dear Sarvesh,

Thanks for replay, but I want to any standers report or table.

Regards,

Devendra