SD partner name

[Former Member]

Hi experts,

I want to findout the table for partner name where it getting stored.

va02-click on "Display doc.header details" icon(beside PO date),Click partners tab,there you can see "NAME" field for parters.

Just iam looking for <b>table</b> for Parter names...

Thanks

kaki

[Former Member]

Hi experts,

I want to findout the table for partner name where it getting stored.

va02-click on "Display doc.header details" icon(beside PO date),Click partners tab,there you can see "NAME" field for parters.

Just iam looking for <b>table</b> for Parter names...

Thanks

kaki

[Former Member]

Not sure of the question - Which partner are you interested in? All of the partners attached to the sales order will be displayed uisng the screen navigation that you mentioned. What else are you looking to find?

[former_member186741]

you need to join the VBPA table with KNA1 to get the name,

something like this:

SELECT SINGLE kna1~name1

from vbak

JOIN vbpa ON vbpa_{vbeln = vbak}vbeln

AND vbpa~posnr = '00000'

JOIN kna1 ON kna1_{kunnr = vbpa}kunnr

INTO KNA1-NAME1

where vbak~vbeln = ???

and vbpa~parvw = ??.

Message was edited by: Neil Woodruff

[Former Member]

Hi experts,

I found in KNVK table..

Thanks for all the replies..

cheers

kaki

[former_member186741]

Kaki, I don't think KNVK is the correct table for partners relating to speciific sales docs, eg VA02. I think you need VBPA.

[Former Member]

KNVK is "true" customer master. If you are looking for the partner info about a particular sales order, you MUST start in VBPA - SALES ORDER PARTNER table.